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
Comments
Sign in or become a Financial Modelling Handbook member to join the conversation.
Just enter your email below to get a log in link.