Using Excel's auditing tools

Posted on
6,002 Points
Last Modified:
Experience Level: Intermediate
Bob Flisser
Bob Flisser has authored many courses and books about Microsoft, Adobe and Apple products, and has been a computer trainer since the 1980s.
It’s easy for worksheets to get complicated, where it isn’t clear which data cells feed into which calculations. If calculations throw errors, it might not be immediately difficult which input cells are contributing. The auditing features show visual indicators to make it easier to see how the sheet works.
Author:Bob Flisser
The colour setting for coding in the VB editor (VBE) of Microsoft Office is a left-over from a past century. Here is how - with a few steps - to bring new life to the ancient editor.
The Data Visualizer (DV) add-in for Excel provides a powerful, fast way to build flowcharts and swimlane diagrams from data. And you don’t even need a Visio license to make this magic happen!

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month