Book 2 Supplementary Files:
- Chapter 2.1 - SP Examples of functions
- Chapter 2.1 - SP Multiple Criteria Examples with Comprehensive Example
- Chapter 2.1 - SP Multiple Criteria with OR
- Chapter 2.3 - SP Using OFFSET for Scenario Analysis
- Chapter 2.4 - SP Data Table Examples
- Chapter 2.5 - SP INDEX MATCH Examples NEW
- Chapter 2.6 - SP Tornado Chart NEW
- Chapter 2.7 - SP Simulation Examples NEW
- Chapter 2.8 - SP Variance Analysis
- Chapter 2.9 - SP Toilet Rolls
- Chapter 3.1 - SP Forecasting Examples
- Chapter 3.2 - SP Changing Forecast Periods
- Chapter 3.3 - SP Pro-Rating Over Time Example
- Chapter 3.4 - SP Aggregating Time Periods
- Chapter 3.4 - SP Allocating Weeks to Months
- Chapter 3.5 - SP Combining Historical, Actual and Forecast Data
- Chapter 3.6 - SP Chart Example File
- Chapter 3.6 - SP Rolling Budgets
- Chapter 3.7 - SP Maximum Cash Required
- Chapter 4 - SP Example Generic Inventory Model
- Chapter 5 - SP Depreciating Existing Capex Example
- Chapter 6.1 - SP Debt Sculpting Example
- Chapter 6.2 - SP Interest Rates Example Model
- Chapter 6.3 - SP Debt to Repay Examples
- Chapter 7 - SP Valuations Examples Book
- Chapter 7.1 - SP Case Study Model vLB1
- Chapter 7.3 - SP Calculating the Pre-Tax Cost of Equity
- Chapter 7.5 - SP Internal Rate of Return Summary Examples
- Chapter 7.6 - MIRR Example
- Chapter 7.7 - SP Capex Smoothing Example
- Chapter 7.8 - SP Economic Life Optimisation
- Chapter 8 - SP Example Export Model
- Chapter 8 - SP Example Import Model
- Chapter 9 - SP Section Numbering Example
- Chapter 10.1 - SP Dynamic Arrays Examples
- Chapter 10.2 - SP XLOOKUP and XMATCH Functions