NoScript Tracker
Cette formation est proposée sous forme de formation à distance. En savoir plus
Catalogue

Excel 2013, 2016, 2019 - Functions 1

Bureautique

En collaboration avec:

Voir plus

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