Latest — Apr 9, 2022 New to the Financial Modelling Handbook? Start here. Thanks for following the Financial Modelling Handbook Project.
The missing ribbon shortcuts in Excel for Mac The Accelerator Keys app promises to give you back the missing ribbon shortcuts in Excel for Mac. It very nearly does.
Apple has done us dirty Monterey, the latest version of macOS, no longer has Python built in. This left us with a tricky keystroke problem to solve.
Update: model maintenance 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
Update: Modelling productivity pack 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
How to find a balance sheet error 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.
How to analyse model differences using Variance tabs 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.
Structured commenting and feedback for financial model review Financial models must receive independent review. When reviewing somebody else's model, we need to leave comments and feedback as we go.
Complete list of productivity pack macro functions 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.
Range names needed for Productivity macros 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.