Excel Pivot Tables & Data Visualisation

Turn raw data into clear answers with Pivot Tables and Dashboards.

Duration

1 Day in-person training

Funding Availability

Funding is currently available to Tees Valley residents. See full funding requirements here.

Course Overview

This one-day course takes the mystery out of Excel’s most powerful tools. You’ll learn how to use Pivot Tables and Charts to quickly make sense of large amounts of information, and how to turn those insights into easy-to-read dashboards. By the end of the day, you’ll be confident in transforming numbers into clear stories that inform better decisions.

Excel Pivot Tables and Data Visualisation Banner

What To Expect

You’ll start with the foundations of Pivot Tables—how to build, format, and customise them so they give you the answers you need. From there, you’ll move on to interactive dashboards, learning how to add slicers, timelines, and clickable features that make your reports simple to use and professional to present. The training is practical, hands-on, and packed with examples you can take straight back to work.

What You Will Learn

  • How to create and customise Pivot Tables that highlight patterns and trends

  • Techniques to summarise, group, and compare data efficiently

  • How to use calculated fields for deeper analysis

  • Building dynamic dashboards with slicers, timelines, and hyperlinks

  • Adding interactive elements and automatic updates for professional reports

Who Should Take This Course

This course is designed for business owners, professionals, and jobseekers who want to get more from Excel but aren’t sure where to start. If you’ve ever stared at a spreadsheet wondering how to make sense of it—or wished your reports could look sharper and work harder—this course is for you. No advanced Excel knowledge required.

Our Next Course Starts:

Excel Pivot Tables & Data Visualisation – 18th September

EMS HQ 4 Egglston Court, Middlesbrough, England, United Kingdom

This one-day course takes the mystery out of Excel’s most powerful tools. You’ll learn how to use Pivot Tables and Charts to quickly make sense of large amounts of information, […]

Key Information

Course length: 1 sessions

Course availability: Click here to check our next starting date.

Cost: Fully funded for eligible residents

Funding requirements:

Tees Valley
Must be a Tees Valley resident. 19 years old and over.

Check Your Availability; Enquire Now

Funded by:
TV_Logo_Careers_RGB_Small_333
esfa-gov-uk