Financial Modeling and Methodology with MS Excel - Part 2

Save 100$ off if you register for the session from November 10th to 11th in Montreal

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

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.
  • Montreal

    November 10 to November 11 2016

  • Quebec City

    November 24 to November 25 2016

  • 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