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

Base Cost


Calculate Discount

  I will bring my own PC (less $25.00)
  I will book and pay 10 business days before the course (less $27.49)


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


1 Day


Download Brochure


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

PC Hire:

Or bring your own PC


1 Day


Download Brochure

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
    • 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.
  • Dax Basics
    • Creating Calculated Columns and Calculated Measures
    • Creating Basic formulas and functions using Dax



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 Branch Duration  
Thu 12 Dec 2019 Woodmead 1 Day