| Event Profile | |
| Class/ Online | Classroom |
| Date | 15 September 2026 |
| Time | 9am to 5pm |
| Venue | Holiday Inn Atrium Singapore (Halal Certified) 317 Outram Road Singapore 169075 |
| Fee | 9% GST will apply SGD 550.003 & above: SGD530.00 each For Member SGD 522.5 3 & above: SGD503.5 each |
| Note | Two tea breaks and buffet lunch will be served. Limited complimentary car parking coupons are available upon request. |
| Other Date(s) | 1) 22 Apr 2026 2) 14 Jul 2026 |
| Trainer | |
| Activity | |
| You may reach us via T: 6204 6214 E: info@ccisg.com Alternatively, you may send below details to register Contact Person Company (optional), Name, Job Title, Mailing Address, Tel, Email Participant(s) Name, Job Title, Email | |
This hands-on course introduces participants to the techniques and best practices for designing interactive business dashboards in Microsoft Excel. Learners will gain practical experience transforming static data into dynamic, visually compelling dashboards that provide actionable insights.
Through guided exercises, participants will explore Excel's advanced tools—such as PivotTables, PivotCharts, Combo Charts, Conditional Formatting, and Form Controls—to create dashboards that automate data updates, visualize key performance indicators (KPIs), and communicate business stories effectively.
Participants should bring a laptop with Microsoft Excel version 2010 or later, or Office 365 installed, along with a power adaptor and a USB mouse. Please note that this course is not suitable for Mac versions of Excel.
Through guided exercises, participants will explore Excel's advanced tools—such as PivotTables, PivotCharts, Combo Charts, Conditional Formatting, and Form Controls—to create dashboards that automate data updates, visualize key performance indicators (KPIs), and communicate business stories effectively.
Participants should bring a laptop with Microsoft Excel version 2010 or later, or Office 365 installed, along with a power adaptor and a USB mouse. Please note that this course is not suitable for Mac versions of Excel.
Objective
Upon completion, participants will be able to:
- Understand key principles of dashboard design and visualization for business decision-making.
- Prepare and structure data for dashboard use with efficient reference tables and dynamic data ranges.
- Create and customize interactive components using PivotTables, Charts, and Slicers.
- Apply advanced Excel features such as Conditional Formatting, Sparklines, and Form Controls to enhance dashboard interactivity.
- Build, automate, and present a complete business dashboard that provides clear insights and performance trends.
Outline
Topic 1: Understanding Business Dashboards
Topic 2: Creating Analytical Views with PivotTables and Charts
Topic 3: Enhancing Dashboards with Dynamic Visuals
Topic 4: Adding Interactivity with Form Controls
- What makes an effective dashboard?
- Characteristics of good dashboards — clarity, simplicity, interactivity, and visual storytelling.
- Identifying dashboard objectives and target users.
- Key elements of dashboard design — KPIs, layout, and usability.
Topic 2: Creating Analytical Views with PivotTables and Charts
- Building PivotTables to summarize business data.
- Creating PivotCharts and Combo Charts for multi-variable visualization.
- Designing trend, comparison, and composition visuals.
- Adding Slicers and Timelines for interactive filtering.
Topic 3: Enhancing Dashboards with Dynamic Visuals
- Using Conditional Formatting for heatmaps, KPIs, and thresholds.
- Integrating Sparklines to show mini trend indicators.
- Creating Drop-Down Lists for user-driven selections.
- Automating dashboards with Dynamic Ranges and Table Lookups.
Topic 4: Adding Interactivity with Form Controls
- Understanding Excel Form Controls and their applications.
- Creating interactive elements:
- Checkboxes for on/off data views.
- Option Buttons for category selection.
- Combo Boxes and Scroll Bars for flexible visualization.
- Linking Form Controls with cell references and formulas.
- Building dynamic dashboards that respond to user input.
Who should attend
Anyone with intermediate Excel skills aiming to create interactive analytical dashboards.
Methodology
This fast-paced 1-day hands-on course features step-by-step guidance, practical exercise files for each topic, and short Q&A sessions after every segment.
Testimonial
"With concise and clear delivery, the trainer effectively covered predictive and prescriptive forecasting using large data sets."
"Patient and thorough, the trainer ensures everyone is on track, making everything in the workshop highly useful."
"The trainer is excellent at simplifying complex statistical concepts and emphasising practical application, making everything in the workshop highly useful."
"Patient and thorough, the trainer ensures everyone is on track, making everything in the workshop highly useful."
"The trainer is excellent at simplifying complex statistical concepts and emphasising practical application, making everything in the workshop highly useful."
Dwight Nuwan Fonseka's Profile
Head Data Analyst | Data Governance & AI | CAIP | CDSP | ACLP
Dwight Fonseka is a seasoned data analytics professional with over a decade of experience in big data, predictive modeling, and AI. Holding a Master’s in Education (NTU), a degree in Biotechnology (NUS). He is a Certified AI Practitioner (CAIP), Certified Data Science Practitioner (CDSP), and ACLP-certified trainer with extensive experience delivering data-driven insights and practical applications across industries.
Dwight has held roles such as Senior Data Analyst and Data Governance Officer at Plano Pte Ltd, specializing in healthcare analytics and machine learning. As an adjunct trainer, he delivers practical courses in data visualization, data storytelling, deep learning, and AI business models, using tools like R, Python, Tableau, and RapidMiner.
Notable Topics Trained:
Dwight Fonseka is a seasoned data analytics professional with over a decade of experience in big data, predictive modeling, and AI. Holding a Master’s in Education (NTU), a degree in Biotechnology (NUS). He is a Certified AI Practitioner (CAIP), Certified Data Science Practitioner (CDSP), and ACLP-certified trainer with extensive experience delivering data-driven insights and practical applications across industries.
Dwight has held roles such as Senior Data Analyst and Data Governance Officer at Plano Pte Ltd, specializing in healthcare analytics and machine learning. As an adjunct trainer, he delivers practical courses in data visualization, data storytelling, deep learning, and AI business models, using tools like R, Python, Tableau, and RapidMiner.
Notable Topics Trained:
- Data Analytics & Visualization (R, Tableau, Excel)
- Machine & Deep Learning (RapidMiner, DeepCognition)
- Data Governance & AI Business Models
- Predictive Analytics & Data-Driven Decision-Making
