Excel for Finance

What You Will Learn

• 1 Learn the Excel environment, navigation conventions, and essential settings that every finance professional needs to configure before building reliable spreadsheets.
• 2 Understand core financial formulas including SUM, IF, VLOOKUP, INDEX-MATCH, and date functions that form the backbone of daily finance work.
• 3 Apply formatting, named ranges, and data validation techniques to build clean, auditable, and error-resistant financial worksheets.
• 4 Analyze large financial datasets using sorting, filtering, and PivotTables to surface trends, variances, and actionable business insights.
• 5 Build dynamic financial models using scenario analysis, data tables, and Goal Seek to support budgeting and forecasting decisions.
• 6 Develop professional financial statements including income statements, balance sheets, and cash flow reports directly in Excel.
• 7 Implement advanced functions such as XNPV, XIRR, OFFSET, and array formulas to perform sophisticated investment and valuation analysis.
• 8 Create compelling financial charts and dashboards that communicate performance metrics clearly to finance and non-finance stakeholders.
• 9 Automate repetitive finance tasks and data workflows using Excel macros and an introduction to VBA for finance professionals.
• 10 Apply Excel skills to a complete integrated financial modeling project, combining all course concepts into a professional-grade deliverable.