This course is conducted in PC/Windows operating system

2-Day Data Analysis Using Dynamic And Interactive Excel Dashboard
Course In Singapore

Learn how to create an interactive Excel Dashboard for data analysis and displaying of KPIs to monitor business health

Data Analysis Using Dynamic And Interactive Excel Dashboard Course Overview

Visualizing All Data, At A Glance

Do you find pulling and manipulating data from multiple sources manually challenging? The process is often tedious, sub-optimal and even inefficient. Have you ever wondered about how you could generate relevant information and gain insights from your data using Excel? Dashboards are the key in today’s data-driven environment.

So, what exactly is an Excel Dashboard? A dashboard provides real-time results by aggregating and extracting value from all of the collected data, otherwise known as Key Performance Indicators (KPIs).

A data dashboard is an information management tool that visually tracks, analyses and displays key performance indicators (KPI), metrics and key data points to monitor the health of a business, department or specific process. They are customizable to meet the specific needs of a department and company. Through the use of data visualizations, the use of an excel dashboard simplifies complex data sets into manageable chunks of visual information and other strategic data to provide users with an awareness of current performance – at a quick glance.

Microsoft Excel is a power data analysis tool for creating interactive Dashboards. Much more affordable and highly available as compared to other tools, learning how to build them through our advanced Excel dashboard training will be a great addition to your skills. Likewise, as Excel is a commonly used application globally, you will be able to employ the skills attained in our Excel dashboard course in Singapore anytime.

At the end of the course, learners are able to:

  • understand the concept of Dashboard
  • build the Dashboard from scratch
  • design and prepare Dashboard
  • use some powerful Excel functions to create dynamic data 
  • import data from various sources, merge data and organize them for visual presentation
  • analyse data to gain insights to support decision making
  • use Form Controls to interact with the Dashboard
  • build and maintain the Dashboard

This course is for anyone:

  • who is an intermediate-to-advanced Excel user looking to take their skills to the next level
  • who wants to use Excel to visualize the Key Performance Indicators (KPIs) and other strategic data for your organization at a glance (e.g. Accountant/Finance, Human Resource, Business, Sales, Data Analysts, Stock or Forex Traders and Business Owners) 
  • who is keen on learning how to create dynamic and interactive Dashboard reports
  • who is interested to improve the design of their existing Excel reports
  • who wants to know more about Excel power lookup functions to create dynamic data lists
  • who is keen to explore Excel form controls to add interactivity into the chart or data lists

This is a hands-on practical course. Our trainer will walk through each of the topics step-by-step. Learners will also be provided with exercise files on each topic to practise application of what has been taught. A short Q & A session will be available after each topic.

  • Must have at least Intermediate Excel skills
  • Must be well versed in using Excel functions such as IF, OR, AND, and nested functions
  • Knowledge in creating basic Microsoft Excel Chart
  • Being well versed with Excel Pivot Table will be an added advantage, but not mandatory 
  • PC/Windows operating system laptop (personal laptops are preferred as some company laptops may have restrictions in accessing the Internet and USB thumb drive)
  • Laptop power adaptor
  • A USB mouse
  • A USB thumb drive or hard-disk
  • Software requirement: Microsoft Excel version 2010-2019 or Office 365

Course Outline

Our Dedicated Trainer

Having trained adult learners specialising in IT from both public and private sectors since 1986, Alaster has a wealth of experience in training. Before moving into the training sector, Alaster worked in IT for over 12 years – boasting a wide range of roles held within software development. Prior to being approved by People’s Association (PA) as a certified trainer, Alaster was an Associate Trainer with the Civil Service College. He also holds Microsoft Office Specialist (MOS) certification and specialises in training Microsoft Office Applications and Adobe Photoshop.

With his vast experience and commitment to keeping abreast with emerging trends, tools and technologies within the IT and software industry, Alaster is extensively involved in developing course outlines and materials that equip learners with up-and-coming skills in demand for the future of work.

In constantly exploring innovative and effective methods of imparting knowledge, Alaster is able to engage his learners in the courses he conducts. A large part of his trainings are committed to providing practical solutions to real-life problems, especially in the Excel courses he conducts. An approachable and engaging trainer, Alaster is always willing to aid his learners in overcoming various problems using the skills acquired even after courses. Well-known and liked for his dedication, commitment and passion for training, Alaster is appreciated by his learners.

This Excel Dashboard Training conducted by Alaster will help you gain confidence and refine your Excel skills at the workplace.

Online Registration

For organisations applying with more than 2 learners, please click here to download the registration form.

All registration forms should be submitted at least 2 weeks before course commencement. Many courses have pre-requisites, intended to foster a learner’s success in the course. Be sure to check the necessary pre-requisites before registering.

