courses.matrixlead.com Open in urlscan Pro
2606:4700::6812:1e85  Public Scan

Form analysis
0 forms found in the DOM

Text Content

Skip to main content


TIE'S CLASSROOM

Toggle menu Menu
 * 
 * Sign In
 * Start Now


SPREADSHEET LANGUAGE AND PROGRAMMING



Buy €39,00 Free Preview


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
   
    * Introduction
      
      FREE PREVIEW

 * 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 chengtie@gmail.com.
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


AWESOME !

ELOY URRUTIA

outstanding !

outstanding !

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




CHINESE VERSION

There is also a Chinese version of this course "表格语言和编程".
Check the Chinese version


© Copyright Tie's classroom 2024
Teach online with Thinkific Open in a new window