Developing Dashboards with Microsoft Excel

Presenting business intelligence with clarity

Who is it for?

For those who need to present data in a visually effective and meaningful way to enable understanding and action to be taken. 

What will I learn?
  • Preparing and analysing data for a dashboard
  • Building interactive Excel dashboards
  • Using Excel’s data visualisation tools for KPI reporting

Course Details

  • Location: Portsmouth
  • Duration: 1 Day
  • Member: £290
  • Non-Member: £342

All fees subject to VAT

Book this course »
Next steps



Course Overview
  • Introduction to dashboard design 
  • Advanced charting techniques
  • Enhancing pivot tables and pivot charts
  • Building a power pivot data model with related data
  • Using power view to create reports
  • Using DAX calculations to analyse the data
  • Using hierarchies to enable drilling down through the data

Additional Information
Please note

Those attending should have Intermediate to Advanced skills or relevant experience in Excel and pivot tables.


Course Dates
Course commences;

28 November 2017
23 May 2018

Company Sponsored Option

This course is also available as a company sponsored option which is for your delegates only, this is a flexible solution and can be tailored to reflect your business needs, delivered on a date, time and place to suit you - please contact us.


Group Discounts

Take advantage of these discounts when booking this course;

5% off for 2-3 people
8% off for 4-5 people
12% off for 6 or more people

« All Databases, Reporting and Programming courses


Our Courses and Services