We move! Starting September 1st, our QUEBEC CITY training center will be located at 5400, des Galeries Blvd, Suite 500, 5th Floor, Québec (Quebec) G2K 2B4
CH167

MS Excel Functions

Using advanced Excel functions to facilitate decision-making.

89%

overall satisfaction for this course

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

Objectives

To provide the knowledge and skills required to make effective use of the many functions available with Microsoft Excel.

Targeted audience

Any audience.

Prerequisite

Basic knowledge of Excel.

Training Details

Content

  • Search functions: VLOOKUP, HLOOKUP, INDEX, MATCH
  • Database functions: DSUM, DAVERAGE, DCOUNT, DMAX, DMIN
  • Information functions: CELL, TYPE, ISERR, ISERROR
  • Logical functions: IF, AND, OR and the nesting of functions
  • Date/time functions: TODAY, NOW, DATE, YEAR, MONTH, DAY, NETWORKDAYS
  • Statistical functions: COUNT, COUNTIF, COUNTIFS, COUNTBLANK, FREQUENCY
  • Text functions: RIGHT, LEFT, LEN, MID, SEARCH, FIND, CLEAN, TEXT, CONCATENATE
  • Using matrix functions

General Note

Note: Most of the functions presented are available in all Excel versions (2016, 2013, 2010, 2007 and 2003).

Customer Testimonials

Relevant for anyone using MS Excel.

Ahmed A. / Ingénieur junior, Cascades Groupe Papiers Fins

Select the training date*

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

    September 26 2019 - CONFIRMED

  • Quebec City

    November 13 2019

  • Montreal

    November 21 2019

  • Quebec City

    January 27 2020

  • Montreal

    February 24 2020

  • Quebec City

    April 1 2020

  • Montreal

    April 30 2020

Trainer(s) assigned(s)

Other course(s) in this category