Ways to train
Live, instructor-led training in a standard, professional classroom environment
Live, instructor-led training conducted over the internet, with hands-on labs
An online, HTML5, self-paced learning experience available for all courses
Private training for your entire team, delivered at your location, a training center, or online
Video classroomLearn more about our training formats
High-definition video of our most popular courses, streamed to your laptop or personal device
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.
Request more information
Inquiry for: Myself My Company
Our learning consultant will get back to you in 1 business day
Visualized Excel Dashboard
Creating Impressive Visualized Excel Dashboard
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.
This course is intended for Information Workers
• Formulas & Functions
• Pivot Table
This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise
• 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.Read More