Pro lesson · 5 exercises · first one free
More modern functions: XMATCH, SEQUENCE, LET and TAKE
About this lesson
Find positions, generate number lists, name parts of a formula and cut the first rows of a list.
Modern Excel and speed · 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
- Finding the position of a value
- Generating a list of numbers
- Naming parts of a formula with LET
- Keeping only the first rows of a list
- Knowing which functions need a newer Excel
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.