The Essentials of MS Excel for Managers

Use the power of Excel to the fullest.


overall satisfaction for this course

?Average calculated from scores obtained from 1621 participants who took this course.
See the training dates
  • Duration 1 day
  • Regular fee 350
  • Preferential fee 300?
  • Locations
    • Virtual Classroom
    • Quebec City
    • Montreal
  • Laboratory

Accreditation and partner associations

  • Project Management Institute 6 PDU


To provide the knowledge and skills required to make use of the key features of Excel in order to increase daily productivity and autonomy.

Targeted audience



Basic knowledge of Excel.

Training Details


  • Essential keyboard shortcuts
  • Organizing data in order to work efficiently with Excel
  • Setting up pages efficiently: using the fill handle, and special cut and paste techniques
  • The various addressing modes: A1, $A$1, $A1 and A$1
  • Essential features
  • Automating layout: custom formats and conditional formatting
  • Cross-sheet and cross-file formulas
  • Creating graphics
  • Updating multiple tabs simultaneously
  • Choosing a good analysis tool: pivot tables, filters and subtotals
  • Using scenarios
  • Input control: protection and validation of information

General Note

Note: The course is given using Excel 2019 and 2016, but the features described are available in Excel 2007–2013 as well. The version of the course given with Excel 2003 is available upon request.

Customer Testimonials

Provides a very good overview of everything you can do with Excel.

Colette H. / Assistante à la logistique, Fierté Montréal

Select the training date*

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

    September 21 2020 - 2013 / 2016 version

  • Quebec City

    October 16 2020 - 2013 / 2016 version

  • Montreal

    October 28 2020 - 2013 / 2016 english version

  • Montreal

    November 23 2020 - 2013 / 2016 version

Trainer(s) assigned(s)

Other course(s) in this category