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)

Mon. 16 Jun.
Formation online de 9h00 à 12h30

Fri. 01 Aug.
Formation online de 9h00 à 12h30 Tarif de 175€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)

Fri. 03 Oct.
Online cours from 9:00 am to 12:30 pm Price will be €175 according to indexation on 05/01/2025 (effective as from July 1st)

Wed. 10 Dec.
Formation online de 9h00 à 12h30 Tarif de 175€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)

Need a custom training?

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