Overview

Google, IBM & Meta Certificates – 40% Off

One plan covers every Professional Certificate on Coursera.

In finance and accounting, the speed and accuracy of your spreadsheets decide whether your numbers get trusted, and Microsoft Excel is the tool that makes the difference. Across three courses, you'll build a complete Excel toolkit: construct formulas with absolute, relative, and mixed references, automate work with financial and date functions, retrieve data across sheets with XLOOKUP and VLOOKUP, summarize large datasets with pivot tables and the SUMIF and COUNTIF formula families, build weekly cash forecasts, and apply error-checking habits that catch mistakes early. You'll also turn raw numbers into decision-ready visuals: formatting figures for impact, building and customizing charts, assembling a multi-chart dashboard, and exporting a board-ready layout to PowerPoint. By the end, you'll produce accurate financial spreadsheets and professional data visualizations in a fraction of the time.

Syllabus

Course 1: Using Excel for Finance
Course 2: Using Excel for Accounting
Course 3: Visualizing Data in Excel

Courses

0 reviews

View details

Raw data buried in rows and columns forces your audience to do mental work before they can act. When numbers sit in plain cells with no visual emphasis, hierarchy, or context, the most important insights get lost in the noise. In this course, you'll move from raw data to polished, decision-ready visuals using only Microsoft Excel. You'll format numbers for immediate impact, build and customize pivot tables and charts, work with text boxes, icons, and images as visual objects, assemble a multi-chart dashboard, set up end-user filtering, and export the finished result to PowerPoint. By the end of this course, you'll be able to produce professional data visualizations in Excel that reduce the mental effort your audience needs to find the insight, draw their attention to what matters most, and present your data in any format from a live spreadsheet to a board-ready PowerPoint slide.
0 reviews

View details

For accountants, speed and accuracy aren't just desirable: they're career-defining. Excel is the tool that separates professionals who spend hours on a task from those who finish it in minutes, and it determines whether the financial data you produce is trusted or questioned. With this course as your guide, you'll build your foundational toolkit with absolute, relative, and mixed references, apply financial and date functions that automate complex calculations, and construct intelligent spreadsheets using IF formulas, XLOOKUP, and VLOOKUP. You'll also aggregate large datasets with Pivot Tables and SUMIF functions, produce visual reports using Excel's charting tools, and apply error-checking and troubleshooting strategies that catch mistakes before anyone else sees them. By the end of this course, you'll produce accurate, polished spreadsheets with confidence, using Excel not as a source of dread but as a strategic tool that saves you time and elevates the quality of your accounting work.
0 reviews

View details

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.