SheetFX

Start Here

Learn Google Sheets faster with a curated path.

This learning path stitches together the most important formulas, workflows, and automation ideas in the order that real spreadsheet projects demand.

Browse all functionsRead tutorials

Use this page as your home base. Work through each step, bookmark the resources, and return whenever you need a refresher.

Practical examples
Real workflows
Automation focus
Updated playbooks

1. Master the core formulas

Start with the essential functions you will use every day.

10 Essential Google Sheets FormulasSUMAVERAGE

2. Clean and transform text

Turn messy strings into clean, usable columns.

Text functions guideSPLITTEXTJOIN

3. Learn modern lookups

Replace legacy VLOOKUP patterns with flexible, readable lookups.

XLOOKUP guideINDEX/MATCH guideXLOOKUP

4. Filter and query data

Slice datasets with formulas that scale to thousands of rows.

FILTERQUERYSORT

5. Handle dates like a pro

Automate time-based reporting and scheduling logic.

Working with dates guideDATEEOMONTH

6. Build dashboards

Turn formulas into reliable, shareable reporting views.

Conditional formatting guideSPARKLINEIMPORTRANGE

7. Automate with Apps Script

Save hours with scheduled reports and custom menus.

Apps Script overviewScript snippets (coming soon)Automation playbooks

Free resources

Downloadable cheat sheets and snippets.

Grab curated resources that make it easy to apply what you are learning immediately.

25 must-know formulas cheat sheet (coming soon)
Apps Script starter snippets (coming soon)
Dashboard layout checklist (coming soon)

Newsletter

Weekly Sheets tips are coming soon.

We are putting together a short, practical newsletter for Google Sheets and Apps Script. Launching soon.