logo
New Online Course

Modern Google Sheets

Work faster, smarter, and more confidently with Google Sheets in the AI era.

This Modern Google Sheets course will teach you how to:

Work smarter not harder, by using Gemini AI inside of Sheets.

Set up and benefit from using Tables in Google Sheets.

Integrate Google Sheets with Google Forms and Google Slides.

More effectively communicate ideas and insights using the Google Sheets chart tool

And much, much more!

ALL LEVELS WELCOME

Spreadsheets have changed.
This is how you catch up.

Google Sheets isn’t the same tool it used to be.

In just the past two years, AI has landed in our spreadsheets, tables have transformed how we structure data, and brand-new functions have unlocked possibilities that didn’t exist before.

But here’s the problem: most folks are still using the old ways of working in Sheets, taught in old tutorials, blogs, and courses.

That’s why I created  — a practical, hands-on course designed to bring you fully up to speed on the current best practices. You’ll learn not just the formulas and features, but the modern mindset for working in spreadsheets in the AI era.

Whether you’re analyzing data, building reports, or automating workflows, this course shows you the smartest ways to use Google Sheets today.

Transform Your Career with the Modern Google Sheets Course

Before: The Old Way

Wasting time doing slow, manual work.


Feeling frustrated doing repetitive, boring tasks.


Feeling tech overwhelm with the endless options with AI and not sure where to start.


Learning in isolation, with limited support.

Not using the full potential of Google Sheets.


Struggling to make Sheets look professional.

After: The Modern Sheets Way

Seamlessly using AI to generate formulas and code.


Leveraging the power of Tables for better data workflows.


Write better formulas with modern functions like LET.


Replace VLOOKUP with XLOOKUP 😎.

Staying up-to-date with latest features so you can use them immediately in your work.

Understanding Google Sheets inside-out and having a toolbox of best practices.

Testimonials for Ben's Other Courses

"This course is great for anyone who wants to learn the basics and get some hands on, practical experience. I was able to confidently use the skills I learned immediately in real projects."

Kathy Westbrook

"This course was perfect! Well paced and filled with great insights that will help me leverage AI in my daily work."

John Sowash, Sowash Ventures LLC

"Bite-sized, clear, actionable learnings that can make anyone using a spreadsheet better overnight. This is a great showcase of how AI can significantly elevate our productivity."

Kevin Scott, PGA of America

Overwhelmed by resources?

Upskill With Hands-on Learning

Get your Sheets work done quickly with AI, Tables, Automations, and best practices!

Learn the latest and greatest tools for working with data in your Sheets.

Make your boss and coworkers go "wow" with your new skills.

Clear learning pathways, to avoid overwhelm and level up your skills

Course Contents

Why they’re the new foundation for working with data and how to use them.

Deep dives on LET, LAMBDA, XLOOKUP, VSTACK, Named Functions and more.

Practical data cleaning workflows with Tables and Gemini AI.

Utilizing Gemini AI for data analysis, including creating and customizing pivot tables and data queries.

Data presentation in Google Sheets, including conditional formatting, effective data visualization principles, chart tools, and interactive elements.

A real-world case study using Google Forms for data collection, Google Sheets for AI-driven insights and Gemini AI to write automation code.

Live Workshops

In addition to the online course, I’ll be running two live, 90-minute workshops where you’ll learn with me in real time.

These sessions are designed to give you hands-on practice and a chance to ask questions. You'll leave with ready-to-use workflows you can apply immediately in your work.

  • Why Tables are the new foundation for data
  • How to keep your data clean with validation
  • AI in Sheets: prompting techniques and the AI Function

An end-to-end, AI case study: collect data with a Form, manage it in Tables, run AI analysis, and finish with a professional chart.

Each workshop will be repeated three times in different time zones, so you can join the date that works best for you.

Workshop 1 available dates and times:

  • November 4th from 12:00 – 1:30 pm ET
  • November 18th from 7:00 – 8:30 pm ET
  • December 2nd from 9:00 – 10:30 am ET

Workshop 2 available dates and times:

  • November 6th from 12:00 – 1:30 pm ET
  • November 20th from 7:00 – 8:30 pm ET
  • December 4th from 9:00 – 10:30 am ET

(Recordings of all sessions will be available to everyone in the Live Workshops tier.)

These workshops are the perfect complement to the course—you’ll not only learn the theory but also see it applied step-by-step and get answers to your own questions.

Meet Your Instructor

"Hello, I'm Ben Collins, Founder of the Collins School of Data.

I'm an experienced data analytics instructor and spreadsheet developer.

I help individuals and businesses better understand their data through analytical insights and visualizations.

