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 🙏

Course Curriculum

Available in days
days after you enroll
  X Functions
Available in days
days after you enroll
  Named Functions
Available in days
days after you enroll
  Over To You
Available in days
days after you enroll


Your Instructor

Ben Collins
Ben Collins

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..

Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a full refund.
Will I get copies of the Google Sheet files?
Yes! All of the templates are freely available to you so you can create your own copies.
I know a different way to do this! What gives?
Yes! No doubt some of you will know, or find, different ways to do these things. In spreadsheets, there are often a million different ways to achieve the same result, and my answers are but one way!
Can you answer my question on XYZ?
Whilst I'd love to be able to help everyone out individually, I simply don't have time to answer every single email that comes my way with spreadsheet questions. Note, students of my premium courses get access to our private Facebook Q&A group, where questions do get answered ;)

Get started now!