Understanding key data structure concepts is critical for any modeller who wants to efficiently perform data analysis in Power BI. Watch to hear from Microsoft Certified Data Analyst and Power BI specialist Sue Bayes.
Summarise the outputs of your financial model using standard Excel skills into a concise, dynamic and visually appealing one-page dashboard report which can effectively communicate the results of your model to be easily interpreted and understood by others at a glance. (more…)
As a consultant starting on a new project, I’d always prefer to start a new model from scratch – but that rarely happens! Normally we modellers have to take apart, check and validate a model that’s already been built by another modeller and when this happens, you can either start over and build your own model from the ground up or validate and verify the existing model to the extent that you’re comfortable to take responsibility for the calculations. Starting over to build your own model from scratch is inefficient and a waste of resources. Unless the model is in extremely poor shape, it’s usually far more efficient to use what you already have — but leave no cell untouched during the process of validation and verification.
In this special interview we talk about travel, work/life balance, the highs and lows of starting a business, the privilege of working for yourself and plans for the future.
During all this, we attempt to NOT talk about Excel or financial modelling! (more…)
The Financial Modeling World Cup (FMWC) competition brings competitive modellers from all over the world and different backgrounds together online each month to learn, train, compete and improve their financial modelling skills through case studies. This session was organised by the Queensland CPA Business Committee Financial Modelling discussion group and co-hosted by Jessica D’Souza and Danielle Stein Fairhurst.
We know that forecasting does not stop at the end of the financial year, and that updating models is both a significant effort and risk factor. Learn to build a rolling forecast, including dynamic formulas and dynamic seasonal linear trends using standard Excel functions.
When you take over and start using a financial model that someone else has built, not only are you inheriting the original modellers’ inputs, assumptions and calculations, but you may also be inheriting their mistakes! Using someone else’s model involves taking responsibility for their work and you want to be confident it’s working correctly. Hear from financial modelling specialist, Danielle Stein Fairhurst during the Financial Modelling Summit as she draws from the second edition of her book, Financial Modelling in Excel for Dummies, to learn some simple ways to check, audit, validate and, if necessary, correct legacy models so that you can be confident of the model’s results. (more…)
This mini-masterclass with Financial Modelling in Excel specialist Danielle Stein Fairhurst shows various techniques for building scenarios into financial models. This session explores how to reduce uncertainty in decision-making with sensitivity and scenario analysis techniques, applying in-built standard spreadsheet tools, and understanding the inputs, assumptions and drivers when creating forecasts. (more…)