Here’s a list of my basic data analytic procedures for Excel.
As I add more posts to the series, I’ll update this list.
I created this series because:
1) I often get asked by new AND EXPERIENCED auditors how to do these tasks,
2) when I review workpapers, I realize too many auditors are not aware of these functions,
3) these functions can save you a lot of time, and
4) you don’t need fancy tools like Audit Command Language to do data analytics (move over, skyyler!).
Also, I wanted to provide a list of simple analytics all in one place that you can use to explore your data.
Why You Must Validate Data
Excel: Identify Duplicates
Excel: Remove Duplicates
Excel: Identify Unique Values
Check Excel Data for Blank and Invalid Values (Part 1 – Dropdown)
Check Excel Data for Blank and Invalid Values (Part 2– Sort)
Excel: Text to Columns
Transform Data Fast with Excel Flash Fill
More Advanced Topics
Real Auditors Use Excel PowerPivot
Stay tuned. More to come…..