Top navigation bar Bottom navigation bar

Leisure courses

Access courses

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 ‘addins’.

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

This course runs on multiple occasions. Choose the date most appropriate for you.

Please call our Customer Contact team on 01234 291000 to book onto this course. Alternatively you can visit our Customer Contact team at our Cauldwell Street campus. View our opening hours.

LengthStart DateDay(s)Time(s)FeesLocationCourse Code
1 day 18/02/2020 Tue 9.30 am - 4.30 pm £180 Cauldwell Street F2259S1
1 day 15/05/2020 Fri 9.30 am - 4.30 pm £180 Cauldwell Street F2259S2


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