Skip to main content
Get a Quote
Course Enquiry
Contact Us
Excel Dashboards and Power Pivot

RELATED COURSES


TRAINERS FOR COURSE


Details

Excel is a great tool for creating and analysing dashboards.

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

Delivery Methods

Delivery Method Duration Price (excl. VAT)
Fulltime 1 Day R 2,749.00
Webinar 1 Day R 2,049.00

Discounts Available

Save up to 10% by booking and paying 10 business days before the course.

Brochure:

Download Brochure


Information may change without notice.

Pre-Requisites

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 End Date Branch Status  
Tue 23 Mar 2021 Tue 23 Mar 2021 Not Applicable Scheduled

Book Webinar