Reading:
This Free New Course Will Turn You Into a Google Sheets Master
Image

This Free New Course Will Turn You Into a Google Sheets Master

Edward Shepard
December 6, 2017

Imagine if Yoda offered a free 30-day course designed to help you to upgrade your intermediate Force skills to full Jedi-mastery. 

Replace the word “Force” with “Google Sheets,” and you’ll see why we’re so excited for Ben Collins’ FREE new “Advanced Formulas 30 Day Challenge” Course.

This course is designed for intermediate users of Google Sheets who want to learn advanced formulas and unlock the full potential of their data.

It teaches 30 advanced formulas and techniques in 30 days, via  30 bite-size tutorials. You can take the course in sequence or jump ahead to the lessons you need now.

Ben Collins is one of the most respected authorities on Google Sheets. He has made numerous contributions to advancing the Google Sheets community. Along with his other premium courses, you can learn an enormous amount about Sheets from his blog.

The course features:

  • 30 lessons structured as 5 – 15-minute videos.
  • 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

The course puts an emphasis on practice:

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

Again, this course is free. Get it here. It’s your next step to Google Sheets Mastery.

The lessons of 30 days of Advanced Formulas:

  •  Preview DAY 1: CORE SKILLS (10:46)
  • Start DAY 2: IF (BEYOND THE BASICS) (11:14)
  • Start DAY 3: COUNTING FORMULAS (6:01)
  • Start DAY 4: DATA VALIDATION (10:27)
  • Start DAY 5: ADVANCED FORMATTING (13:13)
  • Start DAY 6: VLOOKUP & TRUE (5:40)
  • Start DAY 7: INDEX (6:23)
  • Start DAY 8: MATCH (6:11)
  • Start DAY 9: HLOOKUP (5:37)
  • Start DAY 10: INDEX & MATCH (9:14)
  • Start DAY 11: LOOKUP (5:29)
  • Start DAY 12: DATE FORMULAS (16:42)
  • Start DAY 13: FILTER (6:13)
  • Preview DAY 14: QUERY PART I (14:50)
  • Start DAY 15: QUERY PART II (11:00)
  • Start DAY 16: SUMPRODUCT (12:54)
  • Start DAY 17: ARRAY FORMULAS (15:04)
  • Start DAY 18: IMPORTRANGE (9:56)
  • Start DAY 19: IMPORT FORMULAS (14:11)
  • Start DAY 20: REGULAR EXPRESSION FORMULAS (REGEX) (19:45)
  • Start DAY 21: SPARKLINES (17:10)
  • Start DAY 22: INDIRECT & OFFSET (9:30)
  • Start DAY 23: ROWS & COLUMNS (8:55)
  • Start DAY 24: SMALL & LARGE (6:49)
  • Preview DAY 25: MMULT & TRANSPOSE (13:14)
  • Start DAY 26: FREQUENCY & RANK (13:41)
  • Start DAY 27: SUBTOTAL (8:03)
  • Start DAY 28: GET PIVOT DATA (7:04)
  • Start DAY 29: HYPERLINK (9:14)
  • Start DAY 30: OTHER ODDS & ENDS (10:32)

MORE FROM BEN COLLINS ON TILLERHQ.COM: “Essential Reading: 10 Tips for Creating Budget Templates in Google Sheets


Related Stories

5 Tips for Collaborating on a Budget in Google Sheets
January 31, 2019

5 Tips for Sharing a Budget in Google Sheets

Google Sheets makes collaborating on a budget easy. Here are five tips to help you get started.

How to use an Investment Spreadsheet
May 26, 2019

How to Make an Investment Tracking Spreadsheet with Google Sheets

An investment spreadsheet is one of the easiest and most versatile ways to track and truly understand your overall portfolio performance.

comparison report
April 29, 2018

Understand Your Spending With A Financial Comparison Google Sheet

Want to gain a better understanding of your spending and earning across time periods? Check out this quick financial comparison Google Sheet we put together to help you visualize your financial picture over two distinct time periods.

Arrow-up