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:
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. 😉
Ben Collins is an experienced data analytics instructor and freelance spreadsheet developer, helping businesses better understand their data through analytical insights and visualizations, including dashboards. He works primarily with Google Sheets, Apps Script and Data Studio, and also has extensive experience with Excel, SQL and Tableau. He teaches data courses and workshops for General Assembly in Washington, D.C.
"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."
"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."
" 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."
"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!"
"Fantastic course, really well delivered and a great memory jogger."