Thanks for following the Financial Modelling Handbook Project.
I've long believed that the best way to learn something is to teach it. To increase my own knowledge and skill around data visualisation, I created this free introduction to data visualisation course as part of my teaching work with Full Stack Modeller. The course has proven to be pretty
The Accelerator Keys app promises to give you back the missing ribbon shortcuts in Excel for Mac. It very nearly does.
Monterey, the latest version of macOS, no longer has Python built in. This left us with a tricky keystroke problem to solve.
Welcome to the new followers who joined after I posted about the Handbook in the Modeller's Miscellany. I admit to being a little nervous about opening up the Handbook to a broader audience. But I guess it's out there now! Thanks for joining! Since my last update, I've been working
I think the finish line is in sight, although the list of placeholders on the table of contents seems to grow faster than the new links I'm adding. Here are the major additions since my last update: Productivity pack macrosWe've been pushing the productivity pack macros forward, improving old functions
Your balance sheet doesn't balance. You've been staring at it for hours, trying to figure out why. It's time to stop randomly paging around the model, hoping to find the error and apply a structured approach to identifying the cause.
The output sheet helps analyse and understand differences between model runs at a high level. Sometimes, however, we need to see how differences change over time, in more detail, and on specific line items that may not even be on our output sheet.
Financial models must receive independent review. When reviewing somebody else's model, we need to leave comments and feedback as we go.
Some references before you start: Download the latest version of the macrosGuidance on setting up the macrosCustomising the macros and changing the settingsRelease notes for the latest version of the macros[Download PDF of shortcuts] Hide / Unhide macrosCtrl+shift+7The macros file is designed to run in the hidden state.