LEARN BY DOING

Learn Google Sheets with a clear path forward.

No more guessing what to learn next. Start with the foundations, practice in real spreadsheets, check your understanding, then progress into formulas, dashboards and automation.

Find my learning path Browse paths All lessons

138 published lessons257 skill clustersQuizzes + hands-on practice

Suggested journeyFrom foundations → confident use

Sheets foundationsStart here

Practical formulasUnlock next

Analysis & dashboardsUnlock next

AutomationAdvanced goal

START IN THE RIGHT PLACE

Choose how you want to progress

Paths turn individual lessons into a guided sequence instead of a loose article library.

All paths →

Path 1

Google Sheets Foundations

Start with the interface, cells, formatting and sharing.

103/163 lessons22 clusters

Open path

Path 2

Formula Mastery

Build from core functions to dynamic formulas.

15/190 lessons15 clusters

Open path

Path 3

Data Analysis & Reporting

Clean, explore and summarize practical datasets.

10/294 lessons80 clusters

Open path

SHORT LESSONS — REAL USE

Fresh lessons to put into practice

Each lesson focuses on one skill with examples, checkpoints and a clear next step.

View all →

Full Google Sheets interface with the file title, menus, toolbar, expense tracker, frozen header, filters, summary and sheet tab.

Beginner Guides

Google Sheets for Beginners

Create your first spreadsheet with a real expense tracker. Learn cells, formatting, filters, sharing, SUM, AVERAGE and COUNT with verified screenshots and results.

11 min readStart lesson →

beginner-guides

Create your first spreadsheet

Build a real four-column task tracker with a frozen header, status dropdowns, valid due dates and a matching practice workbook.

11 min readStart lesson →

Google Sheets Example tab showing A1:D4 with headers Item, Qty, Unit price and Line total; the menu, formula bar and sheet tab are visible.

beginner-guides

Understand rows, columns and cells

Learn how to read Google Sheets cell addresses, select ranges and calculate line totals with a four-row practice table.

9 min readStart lesson →

Full Google Sheets interface with the complete A1:D5 example, numeric prices, VND currency displays and formula-derived totals.

beginner-guides

Format numbers and currencies in Google Sheets

Format real numbers as Vietnamese đồng, calculate item totals and keep the underlying values numeric.

10 min readStart lesson →

Google Sheets Data menu with Sort range expanded and Advanced range sorting options visible.

beginner-guides

Sort data in Google Sheets

Sort an order table without separating customers from their orders.

8 min readStart lesson →

Filter controls are visible in all three header cells, with the pointer on the Status filter control.

beginner-guides

Filter a spreadsheet

Complete “Filter a spreadsheet” using the visible Task, Owner, Status sample so each action and the final state can be checked against the source data.

11 min readStart lesson →

REFERENCE WHEN YOU NEED IT

Learn in sequence. Look things up on demand.

Paths are for structured learning; the function library and tools are for solving a specific problem right now.

Function reference →Templates →Tools →

ƒx

SUMAdds numbers in a range.

=SUM(B2:B10)ƒx

FILTERReturns rows that satisfy a condition.

=FILTER(A2:C20,B2:B20>100)ƒx

QUERYRuns a query over a data range.

=QUERY(A1:C20,"select A, B",1)