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.
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 KingdomThis 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.