New to the Financial Modelling Handbook? Start here.
Thanks for following the Financial Modelling Handbook Project.
More guides
Q&A: How to insert a copied row in Excel
"You used ctrl+x to cut the Annual Real O&M cost input from the bottom of the sheet, how do you go about pasting this in above?" - Angus
Productivity Pack update
I've just posted the latest version of the Productivity Pack macros. We've been working on this for several months. A lot of the focus has been on ironing out bugs and improving the underlying code.
We've also added a few new tools and updated the functionality of existing tools.
Check
How to check the conditional formats in your Excel file
Conditional formatting is extremely useful. You'll find it in several places in the Handbook models.
It's easy to lose track of all the conditional formats in your model. Excessive conditional formatting can cause file size bloat, and so we want to be able to check and remove conditional formatting easily.
How to batch delete unwanted Range Names
Deleting Range Names is fiddly and annoying. This tool deletes all your unwanted Range Names.
How to check for Range Name errors, unused Names and hidden Names
Range Names can be extremely useful. They can also be a mess if not well maintained.
AI multi-language model translation
Adding multi-language support for financial models
How to list unique formulas in your model
This is useful for model audits, and for general formula reviews.
How to create a list of hidden sheets in your model
Bad people are hiding things in your model. Don't let them get away with it.
The last few chapters
Looks like we're getting close to the finish line!