20 January, 2018
Last month I posed the question why, yet again, we didn’t see any female faces in finals of the 2017 ModelOff Financial Modelling World Championships.
15 January, 2018
Once we’ve finished creating a model, we then need to communicate the findings – often in the form of a PowerPoint slide. So what do we often see? A spreadsheet copied directly into the slide. In the example below, we’ve created business case and we’d like to present the financials. We can’t decide what to show, so we’ll just display everything. Nasty!
This kind of spreadsheet-on-a-slide results in far too many numbers being in the presentation, and leads to the audience being inundated by data and overwhelmed by detail.
15 December, 2017
Copying and pasting charts or tables directly from Excel into PowerPoint is not a straightforward as it sounds! When you are embedding charts, tables or (heaven forbid) a spreadsheet into a PowerPoint slide, it’s best to paste the image in as a picture or JPEG.
If you do a straight Control-C Control-V copy and paste, the original Excel file is automatically embedded in the PowerPoint document and this is not usually recommended, for a number of reasons;
08 December, 2017
Congratulations to Alvin Woon, the new 2017 ModelOff Financial Modelling World Champion! Every year, 16 ModelOff finalists are flown to compete at the Microsoft headquarters in New York or London. Yet again, not one female made it to the finals and when the organisers posted an image of 16 finalists of varying age, ethnicity and background – but all male - it predictably sparked a storm of online criticism.
29 November, 2017
There’s nothing quite like experience to really hone and sharpen your Excel modelling skills. Every hour that you spend nutting through a problem on the job means that the next time you come across a similar problem, you’ll solve it in a matter of minutes, not hours. This is especially true for creating complicated Excel formulas, or for model design and layout.
24 October, 2017
I’ve come across a lot of preconceptions (and misconceptions) about the idea of financial modelling; many people think it sounds very elaborate and esoteric, even mystical. Some question whether the skill is a science or a creative tradecraft in the industry, and I’ve even heard suggestions that it’s a dark art! But what is financial modelling really – an art, science, or just plain magic?
I was pleased to be invited to speak again this year at the ModelOff Sydney Global Training Camp (GTC) held at the Microsoft Offices last week. It was, as always a great learning and networking event and I thoroughly enjoyed spending a solid two days surrounded by others who also get very excited about financial modelling!
11 August, 2017
I’m often asked what degree of skill level one needs to be able to include financial modelling as a skill on your resume or LinkedIn profile. Once you’ve got an idea of exactly what is financial modelling, what is involved in the modelling process and you feel like you’ve got a good knowledge of financial modelling skills that you have used in the workplace then – yes – “Financial modelling”
14 July, 2017
There are all sorts of complicated definitions of financial modelling, and in my experience there is quite a bit of confusion around what a financial model is exactly.
A financial model is a structure (usually built in Excel) to solve real world financial problems mathematically, containing dynamic and flexible inputs and outputs.
21 June, 2017
Danielle Stein Fairhurst was recently interviewed on a live webinar with The Outperformer, a career management platform on the topic of "Adding Financial Modelling to your Tool kit - a Must for any Accountant". Financial modelling is now one of the most sought-after skills in the accounting job market but there’s a lot more to being a good financial modeller than just having good Excel skills.
06 June, 2017
Building valuation models requires a specialized knowledge of valuation theory (using the different techniques of valuing an asset), as well as modeling skills. If you’re a casual financial modeler, you probably won’t be required to create from scratch a fully functioning valuation model. But you should at least have an idea of what types of valuation financial models are out there.
Here are three common types of valuation financial models you may encounter:
10 May, 2017
Now that my new book “Financial Modeling in Excel for Dummies” is finally available, a lot of people have been asking me about the writing process and how it all came about. I think what they want to know but are too polite to ask is “what on earth were you thinking?” and I must admit that I asked tha
07 April, 2017
"Financial Modeling in Excel for Dummies" is finally here! The book launch of Danielle Stein Fairhurst's brand new book, a comprehensive beginner's guide to building financial models was held in early 2017. Photos of the launch can be found on the Facebook Page.
Date: 25th May 6pm
Venue: Dymocks Sydney, 424-430 George st
05 April, 2017
Financial Modeling in Excel For Dummies is now available on Amazon! Here's what Amazon have to say about the book:
08 March, 2017
It's no secret that financial modelling is an industry that lacks gender diversity and that is particularly shown in the ModelOff Financial Modelling World in which very few women make it to the finals.
23 February, 2017
I am just completing the final edits of my new book, Financial Modeling in Excel for Dummies and one of the finishing touches is to make sure we have the spelling right!
23 February, 2017
Financial models sometimes don’t start out life intended to be a full-fledged financial model. You might start fiddling in Excel, and go from there. In its most basic form, a model might start its life as a rough calculation or a “back of an envelope” scribble – something that can help you make the most basic of financial decisions such as; how much money do I have left when the bills have been paid? Those useful little calculations that help you plan whether you can afford to renovate your house.
14 December, 2016
Last week Danielle Stein Fairhurst was interviewed by John Michaloudis for his very popular MyExcelOnline Podcast. During the interview they chat about what it means to be a financial modeller, Danielle's upcoming book "Financial Modeling in Excel for Dummies", ModelOff Financial Modelling Championships, and online training.
Here are some things mentioned in the podcast:
Excel is the backbone to any custom built financial model, and one of the core attributes of a financial modeller is to have good technical Excel skills. When struggling with their financial models, some managers’ first reaction is to send their staff on an advanced Excel course to improve their modelling skills. However, with training budgets under constant scrutiny you really need to make sure that you get the best value out of your training options.