PivotTable & the VLOOKUP Function is the most popular and powerful feature in Microsoft Excel. PivotTable summarises and analyses large amount of data; while VLOOKUP helps you to search and retrieve relevant information for your reporting.
Date: 9th September 2020
Venue: Jinko Solar Technology Sdn. Bhd., Prai, Penang
Course Objectives:
After completing this course, students will be able to:
Summarise and Analyse raw data
Add Formulas to enhance the PivotTable report
Use VLOOKUP Function in different ways
Pre-requisites:
Completed Excel Advanced Level 3 (Advanced) training or have mastered the following skills:
Performing AutoFill.
Creating and Formatting a Table.
Performing common Formulas & Functions:
Addition, Subtraction, Multiplication and Division.
SUM, AVERAGE, COUNT, SUMIF, AVERAGEIF, COUNTIF, IF.
Referencing Relative and Absolute data.
Who Should Attend:
This course is suitable for users who are required to crunch and analyse large amount of data.
Training Methodology:
This program will be conducted through interactive lectures, practical exercises and group assignments. Case studies on real-world scenarios are included to demonstrate the practicability of the lessons.
Feel free to contact TSY Consultancy by Call / WhatsApp to +6012-6243921 or email to marketing@tsy.my
Cheers.