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

Are you interested by this training course ?

This training course is available in private training. Enter your email to be contacted by a member of our team for more informations.

Invalid email address

Trainer(s) assigned(s)

Other course(s) in this category