CH128

The Essentials of MS Excel for Managers

92%

overall satisfaction for this course

?Average calculated from scores obtained from 1124 participants who took this course.
  • Duration 1 day
  • Regular fee 350
  • Preferential fee 295?
  • Locations
    • Montreal
    • Quebec City
  • Laboratory
    course

Accreditation and partners association

  • Project Management Institute 6 PDU
SUMMARY
DETAILS

Objectives

To provide the knowledge and skills required to make use of the fundamental features of Excel to increase productivity and autonomy.

Targeted audience

Managers.

Prerequisite

Basic knowledge of Excel.

Customer Testimonials

Relevant if you want to be self-sufficient.

Agathe T. / Orthophoniste, CIUSSS du Centre-Est-de-l'Île-de-Montréal

Content

  • Indispensable keyboard shortcuts
  • Organizing the data in order to work efficiently with Excel
  • Setting up the page 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 2016 and 2013, but the features described are available in Excel 2007 and Excel 2010 as well. The version of the course given with Excel 2003 is available upon demand.

DATES*

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

    January 31 2017 - 2007 / 2010 version

  • Montreal

    March 27 2017 - 2013 / 2016 version

  • Quebec City

    May 26 2017 - 2013 / 2016 version

  • Montreal

    June 5 2017 - 2013 / 2016 version

Trainer(s) assigned(s)

Other course(s) in this category