Pro lesson · 5 exercises · first one free
References built on the fly: OFFSET and INDIRECT
About this lesson
Move from a starting cell by rows and columns, or turn text into a reference. Powerful, but use with care.
Lookups · 5 short exercises in a live spreadsheet: you type each formula yourself and answer questions that make you predict results or spot bugs. Every answer is checked instantly.
What you'll practise
- Moving from a starting cell with OFFSET
- Summing a block that OFFSET describes
- Totalling the last two entries of a list
- Building a cell address from text
- Knowing why these functions are risky
Functions you'll use
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.