Details

Goals

Be able to create formulas including one or more functions.

Prerequisite

Basic knowledge of Excel.

Contents

Use the function wizard:

  • Search,
  • Categories,
  • Arguments,
  • Help

Use absolute references in formulas

Statistical functions

  • MAX, MIN, AVERAGE, COUNT, COUNTIF(S), COUNTA…

Text functions

  • MID, RIGHT, LEFT, CONCATENATE…

Logical

  •  IF

Date and Time

  •  TODAY, DATEDIF, DATE, YEAR, MONTH, DAY…

 

Sign up

Next session(s)

Wed. 05 Jun.
Online course from 9:00am to 12:30pm

Mon. 10 Jun.
Cours online de 9h00 à 12h30

Need a custom training?

None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!