Top navigation bar Bottom navigation bar

Leisure courses

Access courses

Part-time course already started?

We are currently reviewing our courses to determine how we can adapt them during the pandemic to ensure we provide an outstanding student experience. Register you interest to be the first to apply for this course in July!

» 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

We are currently reviewing our courses to determine how we can adapt them during the pandemic to ensure we provide an outstanding student experience. Our course information is coming soon; register you interest to be the first to apply for this course in July!

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.

Accessibility
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