2days Training | HRDCorp Claimable Course

Microsoft Excel Pivot Table & Interactive Dashboard Training Course

Learn More

Microsoft Excel Pivot Table & Interactive Dashboard Training Course

COURSE DETAILS & INCLUDED:
  • Physical Class / Remote Online Training
  • 2 Days
  • 9am – 5pm
  • Certificate of Attendance
  • HRDCorp Claimable Course
  • In-House / Public Class 

PROGRAM OVERVIEW:

Elements of this syllabus are subject to change. This 2days 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.

 

Dashboard reports allow managers and decision makers to get high-level overview of the business. Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner.

LEARNING OUTCOME:

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 PivotCharts
  • Manipulate the PivotTable layout
  • Organize data for easier dashboard preparation
  • Prepare worksheet to ease future dashboard update

WHO SUITABLE FOR THIS COURSE:

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Pivot table and dashboard. This program is intended for Information Workers

TRAINING METHODOLOGY:

This program will be conducted with

    • Trainer led hands-on activity
    • Interactive group exercise and discussion
    • Relevant and concise case study
    • Participant led presentations
    • Mentoring – one to one or group

PREREQUISITES:

To ensure your success, we recommend the delegates equip with the following or equivalent knowledge:

  • A working knowledge of Microsoft Windows
  • A working knowledge of Microsoft Excel & Function
  • Prior working knowledge on Pivot Table is a plus

KEY MODULES:

  • Module 1 – Understanding Dashboards
  • Module 2 – Working With Your Data
  • Module 3 – Using Advanced Formulas & Functions
  • Module 4 – Quick Dashboard With Conditional Formatting
  • Module 5 – Advanced Pivot Table Techniques
  • Module 6 – Advanced Charting Techniques
  • Module 7 – Preparing Dashboard For Distribution
  • Module 8 – Interactive Dashboard Project

Let me know, if you interested this program

Please leave your enquiry here, we will reply as soon as possible.

Scroll to Top