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.

Watch Intro Video

Introduction Preview

Course curriculum

  • 1

    Introduction

  • 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].
Start Now

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

5 star rating

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 More

Fantastic 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 Less
5 star rating

Well done

Massimo Salese

I liked this intruduction.

I liked this intruduction.

Read Less
4 star rating

Spreadsheet 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 More

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 "Spreadsheet Programming". Overall, it's a very good tutorial.

Read Less
5 star rating

This course helps a lot!

Allison Chan

Easy understandable, very useful for work!!!

Easy understandable, very useful for work!!!

Read Less
5 star rating

Excellent 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 More

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 friends in need. Thank you!!

Read Less
5 star rating

Refreshing

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 More

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 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 Less
5 star rating

Awesome 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 Less

Trusted by