Online Registration Form – Company

Part A:     Course Information

  • Create Fill-in Form in Word & Import Form Data from Excel
  • Creating Dynamic & Interactive Chart in Excel
  • Data Analysis using Dynamic & Interactive Excel Dashboard
  • Data Analysis with Excel Power Query, Data Model & Power Pivot
  • Data Analytics using Power BI Desktop Series 1 – Data Modelling & DAX Formulas
  • Data Analytics using Power BI Desktop Series 2 – Time Intelligence & Dashboard Visualization
  • Excel 100 Tips & Techniques
  • Excel Advanced Formulas & Functions
  • Excel Data Cleansing & Building Techniques
  • Excel Pivot Table In-Depth
  • PowerPoint Tips & Techniques
  • Word Tips & Techniques
  • ————————————————————————————————————————————————————————————-
  • 21st Century Supervisory Management Skills
  • Adapt, Evolve and Change – Embracing Changes in an Ever-Transforming Work Environment
  • Better Grammar for Business
  • Dealing with Difficult Customers Behaviour
  • Editing & Proofreading Skills
  • Emotional Intelligence Skills to Make A Difference In your Service to Customers
  • How to Talk to Anyone: The Art of Everyday Conversation
  • Keys To Increase Your Focus & Productivity At Work
  • Kickass Presentations Intensive
  • Leading with Influence:Walk, Talk And Act Like A Boss™
  • Managing Conflict and Confrontation the Less Stressful Way
  • MEMORY Empowerment Workshop for Higher Efficiency
  • Mistake Proofing Your Process, Products and Services
  • Nurturing Your Creative Brain
  • Persuade Like A Lawyer
  • Persuasion and Influence Secrets
  • Proactive Failure Management using FMEA (Failure Mode Effect and Analysis)
  • Problem Solving the 8D (Disciplines) Approach
  • Quality Control Tools for Data Analysis and Problem Solving
  • Quick Guide for Supervisory Management Roles
  • Reducing Stress While Optimizing Your 24/7
  • Systematic Approach to Solve Problems and Make Decisions
  • The Art of Technical Writing
  • The CRM Ways to Long Lasting Relationship
  • The Fundamentals of Business Process Reengineering – Don't Wait for Something to be Broken to Fix It!
  • The Real Approach (and Human Side) of Project Management
  • The Transformative Power of Story: Using Storytelling to Lead, Sell & Influence
  • Uncover Your Communication Power Towards Greater Understanding
  • Understanding how to be LEAN (not just for manufacturing industry)
  • Writing Better Emails
  • Month
  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December
  • Day
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • Year
  • 2018
  • 2019
  • 2020
  • 2021
  • 2022
  • 2023
  • 2024
  • 2025
  • 2026
  • 2027
  • 2028
  • 2029
  • 2030
  • 2031
  • 2032
  • 2033
  • 2034
  • 2035
  • 2036
  • 2037
  • 2038
  • Month
  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December
  • Day
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • Year
  • 2018
  • 2019
  • 2020
  • 2021
  • 2022
  • 2023
  • 2024
  • 2025
  • 2026
  • 2027
  • 2028
  • 2029
  • 2030
  • 2031
  • 2032
  • 2033
  • 2034
  • 2035
  • 2036
  • 2037
  • 2038

Part B:     Company Information

Part C:     Particulars of Training Coordinator / Contact Person

  • Mr.
  • Mrs.
  • Ms.
  • Miss
  • Prof.
  • Dr.

Part D:     Billing Information 

Part E:     Learner(s) Information

Learner 1

  • Mr.
  • Mrs.
  • Ms.
  • Miss
  • Prof.
  • Dr.
  • Singaporean
  • Singapore PR
  • Others
  • Muslim
  • Vegetarian
  • No Preference

Learner 2

  • Mr.
  • Mrs.
  • Ms.
  • Miss
  • Prof.
  • Dr.
  • Singaporean
  • Singapore PR
  • Others
  • Muslim
  • Vegetarian
  • No Preference
  • ALS Sales Team / Email Updates
  • Search Engines (Bing, Yahoo, Google)
  • Social Media (LinkedIn, Facebook)
  • Referral (Colleagues, Friends, Family)
  • Others

Online Registration Form – Individual

