Follow Us

facebooklinkedintwitterwhatsapp

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:

  • Finance Managers and Financial Analysts
  • Accountants and Financial Controllers
  • Investment and Portfolio Analysts
  • Budget and Planning Officers
  • Corporate Finance Professionals
  • Banking and Financial Services Professionals
  • Business Analysts and Management Consultants
  • Project Finance and Investment Managers
  • Auditors and Risk Management Officers
  • Business Owners and Entrepreneurs

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

  1. Fees Payment - All fees are payable strictly in advance 2 working days before the course starting date.
  2. Cancellation Fee - Cancelletion of any participant 5 working days before the start day of a course will incur a 20% cancellation fee.
    We regret that no cancellations will be accepted within 2 working days of a course, but substitutions may be made.

Get in touch

CAPTCHA
Joomla forms builder by JoomlaShine

Connect with us

Address:   Kenbelt Business Park, First floor,

      Old Mombasa Road,

      Nairobi, Kenya.

Phone:   +254 732 880255

Mobile:   +254 705 880255

training@centreforpm.co.ke

centreforpm@gmail.com

http://www.centreforpm.co.ke


Centre for Project Management (CPM) All Rights reserved 2012 Powered by Intouch Brands