← All learning paths

Google Sheets Foundations

Start with the interface, cells, formatting and sharing.

2 topic clusters Β· 42/42 published lessons

1Beginner GuidesCore Beginner GuidesMini-course Β· 40/40 lessons β–Ύ
1
Google Sheets for beginners
Beginner
Start lesson β†—
1
Create your first spreadsheet
Beginner
Start lesson β†—
1
Understand rows columns and cells
Beginner
Start lesson β†—
1
Format numbers and currencies
Beginner
Start lesson β†—
1
Sort data in Google Sheets
Beginner
Start lesson β†—
1
Filter a spreadsheet
Beginner
Start lesson β†—
1
Freeze rows and columns
Beginner
Start lesson β†—
1
Share a Google Sheet safely
Beginner
Start lesson β†—
1
Protect ranges and sheets
Beginner
Start lesson β†—
1
Create a dropdown list
Beginner
Start lesson β†—
1
Use conditional formatting
Beginner
Start lesson β†—
1
Build your first chart
Beginner
Start lesson β†—
1
Import CSV files
Beginner
Start lesson β†—
1
Print and export a sheet
Beginner
Start lesson β†—
1
Understand cell references
Beginner
Start lesson β†—
1
Navigate the Sheets toolbar
Beginner
Start lesson β†—
1
Use the formula bar and name box
Beginner
Start lesson β†—
1
Rename duplicate and color sheet tabs
Beginner
Start lesson β†—
1
Move and copy rows and columns
Beginner
Start lesson β†—
1
Insert and delete cells safely
Beginner
Start lesson β†—
1
Resize and auto-fit columns
Beginner
Start lesson β†—
1
Wrap text and align cells
Beginner
Start lesson β†—
1
Merge cells without losing data
Beginner
Start lesson β†—
1
Apply alternating colors to tables
Beginner
Start lesson β†—
1
Create checkboxes for task lists
Beginner
Start lesson β†—
1
Use smart chips in a spreadsheet
Intermediate
Start lesson β†—
1
Find and replace spreadsheet values
Intermediate
Start lesson β†—
1
Use keyboard shortcuts efficiently
Intermediate
Start lesson β†—
1
Undo restore and version history
Intermediate
Start lesson β†—
1
Create named ranges
Intermediate
Start lesson β†—
1
Use relative absolute and mixed references
Intermediate
Start lesson β†—
1
Use fill handle and autofill
Intermediate
Start lesson β†—
1
Create custom number formats
Intermediate
Start lesson β†—
1
Enter dates and times correctly
Intermediate
Start lesson β†—
1
Use data validation for clean entry
Intermediate
Start lesson β†—
1
Add notes and comments to cells
Intermediate
Start lesson β†—
1
Resolve comments and assign tasks
Intermediate
Start lesson β†—
1
Use filter views with collaborators
Intermediate
Start lesson β†—
1
Group and ungroup rows
Intermediate
Start lesson β†—
1
Hide and unhide rows and columns
Intermediate
Start lesson β†—
2TroubleshootingCore TroubleshootingMini-course Β· 2/2 lessons β–Ύ
1
Fix protected cell edit errors
Intermediate
Start lesson β†—
1
Fix spreadsheet sharing access errors
Intermediate
Start lesson β†—