Financial Modeling and Methodology with MS Excel - Part 2

Broaden your knowledge and integrate modeling standards.


overall satisfaction for this course

?Average calculated from scores obtained from 3 participants who took this course.
  • Duration 2 days
  • Regular fee 0
  • Preferential fee 0?
  • Locations
  • Laboratory

Accreditation and partners association

  • Project Management Institute 12 PDU


To provide the knowledge and skills required to develop advanced predictive and optimization 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

Are you interested in this training course ?

Only private sessions of this course are currently available (8 participants minimum).

Request a quote

Trainer(s) assigned(s)