Visualized Excel Dashboard | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Visualized Excel Dashboard

Location

Format What’s this?
  1. 2 Days
  1. All of our private classes are customized to your organization's needs.
  2. Click on the button below to send us your details and you will be contacted shortly.
Request more information

Inquiry for: Myself    My Company

By providing your contact details, you agree to our Privacy Policy

 

 

 

Thank You

Our learning consultant will get back to you in 1 business day

Visualized Excel Dashboard

OVERVIEW

Creating Impressive Visualized Excel Dashboard

OBJECTIVE

An amazing interactive Excel dashboard allow users to update the report with the click of refresh button, or even with a simple copy and paste of your new data into your spreadsheet. The dynamic dashboard provides insight, analysis and alert to users.

AUDIENCE

This course is intended for Information Workers

PREREQUISITES

• Formulas & Functions

• Pivot Table

• Charts

• Macros


METHODOLOGY

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

Expand All

Modules

Chapter 1

• Introduction to Dashboards

• Why Excel Dashboards
• What Do I Need?
• What Makes Good Dashboard
• Using The Proper Visualizations
• Dashboard Creation Process
• Why Is the Chart Type Important?

Chapter 2

• Data Visualisation Tools

• When to Use a Secondary Axis

• Combining Two Chart Types

• Formatting Tricks


Chapter 3

• Analyzing Data with Pivot Reports

• What Are Pivot Reports?

• Creating A Dynamic Range for Data Expansion

• Creating a Pivot Report

• Incorporating Visual Analysis

• Grouping Data

• Adding Interactive Elements

• Slicing & Dicing Data

• Querying Pivot Reports

• Incorporating Data Validation


Chapter 4

• Creating Interactive Reports

• An Alternative to The VLOOKUP Function

• Variance Analysis Dashboard

• Returning A Value Based On User Selection

• Incorporating Controls

• Incorporating Hyperlinks


Chapter 5

• Automating Dashboards with Functions

• Offset Function

• Count A Function

• Structuring Your Data

• Linked Textbox

• Named Formulas

• Creating Speedometer Charts


Chapter 6

• Visual Basic for Applications

• What Is VBA?

• Basics of VBA & Macros

• Executing A Procedure

• Converting A Workbook to A Macro Enabled Workbook


Chapter 7

• Rule for Building Dashboards

Anne Teoh Hui San

Anne Teoh Hui San

A rising and highly engaging trainer, Anne Teoh represents a new face for Microsoft Office training. She has been involved in training Microsoft Windows 8 and Windows Phone development and design Microsoft Student Partners (MSP) for a year. Within her first year venture into the training industry, she is now highly sought after by banking, investment firms and high-tech industries; to execute competent Microsoft Office training. She specializes in delivering Office Word, Office Excel and Office PowerPoint trainings, having most of the occasion delivering beyond client expectations of what defines a training.Focusing heavily on delivering hands-on experience to her participants, she instils a robust understanding of the fundamentals for Microsoft Office training; as she strongly views that traditional delivery of training should be phased out and delivered in a lively manner that reflects the everyday routine of a given professional.Besides training, she is also as a deeply involved the development of Windows Phone Applications, mostly handling the UI/UX portion.


Read More

Chin Chee Chong

Chin Chee Chong

Chin Chee Chong has been in the Information Technology industry for the past 21 years starting and is well-versed in troubleshooting, assembling of PCs, IT software applications, IT training and development for Microsoft Office users.

He is one of the pioneer certified Microsoft Word, Excel, PowerPoint, Access and Outlook trainers in Malaysia having attained his Microsoft Office Specialist Master Instructor (MOS) and Microsoft Certified Trainer (MCT) by Microsoft USA.

His extensive tutelage experiences spanning over 12 years stem from conducting courses for corporate companies such as American Insurance Group Berhad (AIG), Allianz General Insurance Malaysia Berhad, Citibank Berhad, Favelle Favco Berhad, EC-Council Academy,HSBC Bank Malaysia Berhad, Institute of Bankers Malaysia (IBBM), Jerneh Insurance Berhad, OCBC Bank Berhad, Proton Holding Berhad, Shell Information Technology International, Sime Darby Plantation Sdn Bhd, SP Setia Berhad, Wong Engineering Electronics Berhad and many more.

Read More

Course Reviews

No Remarks

0

0 Ratings