Level 3 - Advanced

Earning a Badge

If you would like to skip the Google Sheets Novice and Intermediate Levels and jump right into the Google Sheets Advanced Level, please work through each of these videos, and complete the same steps in your practice spreadsheet linked on each respective page.

Feel free to work through all three levels at your own pace and refer back to this site as you find the need.

We will cover:

IMporting Data

• app smashing

protecting Data

• protecting entire sheets
• hiding columns and rows
• hiding sheets
• protecting specific columns or cells

writing beyond-basic formulas

• count
• countif

formatting Data

• special auto-formatting
• dates
• phone numbers
• special formatting

querying data

• applying filters
• conditional formatting

Sheets Add-ons

• mail merge into an email

formulas

• countifs
• if...then