Pro lesson · 5 exercises · first one free
Tables, named ranges and other sheets
About this lesson
Turn data into a Table, give cells names, refer to other sheets, and keep headers in view.
Statistics, charts and tables · 5 short exercises in a live spreadsheet: answer questions that make you predict results or spot bugs and press the right keyboard shortcuts. Every answer is checked instantly.
What you'll practise
- Turning a range into an Excel Table
- Reading a structured reference
- Giving a cell a name
- Referring to a cell on another sheet
- Keeping the header row visible
Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 5, no account needed.
Pro lesson
Unlock the whole lesson
Pro unlocks every lesson, the case studies and unlimited weak-spot review. The fundamentals track stays free.