PivotTable is the most popular and useful tool in Microsoft Excel to summarise and analyse large amount of data. As each newer versions of Excel added more features to it, this 2-day course provides students with the additional knowledge and skills to use the features of PivotTable.
Date: 19th & 20th August 2019
Venue: Info Trek Computer Lab, Penang
Course Objectives:
Upon completion of this program, the participants will be able to:
Summarise and Analyse raw data
Consolidate multiple PivotTable
Connect to other External Data Source
Add Formula to enhance report
Create a Dashboard
Create Relationships (Excel 2013 onwards)
Prerequisite:
Completed Excel Basic Level training or have mastered the following basic skills:
Inserting and Deleting Worksheets, Rows, Columns and Cells.
Perform AutoFill.
Use basic formulas – Addition, Subtraction, Multiplication and Division.
Use basic functions – AutoSum.
Course Methodology:
This is a highly interactive training program, whereby participants are to gain the learning points through experiential activities. This program will be conducted through interactive lectures, practical exercises and group assignments.
Who Should Attend:
This course is intended for users of Microsoft Office Excel who want to learn about the features of Microsoft Office Excel PivotTable.
Feel free to contact TSY Consultancy by Call / WhatsApp to +6017-4036965 or email to marketing@tsy.my
Cheers.