Advanced Formulas 30-Day Challenge

Master 30 Advanced Google Sheet Formulas in 30 Days

Sign up to get immediate access to all 30 lessons. You can binge watch them all if you want!

How do you become a Google Sheets master?

Practice, practice, practice!

Do you feel like you've hit a plateau with your learning?

Ever wanted to see what all the fuss about INDEX-MATCH is?

Wish you could be better at manipulating data in your spreadsheets?

Well, this is the course for you. The best way to learn is to build stuff. You can read all the books in the world, but until you practice something for real yourself (and repeat, and repeat...) you won't get where you want to go.

Learn 30 advanced formulas and techniques in 30 days, with these 30 bite-size tutorials.

Who is this for?

This course is intended for intermediate level users of Google Sheets, who want to become more comfortable with advanced formulas 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 (although I do a very quick recap of that in lesson 1!).

How is the course structured?

There are 30 lessons, consisting of a 5 - 15 minute video, a starting template and a solution file.

I'd recommend trying one video each day for 30 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 30 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 anytime.

We learn through a series of examples, which you can follow along to in your own Sheet.

What you'll get:

  • Immediate access to all 30 lessons...
  • ...which equates to over 5 hours of video tutorials!
  • 30 starter templates for each lesson
  • 30 solution files for each lesson

Why is this free?

I believe in giving back to this community and I want to say a big thank to all those who have purchased one of my premium courses.

I get a lot of emails and questions about the more advanced formulas in Google Sheets, so I saw 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. 😉


Get started now!



"I've been watching and learning a lot. Thank you - thank you!

Amazed at your power formulas, especially happy about "Sort" and IMPORTRANGE. This will save me a lot of time! I have several projects where these will be quite useful."

- Lisa

"Thank you for the course!

I have found it to be incredibly useful!!!!!!

I can't wait to get through all of it. Perfect bite sized pieces and your voice and cadence is just perfect."

- Jesse

" I am loving this course - thank you for making it available for free! I'm in the middle of analyzing survey results for work right now, and so far I've used something from every lesson I've taken (and I've only done the first three!). I'm learning to realize that if I'm doing something annoyingly manual in sheets...there is a almost always better way."

- Breanna

"Thank you for the amazing content you are delivering in the Google Sheets course. Truly appreciate. You have helped me SO much with Sheets its ridiculous!"

- Kate

"Fantastic course, really well delivered and a great memory jogger."

- David

Course Curriculum


  Introduction to Advanced 30
Available in days
days after you enroll
  30 days of Advanced Formulas
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.
Will I get copies of the solution files?
Yes! All of the starting templates and the solution files are freely available to you. You'll find links underneath each video to create your own copies.
What if I discover a mistake or want to comment on the material?
Well, I'd really love to hear from you! Drop me a line here.
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 ;)
Will these videos be on YouTube?
I'm slowly releasing some of them on YouTube and as tutorials on my website (like this one), but if you really want to see all 30 lessons, your best bet is to sign up.

Get started now!