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

Excel 2013, 2016, 2019 - Functions 1

Office Automation

In collaboration with:

See more

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