Financial calculations that used to require a spreadsheet full of manual formulas can be reduced to a single function, and dates that appear straightforward have habits that will quietly break your work if you don't know how they operate. In this module, you'll apply Excel's built-in financial functions to answer real loan and debt questions in seconds, manipulate and sort dates with precision, and calculate time-based pay correctly by working with Excel's internal representation of time.

The ability to build spreadsheets that make decisions automatically and retrieve information from other sheets without manual searching is what separates a functional spreadsheet from a genuinely intelligent one. In this module, you'll write IF formulas that evaluate conditions and return different results based on logic, use XLOOKUP to pull data from one sheet to another with precision, and apply VLOOKUP to work effectively with the legacy formula you'll encounter across most existing accounting spreadsheets.

Turning thousands of rows of transaction data into a clear, accurate summary is one of the most valuable things an accountant can do in Excel, and three tools cover almost every summarization scenario you'll encounter. In this module, you'll build Pivot Tables to generate fast reports from large datasets, apply COUNTIF and SUMIF to count and total records that meet a single condition, and use COUNTIFS and SUMIFS to isolate the exact transactions that meet multiple specified criteria simultaneously.

Accounting spreadsheets don't just need to calculate correctly — they need to present financial data clearly and catch their own errors before they reach anyone else. In this module, you'll extend SUMIF and SUMIFS into three specific accounting applications that transform raw transaction data into financial reports, build line, column, and pie charts to communicate financial figures visually, and apply five error-checking strategies that let you verify accuracy systematically before presenting your work.

The difference between a spreadsheet that works once and one that holds up for years comes down to a handful of deliberate habits. In this module, you'll apply five best practices that prevent the most common sources of spreadsheet fragility, and use targeted diagnostic techniques to resolve the five types of problems you're most likely to encounter when something does go wrong.

This module closes the course. The skills you've built over six modules are most valuable when you actually use them, in the spreadsheets you build next week, not just in exercises. This lesson points you toward what to do with what you've learned, how to keep developing, and where Steve Friedman's additional resources can support your ongoing Excel growth.