Excel Dashboards 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 Excel 2010, Excel 2013 or Excel 2016. Bring your own laptop, and learn the advanced tips and tricks from our Excel Guru.

Two Day Excel Dashboard Training in Singapore – 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.

SDF Funding is available to Singapore Companies (For company sponsored candidates). Call +65 6296-2995 for Details. SkillsFuture credits ready for Singaporeans.

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.

Dynamic Chart with Dropdown Control in Excel Dashboard Training

Logistics

This 2 Day Excel Pivots, Charts, Dashboards Masterclass will be held in Singapore.

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 should bring your Windows laptop with Excel per-loaded, to use in the Microsoft Excel master class. You can use Excel 2016 or Excel 2013 or Excel 2010

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
Excel-Dashboard to Compare Sales - Training Example4 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

Excel Sales Dashboard Demo for 1 day excel dashboard masterclass in Singapore

Click here to Register for the 2 Day Excel Dashboard MasterClass

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

Pre-Requisites

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

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.

Dynamic Chart with Dropdown Control in Excel Dashboard Training

Logistics

This 2 Day Excel Pivots, Charts, Dashboards Masterclass will be held in Singapore.

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

Go To Top

Target Audience

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

Apple Mac is not supported for this training.

You should bring your Windows laptop with Excel per-loaded, to use in the Microsoft Excel master class. You can use Excel 2016 or Excel 2013 or Excel 2010

Go To Top

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
Excel-Dashboard to Compare Sales - Training Example4 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

Excel Sales Dashboard Demo for 1 day excel dashboard masterclass in 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

Pre-Requisites

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

Go To Top

Microsoft Access 2010 Training at Intellisoft

Claim SDF & PIC Grant

Companies sponsoring their staff for training can claim from the Skills Development Fund.

Further, they can claim 40% of training fee or 400% Tax Rebate from IRAS With PIC scheme.

skills-future-training

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!

computer-training-participants

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!

How To Register

Register for the 2 Days of Dashboard training today by simply clicking on the chosen course date available at the top of this page.

Need Help?

  1. Call us at +65 6296-2995, 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 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.

Some of the companies that experienced our trainings

Get Creative With Illustrator
&
Accelerate Your Career

Free Tips, Tutorials & Training Grants Info

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