Financial Modeling and Methodology with MS Excel - Part 2


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
    • Quebec City
    • Montreal
  • Laboratory

Accreditation and partners association

  • Project Management Institute 12 PDU


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

Targeted audience



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.


  • 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


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

    May 25 to May 26 2017

  • Montreal

    October 19 to October 20 2017

  • Quebec City

    November 16 to November 17 2017

Trainer(s) assigned(s)

Other course(s) in this category