Microsoft Excel Dashboard Training: 1 Day

Microsoft Excel Dashboard Training Course Microsoft® Excel Dashboard Training
By Knowledge Hub Asia
Microsoft Excel Series:

Microsoft® Excel Dashboard for Reporting & Project Management

“Helping organizations make decisions that increase profitability and reduce costs.”

By Knowledge Hub Asia


HRDF Registered Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Register for Public TrainingRegister for Public Training
Email Customer Service inquiry@knowledgehub-asia.com Contact Customer Service +603-7625-9861
+603-7625-9862
Course Title:
Microsoft Excel Dashboard for Reporting & Project Management
Training Category:
Soft Skills
Duration:
1 Day
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.
Public Training Events
Nov 2019 ›
Venue:
The Hub, Jaya One, Petaling Jaya, Malaysia
Schedule:
Fri 08 Nov 2019 9:00AM - 5:00PM
Fee Per Person:
RM1,000.00*
*
Additional fee for bank charges and currency exchange will be imposed for payment made by foreign currency. Promotions:
  • Please call for Discounts & Promotions.
Register Now!

* Other terms & conditions apply.
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact Knowledge Hub Asia
Contact customer service +603-7625-9861
+603-7625-9862
Email customer service inquiry@knowledgehub-asia.com
Delivery Methods
  • Language: English
  • Certificate of Participation
  • Lecture
  • PowerPoint Presentation
  • Computer Lab Work
  • Workshop
Ad by Google
*Terms & Conditions

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

Course Objectives ›

  • 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

Prerequisites ›

  • 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 ›

DAY 1

Module 1: Basic Decision Making & Analysis Function

  • i. Sum, Average, Max, Min, Rank and Count
  • ii. IF statement
  • iii. Vlookup, IndexMatch Lookup & Hyperlink
  • iv. Conditional Formatting

Module 2: Basic Analysis Graph

  • i. Column, Bar, Line, Pie and Donut

Module 3: Pivot Table & Charts

  • i. 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
  • ii. Destination
    • a. Within same sources file or same workbook different worksheet
    • b. Other workbooks
    • c. Pro's and Con's different workbook
  • iii. 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: Dashboard

  • i. Report Layout & Design
  • ii. Interactive Charts (Progression and Speedometer)
  • iii. Basic Dashboard Project

Contact Us Now ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall Us : +603-7625-9861+603-7625-9862
Email Customer Service E-mail Us : inquiry@knowledgehub-asia.com

Related Courses ›

Published by: ,
Contact Us

"Hi, I'm your Contact Assistant! I'll help you to reach the right party for the right information. Click me to get started!"

Contact Assistant