Modern Excel: Dynamic Arrays
What you will be able to do
- Use spilling formulas
- Filter, sort and de-duplicate with formulas
- Reshape data with VSTACK, TAKE and CHOOSECOLS
- Write reusable formulas with LET and LAMBDA
17 lessons and projects. Short, practical steps in a spreadsheet, with real Excel for the features a browser cannot run.
Outline
Module 1: Spill basics
- Spilling, the # reference and #SPILL!
- UNIQUE
- SORT and SORTBY
- FILTER
- FILTER with several conditions
- SEQUENCE
- VSTACK and HSTACK
- TAKE and DROP
- CHOOSECOLS and CHOOSEROWS
Module 2: Reshaping data
- GROUPBY
- PIVOTBYReal Excel
- LET
- LAMBDA basics
- Named LAMBDA functions
- BYROW and MAP
- Self-updating reports: FILTER + SORT + UNIQUE
Project: self-updating customer report
Completing it earns a certificate of completion. It is not an accreditation or a professional qualification.
Start free