COURSE INFORMATION
Scheduled Dates: 01 – 12 Feb 2027 | 03 – 14 May 2027 | 02 – 12 Aug 2027 | 01 – 12 Nov 2027
Duration: 2 Weeks
Customized dates and one-on-one sessions can be organized.
COURSE DESCRIPTION
This course is designed to equip participants with advanced practical skills in developing, analysing and interpreting financial models using Microsoft Excel to support financial planning, investment appraisal, forecasting and strategic business decision-making.
The training covers advanced Excel functions, financial data management, financial statement modelling, budgeting and forecasting, cash flow projections, investment valuation, scenario analysis, sensitivity analysis and financial risk assessment. It emphasizes the development of dynamic and integrated financial models that enable organizations to evaluate financial performance, assess investment opportunities, forecast future financial outcomes and make informed financial decisions.
TARGET GROUP
Managers and those seeking promotion in the following areas:
COURESE OUTLINE
The following topics will be discussed:
Week 1: Advanced Excel Techniques and Financial Modelling Fundamentals
Module 1: Advanced Microsoft Excel for Financial Analysis
Module 2: Financial Data Management and Analysis
Module 3: Fundamentals of Financial Modelling
Module 4: Integrated Financial Statement Modelling
Module 5: Budgeting, Forecasting and Cash Flow Modelling
Week 2: Investment Modelling, Valuation and Advanced Financial Analysis
Module 6: Investment Appraisal and Capital Budgeting Models
Module 7: Business Valuation and Corporate Finance Modelling
Module 8: Scenario Planning, Sensitivity and Risk Analysis
Module 9: Financial Modelling Automation and Dashboard Development
Module 10: Practical Financial Modelling Project
Software and Tools
Microsoft Excel (Advanced)
Core platform for financial modelling, forecasting, valuation and financial analysis.
Power Query
Financial data extraction, cleaning, transformation and consolidation.
Excel VBA and Macros
Automation of financial calculations, repetitive processes and reporting.
REGISTRATION AND PAYMENT PROCEDURE
Registration
To register, kindly fill the Seminar Registration Form and send it to us through:
Email: This email address is being protected from spambots. You need JavaScript enabled to view it., This email address is being protected from spambots. You need JavaScript enabled to view it.
Fee Payment Details
Fee is payable by bankers cheque or cash deposit to:
CENTRE FOR PROJECT MANAGEMENT
A/c no. : 01148232519900
Cooperative Bank, City Hall Branch Nairobi.
Swift code (KCOOKENA), Sort code (11049).
TERMS AND CONDITIONS OF PAYMENT
Kenbelt Business Park, First floor,
Old Mombasa Road,
Nairobi, Kenya.
+254 732 880255
+254 705 880255