An introduction to Advanced Topics like Absolute/Relative References, Named Ranges and Best Practices

Lesson 1

FREE course with Ben Collins

Nested IF formulas, IFs with logic, SUMIF and SUMIFS formulas.

Lesson 2

All the counting functions! Count, Counta, Countblank, Countif, Countifs and Countunique

Lesson 3

Create drop-down lists for user inputs

Lesson 4

Includes

Use these free templates and what you’ve learned to create spreadsheet masterpieces.

Google Sheets Developer & Instructor

I'm an experienced data analytics instructor and freelance spreadsheet developer, helping businesses better understand their data through analytical insights and visualizations, including dashboards.

I work primarily with Google Sheets, Apps Script and Data Studio, and also have extensive experience with Excel, SQL and Tableau. I've previously taught data courses and workshops for General Assembly in Washington, D.C.

@2018 Collins Analytics LLC

All rights reserved

The Collins School of Data

- Access to all 30 video lessons
- Each lesson is 5 - 10 minutes
- All the starter templates
- All the solution files
- Best of all, it's free!

Practice, practice, practice!

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

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

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.

Yes!

I wanted to give back to the community and 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.

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

Make your spreadsheets look beautiful!

Lesson 5

Learn how to use VLOOKUP's hidden superpower

Lesson 6

$0

.00

A must-learn formula for Advanced Sheets users!

Lesson 7

Like a dating service for spreadsheet cells

Lesson 8

The more laid back version of the VLOOKUP

Lesson 9

The secrets you need to know to work with dates in Sheets

Lesson 12

Another lookup function?! The rare one

Lesson 11

One lookup formula to rule them all!

Lesson 10

Returning values that pass the tests set by the function

Lesson 13

The most powerful formula in Google Sheets

Lesson 14

One for the connoisseur

Lesson 16

Do the impossible with your formulas

Lesson 17

Your ticket to bring data from one Sheet to another

Lesson 18

Powerful formulas to import data into Sheets

Lesson 19

The proper way to do searching, extracting and replacing in strings

Lesson 20

Create mini charts inside single cells to show trends

Lesson 21

Two hard-working little functions worth knowing

Lesson 22

Count rows and columns, and create vectors for Array Formulas

Lesson 23

Humble formulas that are useful tools to have in your arsenal

Lesson 24

How to do the hard stuff with the powerful QUERY function

Lesson 15

Running total calculations using Matrix Multiplication

Lesson 25

How to create datasets that behave "normally"

Lesson 26

A useful but underused function, with some surprising features

Lesson 27

The correct way to reference Pivot Table data

Lesson 28

Create tables of contents or link to websites

Lesson 29

Some esoteric formula tricks to finish with

Lesson 30

Fix the following errors: