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)

Fr

Fri. 07 Feb.

En

Thu. 09 Apr.

Fr

Fri. 08 May.

De

Wed. 20 May.

Need a custom training?

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