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…)

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…)

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…)

Techniques for Better Forecasting in Excel

Techniques for Better ForecastingIt’s never been more important for business professionals to have the skills to build robust, flexible and dynamic forecast models. Using in-built standard Excel tools, we explore how to predict business outcomes and handle the volatile economic inputs we see in these uncertain times. Understanding the inputs, assumptions and drivers and the best way to incorporate them into forecast models is critical for accurate forward planning. We also discuss the best ways to deal with the unknown and evaluate several different forecasting techniques to perform analysis in Excel models. (more…)

Virtual Meetup: To Err is Human but to ISERR is Never OK!

Have you ever built a perfect financial model without any errors? Thought not! And for that reason, all good modellers know they need to include some error checks. But what is not as clear is how many error checks you should have, when you should include them and what form they should take. Excel “helpfully” provided us with functions like ISERR, ISERROR and IFERROR but as you progress your modelling journey you should learn to avoid these functions. Plus, you also learn the sad truth that Excel can’t even do basic maths sometimes! (more…)