Part A.     Course Information

  • Create Fill-in Form in Word & Import Form Data from Excel
  • Creating Dynamic & Interactive Chart in Excel
  • Data Analysis using Dynamic & Interactive Excel Dashboard
  • Data Analysis with Excel Power Query, Data Model & Power Pivot
  • Data Analytics using Power BI Desktop Series 1 – Data Modelling and DAX Formulas
  • Data Analytics using Power BI Desktop Series 2 – Time Intelligence & Dashboard Visualisation
  • Excel 100 Tips and Techniques
  • Excel Advanced Formulas & Functions
  • Excel Data Cleansing & Building Techniques
  • Excel Pivot Table In-Depth
  • PowerPoint Tips & Techniques
  • Word Tips & Techniques
  • 21st Century Supervisory Management Skills
  • Adapt, Evolve and Change – Embracing Changes in an Ever-Transforming Work Environment
  • Better Grammar for Business
  • Dealing with Difficult Customers Behaviour
  • Editing & Proofreading Skills
  • Emotional Intelligence Skills to Make A Difference In your Service to Customers
  • How to Talk to Anyone: The Art of Everyday Conversation
  • Keys To Increase Your Focus & Productivity At Work
  • Kickass Presentations Intensive
  • Leading with Influence:Walk, Talk And Act Like A Boss™
  • Managing Conflict and Confrontation the Less Stressful Way
  • MEMORY Empowerment Workshop for Higher Efficiency
  • Mistake Proofing Your Process, Products and Services
  • Nurturing Your Creative Brain
  • Persuade Like A Lawyer
  • Persuasion and Influence Secrets
  • Proactive Failure Management using FMEA (Failure Mode Effect and Analysis)
  • Problem Solving the 8D (Disciplines) Approach
  • Quality Control Tools for Data Analysis and Problem Solving
  • Quick Guide for Supervisory Management Roles
  • Reducing Stress While Optimizing Your 24/7
  • Systematic Approach to Solve Problems and Make Decisions
  • The Art of Technical Writing
  • The CRM Ways to Long Lasting Relationship
  • The Fundamentals of Business Process Reengineering – Don't Wait for Something to be Broken to Fix It!
  • The Real Approach (and Human Side) of Project Management
  • The Transformative Power of Story: Using Storytelling to Lead, Sell & Influence
  • Uncover Your Communication Power Towards Greater Understanding
  • Understanding how to be LEAN (not just for manufacturing industry)
  • Writing Better Emails
  • Month
  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December
  • Day
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • Year
  • 2018
  • 2019
  • 2020
  • 2021
  • 2022
  • 2023
  • 2024
  • 2025
  • 2026
  • 2027
  • 2028
  • 2029
  • 2030
  • 2031
  • 2032
  • 2033
  • 2034
  • 2035
  • 2036
  • 2037
  • 2038
  • Month
  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December
  • Day
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • Year
  • 2018
  • 2019
  • 2020
  • 2021
  • 2022
  • 2023
  • 2024
  • 2025
  • 2026
  • 2027
  • 2028
  • 2029
  • 2030
  • 2031
  • 2032
  • 2033
  • 2034
  • 2035
  • 2036
  • 2037
  • 2038

Part B.     Personal Information

  • Mr.
  • Mrs.
  • Ms.
  • Miss
  • Prof.
  • Dr.
  • Singaporean
  • Singapore PR
  • Foreigners
  • Vegetarian
  • Muslim
  • No Preference
  • No results
  • ALS Sales Team
  • Referrals (Colleagues, Friends, Family)
  • Search Engine
  • Social Media
  • Website
  • Others

Course Information

Course Code:

ALSIT-EDB

Course Fee:

S$700.00 (Nett)

Inclusive of 2 coffee breaks with refreshments and catered/buffet lunch

Call us for a group rebate when you register in a group of 6 or more

Absentees will be charged the full course fee

Course Dates:

  • 14 - 15 Sep 2020
  • 19 - 20 Nov 2020

2 days, 9:00am – 5:00pm
(14 hrs, exclude lunch break)

If you have a group of 6 or more preparing for the same course, you can opt for your own “closed” class. Closed classes are perfect for corporate team training where group learning can make a difference. 

Please note that closed class is not customised class.

Registration:

For Company-Sponsored Learners: Click here to download registration form

For Self-Sponsored Learners:
Click here to download registration form

You can also register online here

For Government Ministries / Agencies on HRMS / ACE, you are unable to see our courses on the list. Please inform your Training Coordinator the Course Code, Course Title, Course Date and the Training Provider is Advanced Learning Singapore to upload into the system for registration

Course Venue:

Details of hotel will be confirmed nearer the course start date

Others:

Complimentary car park coupon upon request (subject to availability and confirmed on a first come, first served basis)

Note:

ALS reserves the right to reschedule, postpone or cancel any course, change the trainer and venue at short notice and at its absolute discretion, due to insufficient enrolment, class size, availability and circumstances outside our control

More Courses By Alaster