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
![](https://import.cdn.thinkific.com/354361/jBfQJSTqR5SmfSFQr3iR_head%20copy.png)
Tie Cheng
Purchase the course
Public lectures
![](https://import.cdn.thinkific.com/354361/custom_site_themes/id/LtsFpFi0RKOz23fryvPg_Screenshot%202021-05-31%20at%2021.12.44.png)
Professional training to companies
![](https://import.cdn.thinkific.com/354361/custom_site_themes/id/I4lGnjfQayQlkVgrRKK4_Screenshot%202021-05-31%20at%2020.54.57.png)
Invited lectures at universities
![](https://import.cdn.thinkific.com/354361%2Fcustom_site_themes%2Fid%2FUd1EXilPS0GTmEr5qUr8_Screenshot%202021-06-01%20at%2014.23.28.png)
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
![](https://import.cdn.thinkific.com/354361%2Fcustom_site_themes%2Fid%2FDVs3HLSqSeC9LDBPxRIp_inria%20new%20new.png)
![](https://import.cdn.thinkific.com/354361%2Fcustom_site_themes%2Fid%2FzYKJAVdSV2ZYqSRLZbQK_ens%20new%20new.png)
![](https://import.cdn.thinkific.com/354361%2Fcustom_site_themes%2Fid%2FqunQjOMcQcSE9t7Ku7i3_ep_new.png)
![](https://import.cdn.thinkific.com/354361%2Fcustom_site_themes%2Fid%2FkCVpzSCQqaL0E9940cko_IMG_5323_copy-removebg-preview%20copy.png)
![](https://import.cdn.thinkific.com/354361%2Fcustom_site_themes%2Fid%2FIfotq78ZQ7uFAV8knhto_sp%20try.png)
Chinese version
![](https://import.cdn.thinkific.com/354361%2Fcustom_site_themes%2Fid%2Fy1wACYaQKmlvZQW2FoDw_Screenshot%202021-05-31%20at%2015.05.18.png)