Excel Dashboard Training

Course Start Date

Microsoft Excel Dashboards MasterClass

Do you invest your time to update your Excel reports Daily/Weekly/Monthly?

Learn how to create amazing interactive Excel Dashboards and refresh the charts & records on dashboard by just one click.
It will save your time, improve your presentation, accuracy and off-course impress your boss.

Dashboard help you to provide insight, analysis & alerts. You can use the Excel Dashboard in all type of stream, may be Call Center, MIS, Project Management, Retail Management, Financial Forecasting, Digital Marketing reports and many more.

Duration: 3 Days

Venue: 10 Anson Road, 26-08A International Plaza, Singapore 079903

Target Audience:

  • This course is not suitable for Absolute Beginners in MS Excel.
  • Apple Mac is not supported for this training.
  • You can use any version of Excel(2010, 2013, 2016) for this training.

Click Here to Register

What you will learn?

This extensive Excel Dashboard Training Course will help you to create an Excel Dashboard by using easy steps & techniques that you can apply in Excel
to develop an extra ordinary standout dashboards.
We will start learning it from the beginning.

  • Fast & Easy update, your data can be updated themselves by pulling in data direct from your external database,
    Microsoft Access, the web etc. at the click of a button if you set them up right.
  • Easy to read and interpret; plus I share with you a heat map of your page that shows you where your most important data should go
    and where will get the least attention.
  • Exactly what the reader wants; We will train you the 5 key questions to ask and to who
    in the planning stage of your report so you get it right first time.
  • Choose the right chart for your data; We will do hands-on training with over 20 charts and show you which
    type of chart will best display your data.
  • Just take a look at the two charts below. Both plot the same data but one is much easier to make comparisons in the data than the other.
    You be the judge.
  • 100 satisfactory training record.

Master Excel Dashboard Training Course Outlines:

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

Hands-on Dashboard Creation in the Workshop

  • Build a Sales Dashboard
  • Generate a Services Dashboard
  • Creating a HR Dashboard

Our Clients