SPECIALISTS IN FINANCIAL MODELLING

Thinking about entering the Financial Modeling World Cup? Here’s some advice.

If you’re going to compete this year, now’s the time to get in at the beginning of the season. Still undecided? Not sure if your skills are good enough? I’m gonna level with you. They’re probably not. You’ll most likely fail spectacularly. The competition is brutal and heart breaking but the experience is invaluable. You’ll dread the next round but won’t be able to wait. Just do it – your career will thank you.

(more…)

Financial Modeling in Excel for Dummies 2nd edition

Dummies Book coverThe second edition of Financial Modeling in Excel for Dummies is now available! The first edition made it into the bestsellers list (for books on spreadsheets that is 😊) and here’s what it says on the back cover:

Turn heads with stunning financial models

It’s not the kind of modeling where you get to strike a pose, but it can still be fun, we promise. Financial Modeling in Excel For Dummies is your no-hassle guide to using the Microsoft Excel application to build beautiful financial models of all shapes and sizes. Project finance, pricing, valuation, reporting—it’s all in here, as we show you how to generate answers using Excel’s powerful functions and features. Together, we’ll make sure those numbers add up. We’ll even help you present the output so that your boss will understand it.

(more…)

Dummies Cheat Sheet

The cheat sheet for “Financial Modeling in Excel for Dummies” is also now available!  All Dummies books include cheat sheets which summarise important themes or content from the book into a single place. The cheat sheet is publicly available on the Dummies site, and you can access it without purchasing the book. Here’s what’s covered in the cheat sheet:

Essential Excel Functions for Building Financial Models

Financial modelling is ALL about the functions! Basically, the whole point of building a financial model is so that when the inputs change, the outputs change as well – so a good financial modeller will know lots of lots of functions.  Check out my list of favourite Excel functions. (more…)

Virtual Meetup | Excel Online: how useful is it for financial modelling?

Major improvements are being made with Microsoft Excel Online. It is completely free, works on any browser and is particularly useful if you need to share files and collaborate with others. It’s basically a slimmed-down version of Excel and although Microsoft is constantly working to improve the functionality, what we want to know is *can we use Excel Online yet for financial modelling?* (more…)

Virtual Meetup | Bend it… Don’t Break It! – Bulletproof Model Designs for Non-Excel People

Have you ever built a fantastic Excel model only to have the user “break” it almost straight away? Building a model widely available for anyone to use is very different process to building one for other modellers. If your model is going to be operated by non-Excel users, the challenge is to build a robust model that will stand the test of time but is simple for others to follow as well as bullet-proof so that they can’t mess it up. (more…)

Reducing Errors with Financial Modelling Best Practice

Much of what we call “best practice” in financial modelling is really just common sense and will make your life a lot easier as well as reduce the possibility of error when building your models. Hear from financial modelling specialist, Danielle Stein Fairhurst as she covers important do’s, don’t, tips and tricks of of financial modelling best practice.

(more…)

Virtual Meetup: I didn’t know Excel could do that EITHER

Following on from “I didn’t know Excel could do THAT”, join us once again to hear from Excel legend Bob Umlas who will take us through some of his best Excel tips and tricks. Prepare to be amazed! Bob received the first ever Microsoft Excel MVP award back in 1993, continued to receive it for 25 years after that and is still the longest-running MVP. (more…)

Skills Needed for Financial Modelling (and how to get them)

Skills Needed for Financial Modelling There’s no doubt that having good Financial modelling skills is fantastic for your career but there’s a lot more to it than being good at Excel! Finance & accounting, design, logic and numeracy to name a few. And should you put “financial modelling” your resume? Hear from financial modelling specialist, Danielle Stein Fairhurst explore some of the other skills you need, and how to get them.

(more…)

Financial Modeling World Cup Case Study Walkthrough with John Lim

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. 

(more…)