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