Towards spreadsheet programming
Microsoft Excel introduced the LAMBDA function in February 2021, which officially made Excel a real programming language. Spreadsheet is not just a pack of buttons and clicks, tips and tricks; there are fundamental programming concepts underneath. This course aims to reveal them to you to revolutionize the way you see and use spreadsheets.
-
Most of the contents presented by the course apply to any spreadsheet software including Microsoft Excel and Google Sheets. All the demonstrations in the course are on Microsoft Excel.
-
Both experts and beginners of Excel are encouraged to enrol in this rare course. As this course presents "fundamentals" of spreadsheets, beginners will quickly become an Excel expert and get a very high starting point.
-
Besides "fundamentals", we made efforts to make this course "practical". We illustrate every concept with carefully selected and concrete examples, which are repeated throughout the course. You could apply concepts, methods, skills and tools of this course immediately to your daily job.
Course curriculum
-
2
Spreadsheet Risks
-
Spreadsheet Overview
-
Risks in Excel
-
Spreadsheet Risks
-
-
3
Spreadsheet Language
-
Functions and Formulas in Mathematics for Beginners
-
Functions and Formulas in Excel for Beginners
-
Excel Functional Programming
-
Functional Programming Languages and Spreadsheet Language
-
LAMBDA Function
-
Dynamic Arrays and 6 new functions
-
-
4
Spreadsheet Programming
-
My collection of powerful formulas for common array/table/list/set operations
-
Results of these formulas will surprise you!
-
Types and Verification
-
Efficiency
-
Formula Editing and Formatting
-
Optimization
-
-
5
Conclusion
-
Conclusion
-
Instructor
Tie Cheng
Tie began learning programming in middle school. After his master's degree, he worked in investment banks where he became passionate about spreadsheets and Excel. He then pursued a PhD at Inria & ENS Paris & École Polytechnique, specifically in spreadsheet language and programming. He is now CEO of Matrix Lead, a spin-off of Inria. They undertake technology transfer and research, and make software, especially programming tools, for spreadsheets. He also gives lectures in universities and companies (see below). In 2021, he decided to carefully make this online course to benefit a larger audience.
Although today low-code no-code is a hot topic, Tie believes that there are still lots of people who want to learn coding, master the power of computing and building, and gain this knowledge and intelligence. Tie and his team aims to help these motivated people code better through their software and teaching.
Purchase the course
1) Students who promote the course in their social networks such as LinkedIn, Twitter, Instagram can be rewarded with 10 euros, before or after the purchase.
2) If the course did not match your expectation, you could request the full refund, anytime.
3) For any issue, please email [email protected].
Public lectures
The public paid lecture of "Spreadsheet Language and Programming" at École Normale Supérieure de Paris gathered more than 100 students and professionals. "Magnificent!", "Humorous!", "Mind-blowing!" are the most heard feedbacks.
Professional training to companies
"Our employees learned a lot, from fundamentals to applications, from this 3-hour training. Hope Tie could have more time and come more often." from Yejun FAN, CEO of AlorsFaim.
Invited lectures at universities
Regular invited lectures in spreadsheets at universities such as Mines ParisTech, CentraleSupélec and Paris Dauphine University (photo) to students in finance, data visualization, etc.
Student Reviews
Course Introduction
Apostolos Triantafyllou
Fantastic and eye-opening introductory course. Congrats to the author. I recommend it to all professionals that lack language programming skills and rely h...
Read MoreFantastic and eye-opening introductory course. Congrats to the author. I recommend it to all professionals that lack language programming skills and rely heavily on Excel.
Read Lessawesome !
Eloy Urrutia
outstanding !
outstanding !
Read LessWell done
Massimo Salese
I liked this intruduction.
I liked this intruduction.
Read LessSpreadsheet Language and Programming: Spreadsheet Risks
Marcel Lapointe
The language is clear, easily understood. But the flow is rather slow. The meat of this tutorial comes after this session, I mean "Spreadsheet Language" and ...
Read MoreThe language is clear, easily understood. But the flow is rather slow. The meat of this tutorial comes after this session, I mean "Spreadsheet Language" and "Spreadsheet Programming". Overall, it's a very good tutorial.
Read LessThis course helps a lot!
Allison Chan
Easy understandable, very useful for work!!!
Easy understandable, very useful for work!!!
Read LessExcellent tutorial
evy peng
Tie provides a very detailed explanation with a novel knowledge points. This tutorial really helps me to improve my excel skills, I will recommend to my fri...
Read MoreTie provides a very detailed explanation with a novel knowledge points. This tutorial really helps me to improve my excel skills, I will recommend to my friends in need. Thank you!!
Read LessRefreshing
Shirley YANG
When I used excel before, the main focus was on specific use, such as which function to choose, and there was no clear concept of “programming”. This set of...
Read MoreWhen I used excel before, the main focus was on specific use, such as which function to choose, and there was no clear concept of “programming”. This set of courses has given me a new way of thinking, which allows me to think about how to solve problems from a deeper level, rather than just solving the specific situation on the surface.
Read LessAwesome formation！
Lianxiong XU
This course helps a lot on progressing your excel skill, had a new understanding and mastered a lot of new skills！
This course helps a lot on progressing your excel skill, had a new understanding and mastered a lot of new skills！
Read LessTrusted by
Chinese version
There is also a Chinese version of this course "表格语言和编程".
