Skip to main content
Get a Quote
Course Enquiry
Contact Us


Excel is a great tool for creating and analysing dashboards.

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


$249.90 If you are currently resident in South Africa you will need to pay VAT at 14%.


1 Day


Download Brochure

Prices have changed from 1 March 2018. Information may change without notice.

Delivery Method

Instructor Led classroom based training. Scheduled classes are normally held in Woodmead - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Contact hours are between 9am to 4pm.


Excel Intermediate

Course Outline / Curriculum

  • 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.



Schedule Dates and Booking

To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.

Start Date Duration  
Thu 19 Apr 2018 1 Day Book Now
Thu 5 Jul 2018 1 Day Book Now
Thu 2 Aug 2018 1 Day Book Now
Thu 4 Oct 2018 1 Day Book Now
Thu 1 Nov 2018 1 Day Book Now
Thu 6 Dec 2018 1 Day Book Now