My love of Financial Modelling and Excel is always leading me to new and exciting places. I just returned from Perth yesterday where I presented the one-day Data Analysis & Dashboards as a closed private in-house workshop. Next week I’m also looking forward to travelling and presenting at the PASS conference in San Jose, California for a couple of days.
We recently held a Meetup for the Brisbane Modellers’ Meetup group and I’m pleased to say that the video is now available below. The speaker Eris O’Brien is a highly experienced modeller and at this informative presentation he took a look at the basics of incremental cash flows for both new, standalone projects, and for projects at existing sites, to see if we can isolate the incremental effects, or
(more…)
During this webinar, online trainer, Danielle Stein Fairhurst led us on a short technical demonstration of how to create scenarios using plain Excel without any add-ins or other software. Reduce uncertainty in decision making using built-in standard Excel tools to reduce volatility in outcomes by performing sensitivity and scenario analysis to mitigate risk. Danielle demonstrated tools such as manual selection, data tables and scenario manager, and then took some brief questions relating to scenarios from the general attendees.
You can view the recording below. The recording features several Excel files and if you would like a copy of the accompanying Excel files as well as the Power Point Slides, please enter your details to access the Files.
When you decide your financial models are not as good as they should be, should you immediately send your team on an advanced Excel training course? Whilst this is certainly helpful, there’s a great deal more to financial modelling than being good at Excel!
No, it’s not a silly question and since the “Modern Excel” was introduced in 2010, the changes have been pretty subtle and it can be a little difficult to tell the difference.
There are a few rules for model design that should be followed when designing the layout of a model. Most experienced modellers will follow these instinctively, as they are generally common sense.
Extract from Using Excel for Business Analysis, Chapter Two
Model design and structure can be one of the most difficult parts of building a financial model. Typically, modellers will work from back to front when building their model. The output, or the part they want the viewer or user to see, will be at the front, calculations will go in the middle, and source data and assumptions should go at the back. The image below shows an example of what your tabs in a well-structured model might look like.
I’ve been showing this video supplied by Microsoft in my training recently, and lot of people have asked me for a copy, so here it is! Some of my favourite new features in Excel 2016 are:
