Reporting with PIVOT
Date : 13 & 14 May 2020
Time : 9:00am to 17:00pm
Location : Kuala Lumpur
Introduction
This course will help the participant to explore and using Excel PowerPivot for reporting.
This course will help participants deal with huge amount of data in business that normally will decrease the speed of data analysis if using traditional Excel analysis method.
The importance of using PIVOT in reporting has even become crucial in post pandemic business new normal.
Learning Outcomes
This course is designed to establish a practical understanding of the elements of Business Impact Analysis and Risk Assessment.
It will enable participants to review business impact analysis and various risks within their organization, and make decisions that lead to improved organizational resilience and preparation of business continuity plans.
Methodology
Lecture with visual aids, practical individual and group workshops and discussion.
Requirements :
Participants are required to have their own laptop equipped with microsoft excel.
Who will benefit
Management staff involve in reviewing and making decision on their organizational risks and business impacts
Course Content
Module 1: Data Visualization Overview
Module 2: PivotTable Basics
Module 3: Using Calculations in PivotTables
Module 4: Advanced PivotTable Formatting & Charts
Module 5: Creating Charts
Module 6: Specific Chart Types and Techniques
Module 7: Getting Started with PowerPivot
Module 8: Manipulating PowerPivot Data
Module 9: Creating PowerPivot Reports
Module 10: Distributing PowerPivot Data
For more information, please
Contact Us.]]>