Excel for Financial Professionals
الحصول على الكتيب
للحصول على كتيب بكامل محتويات الدورة برجاء ملء النموذج التالي ببياناتك الصحيحة
Program Professional Framework
Excel for Financial Professionals
Program Overview
Finance teams still run most reconciliations, reports and analyses in spreadsheets, so speed and accuracy in Excel translate directly into better month-ends and fewer errors. «Excel for Financial Professionals» focuses on the functions and tools finance staff use most: lookup and dynamic array functions, conditional logic, date and financial functions such as XNPV and XIRR, PivotTables, Power Query for cleaning and combining ledger extracts, Power Pivot data models, scenario tools and dashboard charts, plus spreadsheet controls that make files reviewable.
Learning Outcomes
- ✓Use XLOOKUP, INDEX-MATCH and dynamic array functions to reconcile and combine finance datasets.
- ✓Automate the import and cleaning of general ledger and bank extracts with Power Query.
- ✓Build PivotTables and a Power Pivot data model to analyse revenue and expenses by multiple dimensions.
- ✓Apply financial functions including NPV, XNPV, XIRR and PMT to investment and loan calculations.
- ✓Run what-if analysis using data tables, Goal Seek and Scenario Manager.
- ✓Build a reviewable finance dashboard with data validation, error checks and clear charts.
Target Audience
- Accountants and financial analysts
- FP&A and management reporting staff
- Treasury and budget officers
- Auditors who review client spreadsheets
Detailed Program Modules
01Efficient Spreadsheet Foundations
- Tables, named ranges and structured references
- Keyboard productivity and navigation
- Spreadsheet design and documentation standards
02Lookup, Logic and Text Functions
- XLOOKUP, INDEX-MATCH and approximate matches
- IF, IFS, SUMIFS and COUNTIFS for reconciliations
- Dynamic arrays: FILTER, UNIQUE, SORT
03Data Preparation with Power Query
- Importing ledger, bank and ERP extracts
- Cleaning, unpivoting and merging data
- Refreshable monthly workflows
04Analysis with PivotTables and Power Pivot
- PivotTables, slicers and calculated fields
- Data models and relationships
- Basic DAX measures for finance
05Financial Functions and What-If Tools
- NPV, XNPV, IRR, XIRR, PMT and depreciation functions
- Data tables, Goal Seek and Scenario Manager
- Date functions for ageing and period mapping
06Reporting, Dashboards and Controls
- Charts and conditional formatting for finance reports
- Data validation and error checks
- Protecting, reviewing and auditing formulas
Training Methodology
Applied Project & Assessment
Applied Project
Participants build a refreshable monthly reporting workbook from raw ledger extracts: Power Query import, a reconciliation using lookup functions, PivotTable analysis by cost centre, an XIRR calculation for an investment case and a one-page dashboard with built-in checks.
Assessment
Short diagnostic at the start, practical tasks linked to each learning outcome, and evaluation of the applied project against published criteria.