This course provides students with the knowledge and skills to examine and manipulate raw data through the use of Microsoft Office Excel PivotTables and Pivot Charts.
Date: 8th December 2023
Venue: NationGate Solution (M) Sdn. Bhd., Prai, Penang
Course Objectives:
Upon completion of this program, participants should be able to :
Understand the benefits of PivotTable Reports.
Convert raw data in an Excel worksheet into meaningful PivotTables and Pivot Charts.
Manipulate the PivotTable layout.
Use grouping.
Create custom calculations.
Use formulas and create formulas outside of a report.
Create a PivotChart and publish it to a Web site
Prerequisite:
Basic working knowledge of Microsoft Office Excel
Course 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.
Who Should Attend:
This course is suitable for users who are required to crunch and analyse large amount of data.
More Pictures:
Feel free to contact TSY Consultancy by Call / WhatsApp to +6012-6243921 or email to marketing@tsy.my
Cheers.