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.
Übungsprojekt
Through hands-on projects, you'll build spreadsheets that automate loan and date calculations, write IF and lookup formulas that pull data across sheets, and summarize transaction data with pivot tables and SUMIFS. You'll construct a weekly cash forecast template, design a financial report with charts and error checks, and assemble a multi-chart Excel dashboard with end-user filtering that exports cleanly to PowerPoint, applying each skill to the real accounting and finance work you face on the job.
