Excel Dashboards

Course details

In This course you will learn how to create dash boards using Excel

Excel is a great tool for creating and analysing dashboards.

Pre-Requisites

Excel Intermediate

Course Outline

• Introduction
  • Dashboard Do's and Don't's
  • Data Layout Creating Dynamic Dashboards
  • Merging and Consolidating Data Using Shapes to make Charts more attractive
  • Using Alerts to draw attention to dashboards
  • Module 6 - More Dashboarding
    • Creating KPI Dashboards
    • Project Management
    • Dashboards Publishing Excel Dashboards to the Web
• Working with your Data
  • Understanding Data Quality issues
  • Gathering data from different sources
  • Linking Data
  • Merging and Consolidating Data
  • Excel Hints and Tips when working with data
• Analysing Data
  • Using the dashboards with Excel Pivot Tables
  • Using external data sources such as The Web
  • Dashboarding with Microsoft Access information
• Build Your Own Dashboard
  • This last session will be used to build some relevant Dashboards. Delegates are encouraged to bring examples of the dashboarding they would like to create during the training.