Basic Dashboard

Introduction:

In the face of rapid technological change, your daily routine at the office requires skill in presenting accurate, fast and engaging reports. For those in the position of decision-making, you need to analyse and explore the various possibilities of helping organizations make decisions that increase profitability and reduce costs.

Objektive:

Provides interactive reports that are precise and fast in processing data input
Facilitate data analysis and What If analysis
Easy to help with presentations and reports

Target Audience:

All positions in helping organizations make decisions such as Senior Executive, Manager and Director. Individuals who want to make interesting and interactive reports such as Finance Executive and Human Resources Executive are also private companies

Duration :

2 Days – (Hands-on and lecturing method)

Pre-Requisite:

Attended Excel Intermediate and Advance Training sessions or is proficient in Microsoft Excel software
Has the ability to use and understand basic functions of the keyboard and mouse
Understand the advantages and disadvantages of each version of Microsoft Office Excel

Course Outline:

Module 1: Basic Decision Making & Analysis Function

Sum, Average, Max, Min, Rank and Count
IndexMatch Lookup & Hyperlink

Module 2: Basic Analysis Graph

Column, Bar, Line, Pie and Donut

Module 3: Pivot Table & Charts

- Source of Data FAT or Range

a. Rules to apply Name
b. Rules to apply FAT
c. Pro’s and Con’s FAT and Range

- Destination

a. Within same sources file or same workbook different worksheet
b. Other workbooks
c. Pro’s and Con’s different workbook

- Pivot Environment

a. Ribbon, Show and Filed List Area
b. Slicer and Timeline
c. Insert Calculation Field
d. Drill down and Drill up
e. Pivot Charts

Module 4 : Interactive Dashboard

Human Resource – Analysis employee data such as Leave and Attendance
Training – Analysis in progression of Training by employee
Sales – Analysis performance Sales Person
Warehouse – Analysis Stock