Before you write a single formula, the structure of your workbook determines how easy it will be to review, update, and trust. In this module, you'll learn how to organize a tax workbook so that every input has a home, every calculation is traceable, and the next person to open the file can follow your logic without asking questions. You'll also explore how cell protection keeps a well-built workbook from being damaged by accident.

This is where your workbook starts doing real work. You'll use SUMIF and XLOOKUP to pull from trial balance data accurately, extend to SUMIFS when you need to filter by multiple criteria at once, and apply date functions to make sure your schedule always points to the right reporting period. By the end, you'll have formula logic that is not just correct — it's traceable, testable, and built to hold up under scrutiny.

A control check that quietly returns zero is not a control check — it's a blind spot. In this module, you'll learn how to use IF logic to turn reconciliation results into clear, readable signals that tell reviewers exactly what needs attention. You'll build the kind of workpaper where problems surface immediately instead of hiding inside a cell that looks fine.

Getting the formulas right is only part of the job. In this final module, you'll learn what it takes to hand off a workpaper that someone else can open, follow, and trust — covering consistent rounding, clean structure, and the documentation habits that hold up under review. You'll also explore how AI tools can support your workflow and where human judgment still has to lead.

AI can make you faster — but only if you stay in control. In this module, you'll learn what AI is actually appropriate for in tax analyst work, where the real risks live, and what information must never leave your organization through a public AI tool. You'll walk away with a clear framework for using AI responsibly before you draft a single word.

Most AI output problems start before the AI writes anything — they start with a weak prompt. In this module, you'll learn how to build prompts that give you drafts that are more useful, easier to verify, and closer to what you actually need. You'll practice rewriting vague prompts into precise, task-ready instructions that hold up in a professional tax context.

The same AI tool can support summarizing a filing instruction, drafting a status update, or converting reviewer notes into a traceable checklist — but each task requires a different approach. In this module, you'll practice all three drafting patterns using realistic tax scenarios, and you'll learn the key safeguard for each: what to check, and why polished output still needs a human eye.

A polished AI draft can still be wrong — and in tax work, that's the real risk. In this module, you'll build a verification habit that protects you from accepting output that sounds professional but contains unsupported citations, incorrect dates, or hallucinated numbers. You'll use a practical checklist and mistake log you can carry into your own workflow.