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

Never opened a spreadsheet before? Start with the guide. Otherwise, jump into the essentials.

Guide: Google Sheets from Zero to One10 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 overviewGuide: Apps Script Zero to OneAutomation 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

Get weekly Sheets tips in your inbox.

Short, practical Google Sheets and Apps Script updates — no noise, just formulas that work.