Full transparency of inner working of model with Inspect formulas! - Next generation tools for Microsoft Office
  1. Ampler.io
  2. Resources
  3. Excel tutorials
  4. Formulas
  5. Full transparency of inner working of model with Inspect formulas!

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

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

Related Articles

Try free