Get a Quote
Course Enquiry
Contact US
Leading Edge Training

Excel Dashboards Course Details


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

Audience:

Pre-Requisites:

Excel Intermediate

Duration:

1 Day

Price:

$159.80 If you are currently resident in South Africa you will need to pay VAT at 14%.   *Discount available

PC Hire:

$22   *Bring a PC

Note: information may change without notice.

Download Brochure:

Download Brochure

About Excel Dashboards

Excel is a great tool for creating and analysing dashboards.

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.

 

 

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. Light finger meals are supplied for part time courses.

Scheduled Dates


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

Start DateDuration 
Wed 12 Apr 20171 daysBook Here
Wed 14 Jun 20171 daysBook Here
Wed 16 Aug 20171 daysBook Here
Wed 11 Oct 20171 daysBook Here
Wed 13 Dec 20171 daysBook Here

Provisional Dates

These dates have not yet been confirmed. If you are interested in attending please click here to enquire.

Start DateDuration
Mon 27 Feb 20171 days

Gautrain

For clients who want to enjoy the convenience of public transport, consider the Gautrain. Our training premises in Woodmead is located near the Morning Glenn Mall Bus Stop. If organised by prior arrangement we will collect delegates from the afore mentioned bus stop at no extra charge. Direction to the bus stop are as follows:

Take the Gautrain to the Sandton station.
Take the S2 Bus to Morning Glenn Mall.
We will collect you at 8:30 directly from the bus stop.

Accommodation

Please submit a query on the course page and we will be able to advise you on hotels and guest houses close to the training facility.