If you regularly use MS Excel, you will know how difficult it is to find spreadsheet errors, and how many problems they can cause. Below you can see the benefits of using a tool, or just download the trial version of the software and learn how to use it on the Auditing Excel Spreadsheets page.
Download the trial version
If you are wanting to do the free Auditing Excel Spreadsheets course, or just want to try out some software to help find and eliminate spreadsheet errors, you can get your copy below.
When you click submit, you will receive an email with your trial license key and the download link. You can then proceed with learning how to use the tool to find your spreadsheet errors and eliminate them.
Features of the Excel Auditing Tool
Find inconsistent and overwritten formula
Easily spot the common spreadsheet error where a formula has suddenly changed in Excel. Below (1) is clearly copied all the way across (same color), but in (2) the formula suddenly changes in column R
Find the hardcoded numbers
Find the most common spreadsheet error by easily getting a listing of all the hardcoded numbers (as shown below) and investigate the ones that might be a risk. So below there seem to be formula that have 360, 365, and 365.25 (item 36 to 38) typed in. These all seem to relate to years, so does it make sense that they are all different?
Listing of all external links
Are you sure the spreadsheet links to the correct files? As shown below, you can investigate all the cells that contain a link to v5 instead of v6 of a reference spreadsheet.
Compare sheets that should be the same
Some of your sheets should look exactly the same (formula wise) with only differences in inputs. Do they? As shown below you can easily see where the formulas differ which helps find spreadsheet errors.
Understand the flow of the model
Understand how all your sheets talk to each other. As shown below, you can easily see how many links there are between sheets and whether it is ‘safe’ to delete a sheet. If deleting a sheet causes a #REF error, you can use this tool to find the cells that cross link and change them.
Look for errors in Pivot Tables, Conditional formats, Data validations and VBA code.
Easily find errors in hard to investigate places like pivot tables, charts, conditional formats, data validation and name ranges.
Issues with conditional formatting
Data validation errors
Documentation for Audit Purposes
Get a full listing of all the unique formulas in the spreadsheet with some color coding which will help show how you have tried to find the spreadsheet errors.
Download the trial version
If you are wanting to do the free Auditing Excel Spreadsheets course, or just want to try out some software to help eliminate excel errors, you can get your copy below.
When you click submit, you will receive an email with your trial license key and the download link. You can then proceed with learning how to use the tool to find your spreadsheet errors and eliminate them.