Full transparency of inner working of model with Inspect formulas!
- Decomposition of formulas into individual elements
- Tree-like structure to navigate formulas and dependencies
- Intelligent cell naming based on row and column headers
- Add cell watches to the model to keep track of critical values
- Realtime model editing and navigation

- Select a cell with a formula you wish to inspect
- Click ‘Inspect formulas’
- See all dependent cells for the currently selected cell in a tree structure
- Use the ‘Inspect formula’ panel to drill down on the selected formula. Double click to navigate to cells.
- See description for the currently selected formula
- Add Watches to the workbook by right clicking on a cell and press ‘Add to watches’
Was this article helpful?