How to set up a Change Log sheet in your model

The Change Log sheet gives you a process for structured tracking of changes to your model. Hopefully, in the future, this will become redundant when Microsoft implements proper change tracking in Excel.

This Chapter covers setting up the Change Log sheet. Once the sheet is set up, read the Change Logging process guidance.

Start model

If you're starting your model build process using this start model, there's nothing you need to do. The Change Log sheet is included and ready to go. Make sure you have the latest version of the Productivity Pack to use the Change Log shortcuts.

Adding the change log to an existing model

If you have already started working on your model, the guidance below will help you add the Change Log sheet.

This post is for subscribers only

Already have an account? Sign in.


Sign in or become a Financial Modelling Handbook member to join the conversation.
Just enter your email below to get a log in link.

Subscribe to Financial Modelling Handbook

Don’t miss out on the latest financial modelling guides. Sign up now to get access to the library of members-only guides.