Location
-
Format
What’s this? Ways to train
Classroom
Live, instructor-led training in a standard, professional classroom environmentVirtual
Live, instructor-led training conducted over the internet, with hands-on labsOnline
An online, HTML5, self-paced learning experience available for all coursesOn-site
Private training for your entire team, delivered at your location, a training center, or onlineVideo classroom
Learn more about our training formats
High-definition video of our most popular courses, streamed to your laptop or personal device
-
2 Days
-
All of our private classes are customized to your organization's needs.
-
Click on the button below to send us your details and you will be contacted shortly.
Already purchased this offering? Log in
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
Modules
• Introduction to Dashboards
• Data Visualisation Tools
• When to Use a Secondary Axis
• Combining Two Chart Types
• Formatting Tricks
• 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
• Creating Interactive Reports
• An Alternative to The VLOOKUP Function
• Variance Analysis Dashboard
• Returning A Value Based On User Selection
• Incorporating Controls
• Incorporating Hyperlinks
• Automating Dashboards with Functions
• Offset Function
• Count A Function
• Structuring Your Data
• Linked Textbox
• Named Formulas
• Creating Speedometer Charts
• Visual Basic for Applications
• What Is VBA?
• Basics of VBA & Macros
• Executing A Procedure
• Converting A Workbook to A Macro Enabled Workbook
• Rule for Building Dashboards

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.

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.
Course Reviews
0
0 Ratings