Excel dashboard masterclass

Learn the Best Tricks to Transform Data into Information, and become an Excel Ninja

 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 Excel 2010, Excel 2013 or Excel 2016.

Two Day Excel Dashboard Training in Jakarta – Conducted by Master Trainer Vinai Prakash, MBA, PMP, GAP – noted speaker, author, consultant and principal business analyst.

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

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

Course Objectives

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.

Lunch, Tea/Coffee, Light Snacks are provided in this training.

Target Audience

This course is not suitable for Absolute Beginners in Microsoft Excel. Apple Mac is not supported for this training.

You can use Excel 2016 or Excel 2013 or Excel 2010 for this training.

Excel Dashboard Masterclass

Course Outline

Understanding Management Dashboards
  • What is a Dashboard?
  • Principles of Great Dashboard Design
 Using Advanced Formulas & Functions in Excel 2010/2013
  • Referencing & Ranges
  • Advanced Lookup
  • Advanced Formatting
Advanced Pivot Table Techniques in Excel 2010 or 2013
  • Percentage
  • Computed Columns
  • Grouping & Sorting
  • Top Views
  • Multiple data sources
  • Pivot Charts & VIsual Dashboarding Techniques

Advanced Power Charting Techniques

  • Thermometer Chart
  • Doughnut Chart
  • Pareto chart
  • Versatile management dashboards
Dashboard Macros
  • Simple & Complex Macros
  • Dynamic Dashboards using Macros
Creating Dynamic Dashboards with Excel 2010 / Excel 2013 for Management Reporting
  • Complete Management Dashboard for Sales & Services
  • Best Practices in Dashboard Design

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

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


Course Trainer

This training course is created and delivered by Mr. Vinai Prakash, Master Trainer & Founder of Intellisoft.

He has authored several articles on Data analysis, Excel Dashboarding Techniques, Data Warehousing, Data Mining, Using SQL Databases for Creating Data Rich applications,  which are published all over the world.

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


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

Testimonials : Comments from Past Participants of the Management Reporting with Excel MasterClass

It covered advanced techniques which I did not already know. – Mark Stephens, SRQ

I loved the Dashboard Training. It is like we are magicians. – Lim, Leo Pharma

I liked the simple methods to create amazing dashboards. It will help me better interpret and present the data. – Rena, Certis Cisco

This training will help me in creating management reports for presentation of financial data / KPIs to the management. – Ong, Keppel FELS

There were lots of exercises to better understand the various concepts. I liked the hands on training. – Nah, Asiawide Franchise

Need Help?

Call us at +65 6392-4590 or Send an email  to  corporate@intellisoft.com.sg