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

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.

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
• Software requirement: Microsoft Excel version 2010 or higher or Office 365 installed

• PC/Windows operating system laptop with Microsoft Excel version 2010 or higher or Office 365 installed (personal laptop is preferred as some company laptops may have security restriction)
• Laptop power adaptor
• USB mouse