Spreadsheet Basics
Start from zero with Excel or Google Sheets. Learn to create and save a file, find your way around, type and tidy data, write your first formulas, sort and filter a list, and print or share it safely. Then insert, delete and hide rows, use Find and Replace, remove duplicates, highlight cells and make your first chart. No experience needed.
- Digital skills
- Data and reporting
What you'll learn
- Create, name and save a spreadsheet, and find your way around cells, rows, columns and tabs
- Type and tidy data with clean numbers and dates, the fill handle and number formats
- Write your first formulas and functions, and use AutoSum
- Sort and filter a list, and print, save as PDF or share it with the right access
- Insert, delete and hide rows, use Find and Replace and remove duplicates
- Make your first column or line chart
The basics
- 1
Getting Started
6 min9 text and a 5-question quiz
- 2
Entering and Tidying Data
7 min9 text and a 5-question quiz
Using your data
- 3
Your First Formulas
7 min9 text and a 5-question quiz
- 4
Sort, Filter and Share
7 min9 text and a 5-question quiz
- 5
Rows, Find and Highlight
7 min7 text and a 5-question quiz
- 6
Your First Chart
5 min6 text and a 5-question quiz
The final assessment opens once every lesson is done.
What learners say
A sample review, shown until learners share their own.
- Sample
“I had never used a spreadsheet. By the end I made my first chart. I'd like a few more practice examples.”
Neha