In this module, you'll discover how to design hypothesis-driven pivot tables that answer targeted tax questions without creating data noise. You'll examine six standard tax pivot patterns and learn how row, column, and value selection isolates key trends, outliers, and factor shifts. Mastering these structures enables you to transform raw financial datasets into focused tax analytics. Tech disclaimer — covers Microsoft Excel 365 / 2021.

In this module, you'll learn to calculate effective tax rates (ETR), construct period-over-period variance tables, and analyze ETR walks to isolate rate drivers. You'll link financial statement and trial balance shifts to tax return variances and learn how to leverage AI tools safely to accelerate pivot table design without surrendering analytical judgment. Tech disclaimer — covers Microsoft Excel 365 / 2021.

In this module, you'll learn to navigate ONESOURCE exception reports and apply rigorous evidence-based logic to classify flagged items. You'll master the core classification rule—known, documented drivers equal Expected; unknown or undocumented drivers equal Follow-Up—across seven common exception patterns. Practicing clear documentation standards prepares you to manage compliance queues efficiently without under-flagging risk or over-burdening reviewers. Tech disclaimer — covers ONESOURCE Tax Provision / Compliance (as of August 2026).

In this final module, you'll learn to synthesize tax analytics, variance tables, and exception reviews into a structured, seven-section analytical insight memo. You'll master the distinct purpose of each section—from headline to CP1-level recommendation—and practice presenting evidence-based observations that streamline senior review. Completing this module prepares you to deliver professional, review-ready tax analysis artifacts.