⏬More info and copy of the file⏬
Excel Dynamic Array formulas are amazing and can allow you to develop an automatically expanding forecasting model.
We even see what happens when Jeff adjusts it to show 16,000 months!
Jeff flags a few techniques and functions for getting this to work
Presented by Jeff Robson, founder of Access Analytic.
File
aasolutions.sharepoint.com/:f...
00:00 Intro
02:26 Demonstration
07:24 Referencing vertical and horizontal arrays
08:30 Using BYCOL to sum individual columns from an array
10:55 Using * instead of AND
12:20 Calculating Opening and Closing Balances using SUMIFS
15:24 Using + instead of OR
17:12 Calculating Depreciation
17:50 Quickly switch from 8 month to16,000 month forecast!
21:10 Summarise Outputs
22:12 NPV What-if table
23:10 Cashflow and circular references
25:38 Add new items and insert rows wherever you need
11 июл 2024