top of page

TSY In House Training #157: MICROSOFT EXCEL 2016: Pivot Table and Vlookup


TSY In House Training #157: MICROSOFT EXCEL 2016: Pivot Table and Vlookup
Training started.

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.


5 views0 comments

Comments


bottom of page