This training is offered in the form of distance learning. More information

Description

Objectives
  • Be able to create formulas including one or more functions
Programme
  • 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…
Prerequisites
  • Basic knowledge of Excel

Conditions

Course Material

The training material will be handed out at the beginning of the course.

Certificate

At the end of the training, the participant will receive a certificate of attendance delivered by the House of Training.  

Location
Classe virtuelle
A distance
Calculate the itinerary

Sessions and schedules

Download the schedule (PDF)

  • Wed 05.06.2024

    09:00 to 12:30

    3H30

    Excel 2016 Functions 1

    Classe virtuelle