REDUCE and SCAN: Running Totals, Compounding and Final Balances
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- LET: Name Your Intermediate Results for Readable, Faster FormulasFree
- LAMBDA Basics: Parameters, a Calculation and Calling It Inline Pro
- Named LAMBDAs: TaxPrice, MarginPct and Your Own Workbook Functions Pro
- BYROW and BYCOL: One Formula for Every Row or Column Pro
- MAP: Your Own Logic for Every Element, Even with AND and OR Pro
- REDUCE and SCAN: Running Totals, Compounding and Final Balances Pro
- MAKEARRAY: Multiplication Tables, Rotas and Payment Schedules Pro
- Capstone: Refactor a Nested Commission Formula into LET and LAMBDA Pro