Excel Dashboard Training MasterClass

Learn the Best Tricks to Transform Data into Information, and become an Excel Ninja Excel Dashboard Training Advanced Techniques for Using Formulas, Pivot Tables, Charts & Dashboards in Excel in a Sales, Marketing, Accounting or Service Department.

You must have basic knowledge of Microsoft Office 365, Excel 2019, Excel 2016 or Excel 2013.

Two Day Excel Dashboard Training in Singapore – Conducted by Master Trainer Vinai Prakash, MBA, PMP, GAP – noted speaker, author, consultant and founder of Intellisoft.

Vinai has over 35 years of experience in analyzing data and is an expert an Data Mining & Data Analysis using Microsoft Excel and many other business intelligence tools.

SDF Funding is available to Singapore Companies (For company sponsored candidates). Call +65 6250-3575 for Details.

SkillsFuture credits ready for Singaporeans.

UTAP Funding: NTUC Members can utilize UTAP to offset 50% of the remaining fees*.

Click Here to Download The 8 Habits of Highly Effective Data Analysts (An Article Written by Vinai Prakash, published in the Straits Times, Singapore )

Recommended Reading: Creating Management Dashboards in Microsoft Excel

Today, Microsoft Excel has become extremely power tool for any data warrior. Whether you work in Sales, Marketing, Customer Service, Logistics, Accounts, Manufacturing, Finance or Administration, everyone must become an expert at using Microsoft Excel.

Please visit Creating Management Dashboards in Microsoft Excel

Sales, Marketing, Finance, IT Executives, Engineers, Project Managers, Directors, CXOs, Managing Directors, General Managers, and Data Warriors who dabble with data and want to learn advanced techniques to convert Data into actionable Information. Dynamic Chart with Dropdown in Excel Dashboard Training Singapore


This 2 Day Excel Dashboard Training Masterclass will be held in Singapore.
Tea/Coffee, Light Snacks are provided in this training.

Go To Top

This course is suitable for people with basic experience in using Excel. You should be able to write simple functions and formulas in Excel.

Apple Mac with Excel 2016 or above is supported for this training.

For Window Users, You can use Microsoft Office 365, Excel 2019, Excel 2016, Excel 2013 or even Office 2010 for this training.

Go To Top

Excel Dashboard Training in Singapore – Course Outline:

Excel Dashboard Training Singapore - Sample Dashboard done in Excel

1. Understanding Management Dashboards

  • What is a Dashboard?
  • Principles of Great Dashboard Design

2. Using Advanced Formulas & Functions in Excel

  • Referencing & Ranges
  • Advanced Lookup
  • Advanced Formatting

3 Advanced Pivot Table Techniques in Excel

  • Percentage
  • Computed Columns
  • Grouping & Sorting
  • Top Views
  • Multiple data sources
  • Pivot Charts & Visual Dashboarding Techniques

Excel-Dashboard to Compare Sales - Training Example4 Advanced Power Charting Techniques

  • Thermometer Chart
  • Doughnut Chart
  • Pareto chart
  • Versatile management dashboards

5 Creation of Excel Dashboards Using Macros

  • Simple & Complex Macros
  • Dynamic Dashboards using Macros

6 Creating Dynamic Dashboards with Excel for Management Reporting

  • Complete Management Dashboard for Sales & Services
  • Best Practices in Dashboard Design

7 Practical Dashboard Creation: Hands-on Dashboard Creation in the Workshop

  • Creating a Sales Dashboard
  • Creating a Services Dashboard
  • Creating a HR Dashboard

Excel Sales Dashboard Demo in Excel Dashboard Training Singapore

Click here to Register for the 2 Day Excel Dashboard MasterClass


Go To Top

You should have knowledge of the basics of using Microsoft Office 365 / Excel 2019 / Excel 2016 / 2013 / 2010 and using simple functions and formulas.

You must know how to cut, copy and paste, do AutoSum and write simple formulas in Excel before you join the Excel Dashboard Training.

Go To Top

Microsoft Training at Intellisoft

Claim SDF Grant

Companies sponsoring their staff for training can Claim SDF Funding, subject to SSG Eligibility Criteria.

Applicable for Company Sponsored Singaporeans & PRs.

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Excel Dashboard MasterClass in Singapore. Create Dynamic Charts and Reports quickly using Excel

Do You Have a Question or Need a Quotation?

Simple. Just tell us what you need here. We’ll be glad to help you!

Some of the companies that experienced our trainings

How To Register

Register for Excel Dashboard Training Singapore today by simply clicking on the chosen course date available at the top of this page.

Need Help?

Excel Dashboard Training Participants
Excel Dashboard Training Participants at Intellisoft
  1. Call us at +65 6250-3575, SMS / WhatsApp: +65 9066–9991
  2. Send an email  to  training@intellisoft.com.sg  OR
  3. Submit an online enquiry if you have  any questions regarding Dashboard Masterclass training.

We also offer Corporate Trainings for Excel Dashboard Training Singapore, if you have a group of 10 or more people. We can arrange to conduct the Dashboards training at your office location.

Learn to Analyze & present Data Effectively
Accelerate Your Career in Business Analytics

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Python, Power BI, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!

Our Founder, Vinai Prakash Wrote For The Straits Times.

Turning Data Into Information

Request a Copy by Email & Benefit From It

Found What You Were
Looking For?

Just Tell us...

We're Here To Help You!