MASTERING DASHBOARD FOR VISUAL REPORT

MASTERING DASHBOARD FOR VISUAL REPORT

Summary

Location

Location

Malaysia

Duration

Duration

2 Days
Format

Format

Public Class

Public Class

Course Details

Course Code: MDVR; Instructor-led

Audience

  • Sales Executive / Managers
  • Business Analysist
  • Resource Planning Team
  • Project Managers
  • Purchasing Manager
  • Financial Executive / Managers

Prerequisites

Basic knowledge of Windows is essential with the following pre-requisites:

  • Able to switch between task applications
  • Able to create a spreadsheet with simple formatting
  • Able to use Auto Filter command
  • Able to use basic functions – AutoSum, Count, Max, Min and Average functions

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise.

Course Objectives

Upon completion of this program, participants should be able to:

  • Getting Started with Microsoft Excel 2019, Identify the Elements, and Interface of Excel
  • Performing Calculation, Basic Formula and Functions
  • Modify worksheet & Formatting Worksheet
  • Printing and managing large workbook

Outlines

  • Getting ready source data
  • Creating Your First Pivot Table
  • Simplifying summary organizing field
  • Configure Pivot Table Layout
  • Setting Pivot Table Style
  • Changing Number Format
  • Turn On summary with Subtotal and Grandtotal
  • Navigating report using Expanding and Collapsing
  • Rearranging Top and Bottom value
  • Enabling Multiple Filer
  • Label Filter
  • Value Filter
  • Grouping Date
  • Grouping Your Own Selection
  • Changing Summary Value with different formula
  • Measuring Value as Percentage
  • Preparing Accumulated Value
  • Comparing value against previous and next category
  • Adding calculation for multiple value fields
  • Refreshing Pivot Table for additional data
  • Changing Data Source
  • Highlighting the Top 10 analysis
  • Spotting larger or smaller numbers in a range
  • Applying indicator icon to visualize range of value
  • Getting the right chart to visualize the data
  • Customizing Pivot Chart Layouts and style
  • Joining two type of chart to represent 2 corresponding value
  • Show trends in a series of values with Sparkline – Line
  • Highlight maximum or minimum values with Sparkline – Column
  • Quick formatting multiple sparkline with ONE click
  • Compiling all visual representation into one page
  • Create best layout by position all items
  • Standardize the Formatting of the page
  • Linking important value from pivot table into Dashboard
  • Dynamic filter to update entire dashboard with slicer
  • Focusing on a selected time period with Timeline
  • Linking Excel Dashboard in Power Point
  • Setting interaction with OLE Action Verb
  • Setting Up Presenter View
  • Presenting Dashboard

Trainers

Reviews

Interested In

MASTERING DASHBOARD FOR VISUAL REPORT

Starting From
RM1000
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Book Now

Course Name: MASTERING DASHBOARD FOR VISUAL REPORT
Duration: 2 Days
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM
0.00

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Download Details

Name *
Email *
Contact No. *