Over 75,000 professionals from 1,000+ companies have enrolled in my training courses, including employees from PwC, Netflix, Verizon, Google, the UN and other Fortune 500 companies.

Since 2019, Google have recognized me as a Google Developer Expert for G Suite Technology, one of only a handful worldwide.

I also have extensive experience with Google Apps Script, Google Data Studio, Microsoft Excel, SQL and Tableau.

I previously taught data courses and workshops for the education startup General Assembly in Washington, D.C.."

20
+

Online courses authored

75000
+

Students trained

1100
+

Google Sheets  and Apps Script tutorials

Lesson Preview

Each lesson comes with a downloadable Google Sheets template you can reuse again and again.

And to give you a taste, here’s a short excerpt from one of the data cleaning lessons.

It shows you how to use data validation filters and people chips inside Tables to identify and fix errors in the data:


Enroll today and get:

Actionable, bite-size video lessons that walk you step-by-step through techniques

Access to the templates, which you can copy and reuse as many times as you like

Certificate upon completion you can put on your resume

Access to live workshops, teaching modern techniques in a live setting online (paid upgrade)

What folks say about Ben's other courses...

Modern Google Sheets Tiers

Our packages are tailored for maximum value and optimum learning.

Online Course Only

$99

Modern Google Sheets will teach you how to use AI, Tables, modern formulas, and other modern best practices in Google Sheets. Join today to access:

  • 34 online video lessons ✅ 
  • Unlimited access to the Google Sheet templates ✅
  • Prompt examples to help you get the most from AI tools ✅
  • Certificate upon completion ✅ 
Online Course + Live Workshops

$299

Join our small-group, interactive sessions where you can learn directly with me, ask questions, and see modern Sheets workflows applied in real time. Suitable for beginner to intermediate level users.

Includes everything in the online course, plus:

  • Access to two 90-minute live workshops ✅
    Workshop 1 available dates 11/4, 11/18, and 12/2
    Workshop 2 available dates 11/6, 11/20, and 12/4

  • Recordings will be available afterwards ✅

Frequently Asked Questions

When does the online course start and finish?

This course is online and completely self-paced. Start whenever you’re ready (it’s available right now if you want) and take as long as you want to 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.

How long does the course take?

Whilst the course has over 6 hours of video lessons, covering AI, Tables, modern functions and a host of other techniques, you don't have to watch them all, or watch them in a particular order.

Inside the course, I have a suggested lesson order for beginners, intermediates, and more experienced Sheets users.

What if I don’t have a technical background?

This course focuses on practical techniques and teaches concepts through real-world examples, so that you won’t get lost in abstract theories and dense lectures. As long as you aren’t afraid to roll up your sleeves and put some effort in, then you’ll be able to grasp the content of this course. You’re free to watch the lessons in any order and as many times as you like, so you can take as long as you want!

Will I get copies of the datasets and solutions?

Yes! All the templates and solutions are provided, so you can download your own copies. Clicking on the template links will make a copy on your Drive account.

Is this course suitable for beginners?

It is, if you're willing to invest the time. It does move quickly into the key topics of Google Sheets if you're a beginner, but you can watch the videos as many times as you like. Also, if you're past the beginner stage, you won't be bored.

What are the dates for the live workshops?

Workshop 1 available dates and times:

  • November 4th from 12:00 – 1:30 pm ET
  • November 18th from 7:00 – 8:30 pm ET
  • December 2nd from 9:00 – 10:30 am ET


Workshop 2 available dates and times:

  • November 6th from 12:00 – 1:30 pm ET
  • November 20th from 7:00 – 8:30 pm ET
  • December 4th from 9:00 – 10:30 am ET
I missed a live workshop. Will the recording be available?

Yes! All the live workshops will be recorded.

The recordings will be shared afterwards with everyone who signed up for the live workshop tier.

I bought the course only. But I want to now upgrade to the Live Workshops. Is that possible?

Yes, absolutely! We'd love to have you join us.

Reply to your course welcome email and I'll share the link for you to purchase the live workshops.

Why am I being charged VAT or Sales Tax?

In order to comply with EU and US State regulations, buyers may be charged a VAT or Sales Tax at checkout. This money is passed on to the relevant tax collection agency.

Can you provide an invoice for my company?

Yes, of course! You’ll receive a receipt after you purchase, but if you need something additional, please contact us and we can provide an invoice.

Hassle-Free, 14-Day Money Back Guarantee. No Questions asked!

Not satisfied? Our belief in the effectiveness of this course is so strong, we offer a full refund within 14 days!

Your tech journey is completely risk-free.

Unlock Your Full Spreadsheet Development Skills Now

Step into the modern spreadsheet world with industry-ready skills. 

Join us today!