Lambda Functions 10-Day Challenge
Master the new 2022 functions in Google Sheets: Lambda functions, X-functions, and Named Functions
Sign up to get immediate access to all 10 lessons. You can binge-watch them all if you want!
What are LAMBDA Functions and why should you care?
In August 2022, Google announced a batch of new functions for Google Sheets. And not just any old functions, but really, a new function paradigm.
The LAMBDA functions will change the way you work with your data. They let you turn any formula into a powerful array formula by introducing a new wave of function technology: lambda functions.
Named Functions will revolutionize your Google Sheet workflows by letting you create and share custom functions. Save yourself time by naming and reusing your popular functions. Save your colleagues from headaches by turning complex formulas into simple, named functions anyone can use.
And XLOOKUP and XMATCH will make your life easier when you're doing any kind of lookup work. (Pssst, you can finally lookup to the left with XLOOKUP!)
Who is this course for?
This course is intended for intermediate-level users of Google Sheets, who want to master the newest formulas in Google Sheets and unlock the full potential of their data.
You should be comfortable with basic formulas before taking this course, up to about the level of the VLOOKUP.
How is the course structured?
There are 10 lessons, consisting of a 5 - 25 minute video and an accompanying template.
I'd recommend trying one video each day for 10 days, so you give yourself time to digest and have a single focus for each day.
However, students with more experience might race through material they're already familiar with and finish the course more quickly (you get access to all 10 lessons instantly). Similarly, the course will be available and FREE for life, so the videos will always be there if you want to take longer or re-watch them at any time.
We learn through a series of examples, which you can follow in your own Sheet.
What you get:
- Immediate access to all 10 lessons...
- ...which equates to over 2.5 hours of video tutorials!
- 10 templates for each lesson that you can copy as many times as you want
- Certificate upon completion of the course
Why is this free?
I believe in giving back to this community and I want to say a big thank you to all those who have purchased one of my premium courses.
I get a lot of emails and questions about these new formulas in Google Sheets, so I see a clear need for some structured training on this topic. So here it is. ;)
I've poured a lot of sweat and tears into this course, so if you enjoy it and get some value from these lessons, you can "pay me" by sharing this with a friend or colleague who you think might benefit.
Thank you 🙏
Hi! I'm an experienced data analytics instructor and freelance spreadsheet developer.
I help individuals and businesses better understand their data through analytical insights and visualizations.
Over 50,000 professionals from 1,000+ companies have enrolled in my training courses, including employees from PwC, Netflix, Verizon, Google, Capital One, and other Fortune 500 companies.
My training has helped 1,000’s of people advance their careers. I’ve also helped small and large organizations migrate from Microsoft Excel and Office to Google Sheets and Google Workspace.
Google recognized me as a Google Developer Expert for Google Workspace Technology in 2019, one of only a handful worldwide.
I work primarily with Google Sheets and Apps Script, and also have extensive experience with Google Looker Studio, Microsoft Excel, BigQuery, SQL, and Tableau. I've previously taught data courses and workshops for General Assembly in Washington, D.C..