2-Day Data Analysis using Dynamic and Interactive Excel Dashboard Course

Course Overview

This course is created, owned and trained by Mr. Alaster Leong. Learn from the original creator of this course.

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

Objectives

Upon completion of the course, learners will be 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

Who Should Attend

This course is recommended for anyone who

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

Methodology

This is a hands-on practical course. Trainer will walk through the topic step-by-step. Learners will be provided with exercise files on every topic to effectively apply what have been taught. A short Q & A session will be available after each topic.

Prerequisites

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.

Things To Bring

A Windows operating system laptop with Microsoft Excel version 2010 or higher or Office 365 installed.
Laptop power adaptor and a USB mouse.

Course Information

Fee

SGD 755.00 (Net)

Absentees will be charged the full course fees

Time

9:00am to 5:00pm (14 hours)

Mode

Classroom @ Hotel

(Venue may be subject to changes)

Dates

21-22 Nov 2024
06-07 Feb 2025
08-09 May 2025
04-05 Aug 2025
06-07 Nov 2025

Closed Class

Important Note

Closed Class

Important Note

Why Learn With Us?

Course Outline

1. The Concept of Dashboard

2. Excel Functions for generating Dynamic Data

3. Excel Form Controls for Interacting with the Dashboard

4. Defining the KPIs

5. Preparation – Create all Dynamic Data (KPIs) for the Dashboard

6. Designing the Dashboard – The Interface

7. Building a Sales Dashboard (using Formulas)

8. Building a HR Dashboard (using Pivot Table)

Our Dedicated Lead IT Trainer - Mr. Alaster Leong

This course is created, owned and trained by Mr. Alaster Leong. Learn from the original creator of this course.

Alaster has been training adult learners in IT in both the private and public sectors since 1986. Alaster’s career before training centred around IT for over 12 years, as he held various roles within software development. He has earned himself a Microsoft Office Specialist (MOS) certification and he is an existing Trainer approved by People’s Association (PA). He was also a former Associate Trainer with the Civil Service College.

He specialises on training Microsoft Applications and Adobe Photoshop. Based on his vast experience and keeping abreast with the emerging trends, tools and technologies with the IT industry, especially software, he has extensively involved in developing several course outlines and course materials and conducting training to equip learners with skills in-demand or likely to be most important in the jobs of the future work.

Alaster constantly explore innovative and effective ways in imparting knowledge and engaging his learners at the same time. He also focuses his training on providing practical solutions to real-life problems, especially Excel. He is more than willing to help overcome various problems faced by his learners that arise in their workplace in applying their newly-acquired knowledge and skills any time after the course. He is well-known for his dedication, commitment and passion to training that makes him well-liked and appreciated by his learners.