COURSE INFORMATION

Scheduled Dates: 11 – 15 Mar 2024 | 10 – 14 Jun 2024 | 09 – 13 Sep 2024 | 09 – 13 Dec 2024

Duration: 1 Week

Customized dates for groups or one-on-one sessions can be organized.

PREAMBLE

This CPM professional course aims to help delegates develop the Financial Modeling skills using MS Excel. In the ever-changing business environment, being able to accurately model and forecast the volatile economic inputs is a critical skill for business professionals. Build on your existing modelling skills and apply new techniques to better analyze financial data, predict revenues and cost and assess risks to justify business decision in the most time-efficient and effective way.

Course Outline

• Best Practice in Financial Modelling
• Strategies for Reducing Errors
• Lookup Functions
• INDEX/MATCH
• OFFSET Function
• Array Formulas
• Form Controls
• Escalation Methods
• Pivot Tables in Financial Modelling
• Macros in Financial Modelling
• Overview of Scenario Analysis Methods
• Data Tables
• Advanced Conditional Formatting
   

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.

 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.