Audit & Forensic Analytics in Excel

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Set overall materiality for Brightwater Supply Co. from a benchmark, derive performance materiality and the trivial threshold, and test the misstatements found.
• Build an expectation for each expense account, measure the variance and flag the accounts the audit team has to investigate.
• Size a monetary unit sample for Kestrel's receivables, set the interval and pick the customers to confirm with MATCH on cumulative amounts.
• Match ten purchase lines of Brightwater's payables, flag quantity and price exceptions and size the amount over-billed.
• Scan March's 16 vendor payments for possible duplicates and round amounts, then size the money at risk.
• Run a first-digit test on 60 vendor invoices, compare it with Benford's law and measure how far the data deviate.
• Screen Brightwater's year-end journal entries for weekend postings, after-hours postings and unusual users, then add up the high-risk entries.
• Compute Brightwater's FY2026 DSO and gross margin, compare the growth of receivables with revenue and decide whether the trend is a red flag.