Excel
Add up numbers, keep lists tidy, and turn columns of figures into something you can actually read.
Lessons
18 lessons totalNot sure which lesson to open first? Take the five-question check and we will recommend a starting point for Excel.
- 2 minBeginner
Understand the grid
Learn what rows, columns and cells are before you put anything in them.
- 3 minBeginner
Type, edit and delete safely
Put text in a cell, change your mind, and undo a mistake without panic.
- 3 minBeginner
Save and reopen a workbook
Give your file a name, choose where it lives, and find it again tomorrow.
- 3 minBeginner
Select cells, rows and columns
Highlight exactly the boxes you mean, using the mouse or the keyboard.
- 3 minEasy
Add up a column with AutoSum
Total a list of numbers without writing a formula yourself.
- 4 minEasy
Write your first formula
Use plus, minus, times and divide to make Excel do the arithmetic.
- 3 minEasy
Average, smallest and largest
Three ready-made functions that answer most everyday questions about a list.
- 3 minEasy
Copy a formula down a column
Use the fill handle so one formula does the work of fifty.
- 4 minEasy
Make a sheet easy to read
Bold headings, borders and wider columns so nothing is cut off.
- 4 minEasy
Numbers, dates and currency
Tell Excel that 25 is money, or that 03/04 is a date, and it will behave.
- 3 minEasy
Sort a list alphabetically or numerically
Put names in order or find the biggest and smallest numbers in a list.
- 4 minIntermediate
Filter a list to see only what matters
Hide the rows you do not need right now without deleting anything.
- 2 minEasy
Keep headings on screen
Freeze the top row so you never lose track of which column is which.
- 4 minIntermediate
Make a simple chart
Turn a boring table into a bar chart that makes your point for you.
- 4 minIntermediate
Ask a yes/no question with IF
Get Excel to label rows automatically, like Pass or Review.
- 3 minEasy
Work with several sheets
Add, rename and move the tabs along the bottom of the window.
- 4 minIntermediate
Print a sheet that fits the page
Stop a spreadsheet spilling over six pages and repeat headings on each one.
- 4 minIntermediate
Understand common error messages
What #VALUE!, #REF! and ##### actually mean, and how to clear them.