ExcelAnalyzer Video Tutorials
DOWNLOAD EXAMPLE WORKBOOKS
Highlighting Unique Formulas
ExcelAnalyzer highlights all Unique Formulas which allows the user to quickly see how the worksheet was built and makes it very simple to identify inconsistencies when formulas are different from each other.
In this example the green highlighted formulas in cells F7-G7 don’t add up all rows above and should be fixed.
Video 1 - Introduction ExcelAnalyzer
Formulas Report
ExcelAnalyzer’s Formula report lists all unique formulas and helps in detecting inconsistent formulas and it contains a link to easily navigate and correct the issues in formulas.
ExcelAnalyzer uses a colour-coding method to make each formula easier to read.
Video 2 - Unique Formula Report
Detailed Report
ExcelAnalyzer highlights all Unique Formulas which allows the user to quickly see how the worksheet was built and makes it very simple to identify inconsistencies when formulas are different from each other.
In this example the green highlighted formulas in cells F7-G7 don’t add up all rows above and should be fixed.
Video 3 - Detailed Report
Model Flow Report
ExcelAnalyzer highlights all Unique Formulas which allows the user to quickly see how the worksheet was built and makes it very simple to identify inconsistencies when formulas are different from each other.
In this example the green highlighted formulas in cells F7-G7 don’t add up all rows above and should be fixed.
Video 4 - Model Flow Report
Review Report
ExcelAnalyzer highlights all Unique Formulas which allows the user to quickly see how the worksheet was built and makes it very simple to identify inconsistencies when formulas are different from each other.
In this example the green highlighted formulas in cells F7-G7 don’t add up all rows above and should be fixed.
Video 6 - Review Report
Review Panel
ExcelAnalyzer highlights all Unique Formulas which allows the user to quickly see how the worksheet was built and makes it very simple to identify inconsistencies when formulas are different from each other.
In this example the green highlighted formulas in cells F7-G7 don’t add up all rows above and should be fixed.