Excel Dashboards 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.

October 22-23, 2018 (Jakarta, Indonesia) – To register, click HERE or email to corporate@intellisoft.com.sg

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.

Course Outline

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
  • Referencing & Ranges
  • Advanced Lookup
  • Advanced Formatting
3 Advanced Pivot Table Techniques in Excel 2010 or 2013
  • Percentage
  • Computed Columns
  • Grouping & Sorting
  • Top Views
  • Multiple data sources
  • Pivot Charts & VIsual Dashboarding Techniques
4 Advanced Power Charting Techniques
  • Thermometer Chart
  • Doughnut Chart
  • Pareto chart
  • Versatile management dashboards
5 Dashboard Macros
  • Simple & Complex Macros
  • Dynamic Dashboards using Macros
6 Creating Dynamic Dashboards with Excel 2010 / Excel 2013 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

Pre-Requisites

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

October 22-23, 2018 (Jakarta, Indonesia) – To register, click HERE or email to corporate@intellisoft.com.sg

Need Help?

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

CLICK TO REGISTER NOW!