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.74 on 6 (644 reviews)

Questions ?

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