Excel - Functions 1

Blended learning

Who is the training for?

All public

Duration

3,50 hours(s)

Language(s) of service

EN

Prerequisites

Basic knowledge of Excel

Goals

  • Be able to create formulas including one or more functions

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…

These courses might interest you

FR
Day
Classe virtuelle
Software - Office software - Word processing software - Word software
20.12.2024
FR
Day
Blended-Learning
Software - Office software - Computer-aided presentation software - Power point software