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)

Satisfaction Index

5.76 on 6 (986 reviews)

Questions ?

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

Contact us

To contact us, please fill out the form below.

Loading map...

Contact Form

Enter your name.
Please enter a valid email address.
Please enter your phone number
Please enter your message.