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

Excel 2013, 2016, 2019 - Functions 2

Office Automation

In collaboration with:

See more

Description

Objectives
  • Be able to create more advanced formulas
Programme
  • 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)….
Prerequisites
  • Basic Excel functions

Conditions

Course Material

The training material will be handed out at the beginning of the course.

Location
Classe virtuelle
A distance
Calculate the itinerary