When you can locate a value anywhere in your workbook automatically and summarize thousands of transactions in under a minute, the speed and accuracy of your financial reporting changes entirely. In this module, you'll use XLOOKUP to retrieve matching values across worksheets and workbooks, work with VLOOKUP formulas built by others, and build pivot tables and pivot charts that produce instant summaries and dashboards from large transaction datasets.

When financial datasets grow beyond a few hundred rows, manually tallying by category stops being practical. In this module, you'll use COUNTIF and SUMIF to count and total transactions by a single criterion, extend those formulas to COUNTIFS and SUMIFS to filter by multiple criteria simultaneously, and apply SUMIFS with helper columns and mixed references to build multi-period financial summaries by person, month, and year inside a live-linked model.

Knowing how much cash your business will have in six weeks is one of the most consequential numbers in finance, and being able to surface exactly the data you need from a large financial dataset in seconds is what separates fast, accurate analysis from slow manual work. In this module, you'll build a structured weekly cash forecast template, fill it in using real estimation techniques for each cash flow category, and use Excel's filter tools and number logic to generate targeted financial reports on demand.

Every spreadsheet you build in finance will eventually be used under time pressure, modified by a colleague, or reopened months later when the context is no longer fresh. In this module, you'll apply the specific habits that prevent the most common design and structural errors before they occur, and use Excel's built-in diagnostic tools alongside discrepancy-pattern analysis to find and correct formula errors reliably and efficiently.

You've built the Excel toolkit that finance professionals depend on to model, analyze, and report with confidence. In this module, you'll take stock of your new capabilities, find guidance on where to apply them first, and connect with the instructor's continued resources for further learning.