This module covers the most common tax planning drivers found in tax schedules and workpapers—including timing differences, credit utilization, NOL usage, charitable carryforwards, and state apportionment shifts—and explains why each affects tax position, expense, or cash taxes. Using Microsoft Excel, you'll navigate prepared tax schedules, classify line items by driver category, and determine whether each should be documented, flagged for senior review, or escalated to a specialist. Recognizing these drivers quickly and accurately is essential for efficient tax review workflows that surface material issues without over-escalating routine fluctuations.

This module teaches you how to perform year-over-year comparisons in Excel and ONESOURCE to identify material changes in tax-related line items, apply CB1 materiality thresholds consistently, and distinguish true planning drivers from data entry errors or normal business fluctuation. You'll generate and interpret comparative views, apply variance rules (greater than 25% and greater than $10,000), and document findings appropriately—including basic forward-impact notes for timing differences expected to reverse. These comparison and threshold-application skills are fundamental to producing reliable, well-supported tax review work that senior professionals can act on with confidence.

This module focuses on constructing a clear, concise one-page planning driver summary that communicates findings effectively for senior escalation, covering all required fields: driver, magnitude, direction, trigger, authority, options identified, and open items. You'll learn to use research support appropriately to identify governing authority without making recommendations, incorporate forward-impact notes where relevant, and avoid common documentation mistakes including tool misuse and role confusion. Strong driver summaries enable faster senior review and demonstrate the professional judgment that distinguishes effective tax analysts.

This module introduces the purpose of tax-focused financial trend analysis, establishes the difference between factual commentary and speculation, and explains how trend analysis supports compliance review and basic liability assessment. You'll learn to identify the main concept categories used in tax trend review—ratios, variance commentary, and effective tax rate composition—and summarize the key components that influence effective tax rate. Understanding these foundations ensures your analysis stays defensible and evidence-based when reviewed by finance teams, auditors, or tax authorities.

This module covers how to compute key tax-relevant financial ratios in Microsoft Excel, including effective tax rate, cash tax rate, effective federal rate, effective state rate, and book-to-tax difference percentage, using correct formulas and denominators. You'll build a clean Excel model that ties ratio outputs to source financial data, distinguish among different rate measures, and recognize when a ratio falls outside a typical range and may warrant review. Accurate ratio calculation is essential because small formula mistakes—especially using the wrong denominator—can fundamentally change the story you tell about tax expense and cash tax movement.

This module teaches you to interpret three-year financial statement trends from a tax analyst perspective, identify likely year-over-year variance drivers across revenue, expenses, tax, state activity, and balance sheet accounts, and match each variance type to appropriate supporting documentation. Using Microsoft Excel and the Variance Investigation Playbook, you'll apply a structured approach to investigating outliers without overreaching conclusions and explain how deferred items and asset changes can drive tax return variances. These investigation skills ensure you can move from observing a changed number to identifying a supportable explanation that holds up under review.

This module focuses on writing factual variance commentary using the magnitude-plus-driver format, drafting one-sentence observations in a standardized reviewer-ready format, and distinguishing strong commentary from vague, speculative, or judgmental language. You'll learn to build and review an effective tax rate bridge from statutory rate to reported rate, apply practical review standards to flag unsupported analysis, and prepare a complete variance analysis report in Microsoft Excel. Mastering reviewer-ready commentary ensures your work can withstand scrutiny from senior reviewers, auditors, and tax authorities without requiring interpretation or follow-up clarification.

In this module, you'll learn the core purpose of early-career analytical tax insight work and why surfacing issues cleanly is essential to compliance workflows. You'll explore the three guiding principles of analytical review and practice distinguishing objective observations from inappropriate recommendations. This foundation ensures your analysis is reviewable, evidence-based, and ready to move forward in a corporate tax team.

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.