Excel: Advanced Functions Training

Complete basics knowledge with advanced functionalities search as statistical functions, lookup and index functions. 

Target audience

Excel user who needs to improve his/her knowledge, work performance and Excel efficiency.

Objectives

After Excel: Advanced Functions, participants master the following:

  • IF Function and nested IF functions
  • AND, OR Functions
  • SUMIF Function
  • COUNT, COUNTA, COUNTIF Functions
  • LOOKUP functions (VLOOKUP, HLOOKUP, INDEX)

Requirements

Windows and Excel basics.

Methodology

Excel advanced training is based on theoretical Excel manual, but main part of the training is dedicated to practical exercises with personalized assistance from the trainer.

Content

  • IF Function and nested IF functions
  • AND, OR Functions
  • SUMIF Function
  • COUNT, COUNTA, COUNTIF Functions
  • LOOKUP functions (VLOOKUP, HLOOKUP, INDEX)

Diploma / Certificate

A certificate is awarded upon completion of training "Excel: Advanced Functions"

Print version

Format PDF

Duration and Price

Durée: 1 séance (4 périodes)
Prix: CHF 600.-
(group price)

Questions ?

Contact us
Tél. +41 22 732 51 11
Lu-Ve 8h30 to 17h00

Contactez nous

Pour nous contacter, veuillez remplir le formulaire ci-dessous.

Loading map...

Formulaire de contact

Entrez votre nom.
Veuillez entrer une adresse email correcte.
Veuillez entrer votre numéro de téléphone
Veuillez entrer votre message.