Definition

Complete basics knowledge with advanced functionalities search as statistical functions, lookup and index functions. Discover powerful tools like pivot tables, consolidation and goal seek.  Manage your database with subtotals, advanced filters, and custom sorting Learn how to protect your Excel documents.

Public

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

Objectives

After Excel: Advanced Functions After Excel training, participants master the following:

• IF Function and nested IF functions
• AND, OR Functions
• SUMIF Function
• COUNT, COUNTA, COUNTIF Functions
• LOOKUP functions
• INDEX function
• Database Function
• Pivot Tables
• Consolidation
• Protection

Requirement

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.