GE324

Financial Modeling and Methodology with MS Excel - Part 2

100%

overall satisfaction for this course

?Average calculated from scores obtained from 3 participants who took this course.
  • Duration 2 days
  • Regular fee 925
  • Preferential fee 795?
  • Locations
    • Montreal
    • Quebec City
  • Laboratory
    course

Accreditation and partners association

  • Project Management Institute 12 PDU
SUMMARY
DETAILS

Objectives

To provide the knowledge and skills required to develop advanced predictive models, and to prepare budgets and financial forecasts.

Targeted audience

Managers.

Prerequisite

Experience with MS Excel (Course CH128) and financial modeling and methodology with MS Excel - Part 1 (GE122).

Customer Testimonials

Excellent trainer. Peerless trainer who popularizes the informations.

Marie-Josée F. / CPA, CMA, Duret et Landry Inc.

Content

  • Statistical functions: FREQUENCY, QUARTILE, PERCENTILE, NORMINV, RANK, etc.
  • Logical functions: MATCH, INDEX, VLOOKUP, HLOOKUP, etc.
  • Analysis tools and utilities
  • Regression functions: INTERCEPT. SLOPE, TREND, LINEST, etc.
  • Developing predictive working models based on multiple macro-economic factors such as interest rates, exchange rates, etc.
  • Preparing financial forecasts using statistical tools
  • The Solver analysis tool
  • Optimizing (maximizing and minimizing) returns and inventory
  • Preparing budgets and interpreting them using the simulation method
  • Creating sophisticated macro commands

DATES*

*Unless stated otherwise, all sessions are in French.
  • Montreal

    April 20 to April 21 2017

  • Quebec City

    May 25 to May 26 2017

Trainer(s) assigned(s)

Other course(s) in this category