0 item(s) $0.00 AUD + GST

Financial Modelling Articles

20 January, 2018

Financial Modelling Champions; where are the girls?

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.

Read more Comments (1)

15 January, 2018

Excel Spreadsheet on a PowerPoint Slide?

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. 

Read more Comments (0)

15 December, 2017

Pasting Images from Excel into PowerPoint

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;

Read more Comments (0)

08 December, 2017

Gender Equality in Financial Modelling

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.

Read more Comments (14)

29 November, 2017

Why every Excel model you build makes you a better modeller

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.

Read more Comments (0)

24 October, 2017

The Magic of Financial Modelling

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?

Read more Comments (3)

14 September, 2017

Financial Modelling World Championships and Certification

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!

Read more Comments (0)

11 August, 2017

Should I put “financial modelling” on my resume?

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”

Read more Comments (0)

14 July, 2017

What is Financial Modelling?

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.

Read more Comments (0)

21 June, 2017

Webinar: Adding Financial Modelling to your Tool kit - a Must for any Accountant

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.  

Read more Comments (0)

06 June, 2017

Financial Modelling for Valuations

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:

Read more Comments (0)

10 May, 2017

Q&A on writing “Financial Modeling in Excel for Dummies”

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

Read more Comments (0)

02 May, 2017

Dummies Cheat Sheet

The Excel files used in this book can be downloaded here.

Read more Comments (0)

07 April, 2017

Book Launch Party - Financial Modeling in Excel for Dummies

"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

Read more Comments (0)

05 April, 2017

Financial Modeling in Excel for Dummies

Financial Modeling in Excel For Dummies is now available on Amazon! Here's what Amazon have to say about the book:

Read more Comments (0)

08 March, 2017

Financial Modelling Celebrates International Women's Day

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.

Read more Comments (0)

23 February, 2017

Are you a Modeler or a Modeller?

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!

Read more Comments (0)

23 February, 2017

The Lifecycle of a Financial Model

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.

Read more Comments (0)

14 December, 2016

MyExcelOnline Podcast Interview

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:

Read more Comments (0)

09 December, 2016

Do You Really Need an ‘Advanced Excel’ Course?

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.

Read more Comments (0)

Subscribe to our Newsletter

Enter your details below to keep up to date with the latest Financial Modelling Articles

* indicates required