Course Details
Financial Modelling and Forecasting with Advanced Microsoft Excel
In today’s financial landscape, creating and interpreting financial models are essential for making informed business decisions, evaluating investment opportunities, and assessing risks. Financial modeling with Microsoft Excel is a critical skill for professionals in finance, investment, accounting, and related fields.
Aug 10, 2026
9:00 am
₦393,046.88
5 Days
In today’s financial landscape, creating and interpreting financial models are essential for making informed business decisions, evaluating investment opportunities, and assessing risks. Financial modeling with Microsoft Excel is a critical skill for professionals in finance, investment, accounting, and related fields.
It involves the construction of abstract representations (models) of real-world financial situations, enabling decision-makers to forecast future financial performance, evaluate potential investments, and assess risks. Microsoft Excel, with its advanced computational tools, built-in functions, and flexibility, has become the industry standard for building financial models due to its accessibility and powerful analytical capabilities.
At the end of the training programme, participants will be equipped to:
- Master the Fundamentals of Financial Modeling
Build Basic and Advanced Financial Models - Gain proficiency in using essential and advanced Excel formulas.
- Understand the key components of a financial model, including assumptions, inputs, calculations, and outputs
- Apply advanced Excel functions like INDEX MATCH, XNPV, XIRR, PMT, IPMT, and other complex formulas for building financial models.
- Understand the concept of time value of money and how it affects financial decision-making
- Translate complex financial models into clear, actionable insights for non-technical stakeholders, including executives, investors, and regulators.
- Overview of Financial Modelling
- Introduction to Microsoft Excel and Formulas
- Building Financial Statements
- Time Value of Money and Cash Flow Analysis
- Financial Forecasting and Sensitivity Analysis
- Building a Financial Model from Scratch I
- Building a Financial Model from Scratch II
- Valuation
- Advanced Financial Modeling Techniques
- Power Query and Power Pivot in Financial Modeling
- Best Practices and Professionalism
- Case Studies in Banking and Financial Services
Recommended Courses
Financial Modelling and Forecasting with Adva...
Mastering Data Analysis in Financial Services...
Data Visualization and Modelling with Microso...
