Excel Dashboard Training MasterClass

Training Course Fees

The full course fees for this training is S$900, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.

Grant Information

WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).

Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.

Companies sending Locals & Foreign staff for training can avail SFEC Funding
Use it to improve the skills of your entire department!

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

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6250-3575 for Details or WhatsApp Now at +65-9066-9991

70% Grant

$630 Funding by SSG
900
Pay $270
  • Singaporeans Above 40 Years
  • Individuals
  • SME Companies
  • Individuals Can Use SkillsFuture
  • UTAP Funding*

50% Grant

$450 Funding by SSG
900
Pay $450
  • Below 40 Years
  • Individuals
  • SG / PR / MNC Companies
  • SkillsFuture (Singaporeans only)
  • UTAP Funding*

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

Logistics

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

PRACTICAL * HANDS-ON * FULL OF EXAMPLES & CASE STUDIES * GREAT VALUE FOR MONEY

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.

To join an Excel Dashboard MasterClass in Singapore, where you’ll learn how to create interactive dashboards using features such as Slicers, Pivot Tables, Drop-downs, and other interactive controls, the following prerequisites may be beneficial:

Basic Excel proficiency: It’s important to have a fundamental understanding of Excel, including knowledge of formulas, functions, data entry, and formatting. Familiarity with common Excel features like cell referencing, data manipulation, and basic calculations will be advantageous.

Laptop and software: Participants will be provided with a laptop in the class. Several participants typically bring their own laptops with the necessary software installed. If you want to use your own laptop, make sure you have a compatible version of Excel, preferably the latest, as some advanced features may not be available in older versions.

Contact us for the specific questions on prerequisites and requirements of the Excel Dashboard MasterClass you are interested in attending in Singapore.

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 12 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!