Thanks for following the Financial Modelling Handbook Project.
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.
In order to function correctly, there are a small number of cell ranges in the model that the Productivity Macros need to be able to use.