Overview

Google, IBM & Meta Certificates – 40% Off

One plan covers every Professional Certificate on Coursera.

Finance professionals who master Excel produce models that hold up to scrutiny, answer stakeholder questions in minutes, and catch errors before they become costly. The tools that make this possible are more learnable than most people expect. In this course, you'll build financial spreadsheets using absolute, relative, and mixed references; automate loan, investment, and date-based calculations with Excel's built-in functions; and retrieve data across sheets with XLOOKUP and VLOOKUP. You'll summarize large datasets instantly with pivot tables, apply the COUNTIF and SUMIF formula families to analyze spending and revenue by category and time period, build and complete a structured weekly cash forecast, and generate targeted financial reports using Excel filters. Along the way, you'll adopt the error-checking habits that keep your spreadsheets accurate, maintainable, and ready to share. By the end of this course, you'll build complex, accurate financial spreadsheets in a fraction of the time, and troubleshoot the formula errors that slow other analysts down.

Syllabus

Mastering Excel References and Built-In Functions

Your financial spreadsheets can do far more than store numbers if the formulas inside them know exactly where to look and what to calculate. In this module, you'll use absolute, relative, and mixed references to build complex spreadsheets automatically, and apply Excel's built-in financial and date functions to automate loan payments, investment timelines, and date-based transaction sorting for your finance workflows.

Looking Up Data and Summarizing Results

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.

Counting and Summing with Conditional Formulas

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.

Forecasting Cash and Filtering Financial Data

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.

Producing Accurate and Maintainable Spreadsheets

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.

Conclusion

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.