Audit Analytics in Excel

This course was originally designed for a local chapter of the Association of Government Accountants (AGA). Their intent was to enhance their members audit analytics skills using a tool everyone had access to–Excel. This has become one of my more popular courses since.

It covers the following topics:

• detecting duplicates and gaps
• detecting anomalies
• merging data sets with VLOOKUP
• random sampling - simple and stratified
• Benford’s law and its application
• what-if analysis and Monte Carlo simulations
• costing with regression