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.
What you'll learn
construct formulas with absolute, relative, and mixed references
automate work with financial and date functions
retrieve data across sheets using XLOOKUP and VLOOKUP
summarize large datasets using pivot tables and formulas like SUMIF and COUNTIF
build weekly cash forecasts
format and visualize data through charts and dashboards
export data presentations to PowerPoint
Course objectives
equip finance professionals with essential Excel skills
enhance speed and accuracy in spreadsheet tasks
enable the creation of professional data visualizations