Auditing an Excel spreadsheet

A free course covering how to audit an Excel spreadsheet using the tools available in Spreadsheet Professional by Spreadsheet Innovations.
If you prefer to attend a live session, visit the MS Excel Advanced Courses Calendar
Modules
Spreadsheet Errors and what you can do about them
Finding inconsistent Excel formula with Maps
Lessons
Prioritise which formula to look in for errors
Lessons
- Prioritise the cells to look at in a spreadsheet review Free Preview
- Find Unused Input Cells Free Preview
- Find Unused calculations in the spreadsheet Free Preview
- Find inconsistent formula dependents in excel Free Preview
- Find numbers in Excel formula Free Preview
- Find references to blank cells Free Preview
- Find all Lookup functions in Excel Free Preview
- Find Formulas with no reference to other cells Free Preview
- Find references to error cells Free Preview
- Find references to non numeric cells Free Preview
- Find formula that refer ahead of themselves Free Preview
- Find formula that refer to hidden cells Free Preview
- Find all IF functions Free Preview
- Find all NPV functions Free Preview
- Find unprotected formula cells Free Preview
- Find complex formula in Excel spreadsheets Free Preview
- Test the unique formula in Excel Free Preview
- Find external links in Excel spreadsheets Free Preview
- Find range names in Excel Free Preview
- Warn if Excel using manual calculations Free Preview