Financial Modelling using Dynamic Arrays

Table of Contents

1. Introduction
2. Key Excel Functions
3. Key Excel Functionalities
4. Other Excel Pointers
5. Introducing Arrays
6. Dynamic Arrays
7. LET and LAMBDA
8. LAMBDA Helper Functions
9. GROUPBY, PIVOTBY, PERCENT OF, and ETA LAMBDAS
10. Best Practice Methodology
11. Layout Tips
12. Time Series Analysis
13. Error Checks
14. Model Template Example
15. Financial Statement Theory
16. Control Accounts
17. Repeatable Calculations
18. Example Model Build
19. Ratio Analysis
20. Going Out as a LAMBDA
21. And Finally...