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.


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.


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

What’s the difference between a Formula and a Function in Excel?

Ever been guilty of using Excel as a fancy calculator?  If so, you’d just be using a formula in Excel.  If you entered a calculation such as =A1+A2 or =452*12, then that’s just a formula.  If a formula is all you need, then that’s fine.  But Excel can do so much more!

You may hear the two words function and formula used interchangeably, but they’re not technically the same. So, what’s the difference? A formula is an expression that uses cell references or hard-coded numbers to calculate the value of a cell. Sometimes a simple formula is all you need to get the right answer, but you can do so much more using functions.


Intro to Dashboard Reporting in Modern Excel (Interactive Workshop)

Dashboard Reporting in Modern ExcelWith the huge amount of data available to us every day, a well-built and visually appealing dashboard is one of the best ways to interpret and communicate large quantities of information. Learn to quickly and effectively communicate the results of your analysis to be easily interpreted and understood by others at a glance. Hear from Excel modelling specialist, Danielle Stein Fairhurst as she provides an introduction to her popular online workshop “Dashboard Reporting in Modern Excel”. (more…)