GE122

Financial modeling and methodology with MS Excel - Part 1

Expand your knowledge and integrate modeling standards.

88%

overall satisfaction for this course

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

Accreditation and partners association

  • Project Management Institute 12 PDU
SUMMARY
DETAILS

Objectives

To provide the knowledge and skills required to master the advanced features of Excel and pair these with a rigorous methodology in order to build superior accounting and financial models, according to best business practices.

Targeted audience

All management positions.

Prerequisite

Experience with MS Excel (Course CH128).

Customer Testimonials

Very useful content to add tools to each manager's vault.

Frédéric L. / Coordonnateur - Contrôle budgétaire et processus, Agence métropolitaine de transport

Content

  • Discover little-known features of Excel: shortcuts, expert tips and tricks
  • Using tools: sensitivity analysis and possible scenarios, data analysis with dynamic pivot tables, polished graphics
  • Creating macros
  • Improving the mastery of functions: integrating multiple functions and creating formulas to handle complex calculations
  • Best practices in financial modeling: planning a model, incorporating proven methods
  • Rigorously controlling and organizing data: optimizing, simplifying and standardizing models, reducing operational risks
  • Combining features and tools in building accounting and financial models
  • Formula auditing tools: watch windows, tracing precedents, tracing dependents, etc.
  • Naming cells: managing names, defining names, applying names, etc.
  • Mastering Excel: exercises and completion of a case study

DATES*

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

    October 5 to October 6 2017

  • Quebec City

    October 12 to October 13 2017

  • Montreal

    January 18 to January 19 2018

  • Quebec City

    February 15 to February 16 2018

  • Montreal

    April 12 to April 13 2018

Trainer(s) assigned(s)

Other course(s) in this category