Home · Course Details

Learn how to create a dashboard in Excel to help you keep a visual track of important performance measures and targets in your spreadsheet models.

  • Duration: 90 minutes
  • Category: Excel
  • Platform: Adobe Connect
  • Level: Experienced
  • Pre-requisites: Basic familiarity with Excel formulas
  • Version: Suitable for 2010, 2013, 2016 and Office 365

  • Understand when to use a dashboard
  • Create a simple KPI dashboard
  • Edit and update the dashboard

Topics covered include:
  • Overview of Excel dashboards
  • Why use dashboards
  • Types of dashboards
  • Setting up the dashboard elements
  • Optimising a list
  • Building an analysis sheet
  • Extracting unique values
  • Building dynamic charts
  • Creating a chart
  • Modifying a chart
  • Testing the dashboard
  • Changing variable data and seeing the results

No pre/post work required

Name Date Time Location Cost

Not quite the content you’re looking for?

Need a course you can’t find content for on our website? We have quite possibly the largest catalogue of course content in Australia! Let us know what you’re looking for and we will customise something for you.