Excel Practice Spreadsheet Audit

Prompts

Excel Inherited Workbook Takeover Review

Understand and assess a workbook someone else built.

Spreadsheet Audit / Excel Practice
Excel Filtered Totals, Hidden Rows and SUBTOTAL Mistakes Audit

Find totals that silently include or exclude rows.

Spreadsheet Audit / Excel Practice
Excel Number Format, Rounding and Displayed Versus Stored Values Audit

Find cases where what you see is not what is stored.

Spreadsheet Audit / Excel Practice
Excel Regional Settings, CSV Import and Date Format Audit

Prevent day-month swaps and decimal comma problems.

Spreadsheet Audit / Excel Practice
Excel Workbook Version and File Naming Practice Audit

Check how a team saves, names and shares versions.

Spreadsheet Audit / Excel Practice
Excel Chart Source Range and Labelling Accuracy Audit

Check that charts show the data they claim to.

Spreadsheet Audit / Excel Practice
Excel Cleaned Table Quality Check After Cleaning

Prove that a cleaned table is complete and nothing was lost.

Spreadsheet Audit / Excel Practice