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.

Location
Classe virtuelle
À distance

À distance
Calculate the itinerary

Sessions and schedules

Download the schedule (PDF)

  • Fri 18.03.2022

    09:00 to 12:30

    3H30

    Excel 2016 Functions 1

    Classe virtuelle
    À distance