Building Dynamic Dashboards Using Excel (Jakarta)

Learn the Best Tricks to Transform Data into Information using Excel

Excel Dashboard Training

Advanced Techniques for Using Formulas, Macros, Pivot Tables, Charts & Dashboards in Excel in a Sales, Marketing, Accounting or Service Department.

Make the most of Microsoft Excel’s Latest and Greatest Features, and Create Dynamic Dashboards with a lot of interactivity, all using Excel.

Jakarta, Indonesia: June 24-25, 2019 (Register Now)

Course Fees: IDR 7,000,000 per person

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 is supported for this training.

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

Go To Top

Excel Dashboard Training - Example 1

1. Understanding Management Dashboards

  • What is a Dashboard?
  • Principles of Great Dashboard Design
2. Using Advanced Formulas & Functions in Excel 2010/2013/2016
  • Absolute & Relative Referencing
  • Working with Ranges
  • Using Conditions & Advanced Lookup
  • Advanced Conditional Formatting
3. Advanced Pivot Table Techniques in Excel 2010/2013/2016
  • Creating simple Pivots
  • Converting to Percentage
  • Creating Computed Columns
  • Grouping Data manually & automatically
  • Sorting a pivot table, creating report pages
  • Viewing Top/Bottom 10%
  • Grouping of dates
  • Loading data from multiple sources
  • Using Conditional Formatting in Pivot Tables & Charts
  • Creating Pivot Charts
  • Using Slicers for creating Dashboards
Excel-Dashboard to Compare Sales - Training Example4. Advanced Power Charting Techniques for Presentations
  • Creating a Thermometer Chart and using Dashboard
  • Creating a Doughnut Chart
  • Creating a Pareto chart to analyze 80-20 Trends
  • Advanced Options in Pivot Charts for creating versatile management dashboards
5. Exploiting Macros to Record Useful Dashboard Macros
  • Recording & Playing Simple & Complex Macros
  • Assign to Buttons for different views of Pivots
  • Creating Dynamic Pivots, Charts using Macros in a Dashboard
6. Creating Dynamic Dashboards with Excel 2010/2013/2016 for Management Reporting
  • Creating a Dashboard with Checkboxes, Radio Buttons
  • Creating a dynamic dashboard with Dropdown Options
  • Assembeling a Complete Management Dashboard for Sales
  • Best Practices in Dashboard Design

Excel Sales Dashboard Demo for 1 day excel dashboard masterclass in Sydney Australia

Click here to Register for the 2 Day Excel Dashboard MasterClass in Indonesia

Go To Top

You should have knowledge of the basics of using Microsoft Excel 2010, Excel 2013 or Excel 2016 and using simple functions and formulas. You should have been using Excel  for a while.

This course is not suitable for Absolute Beginners in Microsoft Excel.

Bring Your Own Laptop – Loaded with Microsoft Excel  2013 or Microsoft Excel 2016, running on Windows or Mac.

Go To Top

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!

Do You Have a Question or Need a Quotation?

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

Some of the companies that experienced our trainings

"What I love about this training is that the trainers make sure we learn the steps and are able to do it on our own. This is a real advantage and I will definitely come back for more practical training"
Michele Martin
HR Manager
“The training was everything I hoped for, and more. Intellisoft Systems really makes a difference, I would have never discovered the hidden features of the sotftware on my own. Thanks a lot Intellisoft !"
Joy Tan
Project Engineer

How To Register

To Register for Building Dynamic Excel Dashboards Masterclass, Simply fill the Registration Form, and reserve your seat today. You can call Kamini at (65) 6250-3575 or email to  to register for the upcoming class of Dashboard Masterclass.

We also offer Corporate Trainings for this Advanced Excel Pivots, Charts & Dashboards Workshop, if you have a group of 10 or more people. We can arrange to conduct the Dashboards  training at your office location.

Accelerate Your Career With the Most Effective & Practical Training.

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!

Found What You Were
Looking For?

Just Tell us...

We're Here To Help You!