• info@elias.com.my
  • +603 2856 7297
  • +603 2856 7293

Reporting with PIVOT

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.]]>