Excel - Functions 2

Blended learning

Who is the training for?

All public

Duration

3,50 hours(s)

Language(s) of service

EN

Next session

05.06.2024
See details
Location
The address will be provided later

Price

155,00€

Prerequisites

  • Basic Excel functions

Goals

Be able to create more advanced formulas.

Contents

  • Use range names
  • Nested functions
  • Lookup functions
    • VLOOKUP, INDEX, MATCH…
  • Logical functions
    • IFERROR, AND, OR…
  • Text functions
    • UPPER, LOWER, PROPER, SUBSTITUTE, TRIM…
  • Date and Time
    • EDATE, WEEKDAY, NETWORKDAYS…
  • Math
    • ROUND, ROUNDUP, ROUNDDOWN, SUMIF(S)….

Next session

Datum
City
Language and price
05.06.2024
The address will be provided later
EN 155,00€
See details

Organization contact details

House of Training

These courses might interest you

EN
Day
PowerPoint 2016 - Refresh
Classe virtuelle
Software - Office software - Computer-aided presentation software - Power point software
07.05.2024