Financial Modelling Using Excel
الحصول على الكتيب
للحصول على كتيب بكامل محتويات الدورة برجاء ملء النموذج التالي ببياناتك الصحيحة
Program Professional Framework
Financial Modelling Using Excel
Program Overview
This hands-on programme concentrates on the Excel techniques that make models fast to build, flexible and easy to check. «Financial Modelling Using Excel» covers workbook layout, timeline and flag formulas, INDEX, OFFSET-free lookups and dynamic arrays, handling circular references for interest, data tables and Goal Seek for sensitivities, scenario selectors, charts for outputs and Excel's auditing tools. Participants build a complete operating and financing model step by step, applying consistent formula conventions and checks throughout.
Learning Outcomes
- ✓Set up a workbook with a consistent layout, timeline, flags and named inputs.
- ✓Write flexible, consistent formulas using lookup, logical and dynamic array functions.
- ✓Handle interest circularity with copy-paste macros or algebraic solutions instead of iterative calculation.
- ✓Build sensitivity tables, scenario selectors and Goal Seek analyses.
- ✓Create clear output sheets and charts for decision makers.
- ✓Audit a workbook using trace precedents, evaluate formula and error checks.
Target Audience
- Financial analysts building models in Excel
- Accountants moving into planning and analysis roles
- Project finance and investment analysts
- Business analysts supporting finance teams
Detailed Program Modules
01Workbook Design for Modelling
- Sheet structure, colour conventions and navigation
- Named ranges and input controls
- Timeline and period flags
02Core Formula Techniques
- INDEX-MATCH and XLOOKUP for dynamic selections
- MIN, MAX and logical formulas for caps and floors
- SUMPRODUCT and dynamic arrays
03Building Operating Schedules
- Revenue and cost build-ups
- Corkscrew schedules for assets and working capital
- Depreciation and capex profiles
04Financing and Circularity
- Debt schedules and repayment profiles
- Interest circularity and how to break it
- Simple macros for copy-paste routines
05Sensitivity and Scenario Tools
- One- and two-variable data tables
- Goal Seek and scenario selectors
- Charts for sensitivity outputs
06Checking and Auditing in Excel
- Error checks and balance tests
- Formula auditing tools
- Version control and documentation
Training Methodology
Applied Project & Assessment
Applied Project
Participants build an Excel model for a new facility or business line from a blank workbook, with timeline flags, operating schedules, a debt schedule without iterative calculation, data-table sensitivities and an output dashboard with integrity checks.
Assessment
Short diagnostic at the start, practical tasks linked to each learning outcome, and evaluation of the applied project against published criteria.