Should you use Macros in Financial Modelling?

Macros in Financial Modelling

Many aspiring modellers think that they need to be proficient in macro building in order to become serious financial modellers. Whilst it’s not a bad idea to have a working knowledge of macros—and the language they are built in, Visual Basic for Applications (VBA)—it’s certainly not critical for a financial modeller to become a super VBA programmer. As we know, the best sort of financial model uses the simplest tools and introducing macros to a financial model brings a whole new level of complexity.


What does a Financial Modelling Consultant do?

If you’ve ever wondered what a financial modelling consultant does, watch this pilot video for the new series by “What’s that Job?” Designed to help school leavers find out more about different professions, we discuss what a typical day looks like, preconceived notions about financial modelling and other aspects of the modelling life.  We discuss:


Virtual Meetup I Are Excel’s Power Technologies suitable for Financial Modelling?

When people think about financial modelling or forecasting in Excel, what comes to mind is worksheets loaded with formulae, built in a report-focussed layout. Watch as Ken Puls showcases examples of using Excel’s Power Technologies to build Financial Models and Forecasts for clients. From data shaping with Power Query to DAX in Power Pivot, these tools play an essential role in modern financial modelling solutions.


Virtual Debate: Google Sheets versus Microsoft Excel

Google Sheets is gaining popularity but how does it stack up against its rival Microsoft Excel? Many of the recent Excel enhancements were inspired by Google Sheets – or is it the other way around? Join us for another virtual debate to hear from two Microsoft MVPs Alan Murray and David Benaim as we compare the two and debate which tool provides the best modelling features.

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.


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.


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