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
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
Completed Excel Advanced Level 3 (Advanced) training or have mastered the following skills:
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.
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 firstname.lastname@example.org