Introduction:

PivotTable and the VLOOKUP Function is the most popular and powerful feature in Microsoft Excel. PivotTable summarizes and analyses large amount of data; while VLOOKUP helps you to search and retrieve relevant information for your reporting. This course explores deeper into the usage of PivotTable and using VLOOKUP to obtain various complicated information.

PRE-REQUISITES

Completed Excel Level 2 (Intermediate) Training or have mastered the following skills:

• Performing basic tasks such as Cut, Copy, Paste, Paste Special
• Performing basic tasks such as AutoFill and Drag and Drop
• Formatting Cells
• Creating and Formatting a Table
• Performing common Calculations and Level 2 Formulas and Functions:
  • Addition, Subtraction, Multiplication and Division
  • Referencing Absolute (Fixed) data.
  • SUM, AVERAGE, COUNT, SUMIF, AVERAGEIF, COUNTIF Functions
  • IF, IFERROR Functions

Learning Outcomes:

Upon completion of program, participants will be able to:

• Summarize and analyze raw data with PivotTable;
• Add Formulas to enhance the PivotTable report; and
• Use VLOOKUP Function in different ways to manage different situations.

Who Should Attend:

This program is suitable for users who are required to crunch and analyze large amount of data.