Top navigation bar Bottom navigation bar

Leisure courses

Access courses

Part-time course already started?

Our upcoming 2020-21 part-time courses will be out in May. Get alerted when they're released by selecting your campus of choice below and filling out the form...

» I'm interested in courses at Bedford College

» I'm interested in courses at Shuttleworth College

Microsoft Excel: PivotTables and Dashboards

  • A

An Excel dashboard is a visual dynamic interface showing a summary of consolidated data on a single screen. It simplifies complex data to provide you with the information you need at a glance. On this course you will learn how to create Dashboards using the existing tools in Excel. You don’t need any knowledge of Visual Basic macros and there is no need for extra ‘add-ins’.

Entry requirements

To begin this course some experience of using Microsoft Excel, Tables and basic PivotTables would be advantageous.

Course content

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding in order to increase their knowledge and productivity.

Topics covered will include:

  • Tables
  • Conditional Formatting
  • Creating a PivotTable
  • Creating a PivotChart
  • Map Charts
  • PivotTable Slicers
  • PivotTable Formulas
  • Sparklines
  • Formatting the Dashboard
  • Protecting and Hiding Data

Assessment methods

There will be no assessments or exams for this course; at the end you will receive a Bedford College course completion certificate.

Additional information

Course Information & How to Apply

In light of the current coronavirus outbreak this course has unfortunately been postponed. Information regarding our 2020-21 part-time courses will be out in May; please complete our enquiry form and we will alert you when they are released.

Register your interest

LengthStart DateDay(s)Time(s)FeesLocationCourse Code
1 day 15/05/2020 Fri 9.30 am - 4.30 pm £180 Cauldwell Street F2259S2 Course in progress


Additional Learning Support
If you have a specific learning difficulty or disability, are deaf or hearing impaired, our Additional Learning Support team are on hand to give you assistance whenever you need it.  Find out more.

Autism & Asperger’s Syndrome Support
At Bedford College, we are committed to developing the provision for students on the autistic spectrum, including Asperger’s Syndrome.  Find out more.

We have access arrangements in place to help students with disabilities or any other particular needs. Call us on 01234 291000 for more information.

Additional formats
Course information sheets are also available in large print and audio formats. Call us on
01234 291000 to order your copy.
YouTube Instagram LinkedIn Moodle Higher Education Moodle Have Your Say