CH167

MS Excel Functions

87%

overall satisfaction for this course

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

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.

Customer Testimonials

Many useful functionnalities for the daily use of Excel.

Josée S. / Agente de recherche et de planification, Université du Québec à Montréal (UQAM)

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, 2010, 2013, 2007 and 2003).

DATES*

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

    January 23 2017

  • Montreal

    January 24 2017

  • Montreal

    April 4 2017

  • Quebec City

    May 24 2017

  • Montreal

    July 3 2017

Trainer(s) assigned(s)

Other course(s) in this category