Details

Goals

Be able to create formulas including one or more functions.

Prerequisite

Basic knowledge of Excel.

Contents

Use the function wizard: search, categories, arguments, help

Use absolute references in formulas

Use range names

Statistical functions

  • MAX, MIN, AVERAGE, COUNT, COUNTIF(S), COUNTA…

Text functions

  • TEXT, RIGHT, LEFT, MID, CONCATENATE, UPPER, LOWER, PROPER, SUBSTITUTE, TRIM …

Logical functions

  •  IF, AND, OR, IFERROR…

Lookup functions

  •  VLOOKUP, INDEX, MATCH…

Date functions

  •  TODAY, DATE, YEAR, MONTH, DAY, DATEDIF, EDATE, WEEKDAY, NETWORKDAYS …

Math functions

  • ROUND, ROUNDUP, ROUNDDOWN, SUMIF(S)….

 

Sign up

Next session(s)

This training is exclusively on request. Contact us to get a personalized offer.

Sessions available in

  • FR
  • DE
  • EN
  • LU

Need a custom training?

None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!