Should you use 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.
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:
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.
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.
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.
The 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:
el for Dummies”, Danielle Stein Fairhurst explains ten useful strategies you can use to reduce error in financial models.
