Learn, live, love, breathe Financial Modelling in Excel! This group originally started as a spin-off from the very popular LinkedIN Financial Modelling in Excel online forum which has over 30,000 members all over the world. It's always nice to meet face to face, so if you live in Perth and use Excel for Finance, then we'd like to invite you to join us to network with like-minded professionals in an informal environment.
Best practice financial modelling in Excel has always been to enter your formulas in blocks. Enter a formula, then copy this across and possibly down also, making sure you have your absolute and relative references set correctly.
This is very useful because it is faster to build a model, easier to enter lots of formulas, less error-prone and easier to audit, all very desirable things when you’re constructing a financial model!
Excel’s dynamic array functions take this concept to a whole new level because they automatically copy themselves.
The dynamic array functionality has improved recently & now, with a bit of thought & planning, it can be applied to building a full financial model.
Come and see how these new functions are dramatically revolutionising financial modelling in Excel with a practical example of a full 3-way model where all formulas automatically copy themselves just by changing the number of periods.
- Introduction to Dynamic Array functions
- Application to financial modelling:
o Income statement
o Balance sheet
o Cash flow
- Considerations and questions to consider
**Free event** with drinks & nibbles provided afterwards by Access Analytic