Custom Course Pricing

The price for this course depends on factors such as the number of attendees and the training delivery. Please complete the Tell Me More form below and we will provide you with a quote.

Tell Me More

Testimonials

HOPPE UK

"Fantastic really informative and interesting" "Excellent very enjoyable really good presenter"

St Johns Packaging (UK) LTD

"The training was highly beneficial and significantly enhanced my Excel skills. Simon was an engaging and approachable instructor, it was an absolute pleasure to learn from him."

Hahnemuehle

"Really good and really informative. Would recommend to a company needing excel training."

Ottolenghi Ltd

"I found the basic excel training useful and excel cheatsheet is very handy. I learnt some new things from the exercise and looking forward to the next session. "

Locations outside Coventry

Learn Pivot Tables in 90 Minutes Part 1 Beginners Coventry

Coventry Beginners Learn Pivot Tables in 90 Minutes Part 1 Overview

Beginners Excel training course in Coventry

In in the middle of the West Midlands we are now delivering training courses in the conveniently located city of Coventry. Computer Tutoring has already provided Excel training for many companies in the surrounding areas so delivering Learn Pivot Tables in 90 Minutes Part 1 training in Coventry is a natural step.

We can come to you, or you can come to us for your Beginners Learn Pivot Tables in 90 Minutes Part 1 training course.

Explore Coventry, a city steeped in history with its iconic cathedral and vibrant arts scene.

Other training courses in Coventry.

Course Duration: 90 Day

Course Prerequisites for your training in Coventry

Participants should have:

A basic knowledge of Microsoft Excel
Experience entering data and working with worksheets

Knowledge of PivotTables is not required.

Complete Course Outline

Introduction to PivotTables

Understanding what a PivotTable is and why it is useful
What type of data works best with PivotTables
Preparing data so it can be analysed effectively
Exploring the PivotTable interface

Creating Your First PivotTable

Creating a PivotTable step-by-step
Placing PivotTables on a new worksheet
Understanding rows, columns, values and filters
Formatting and adjusting PivotTable values

Analysing Sales Data

Building a PivotTable to analyse sales by salesperson
Summarising results using totals and averages
Renaming and formatting PivotTable headings
Applying built-in PivotTable styles

Sorting and Grouping Data

Sorting PivotTable data by totals
Sorting information within groups
Grouping dates into years, quarters and months
Understanding how sorting works in PivotTables

Updating and Managing PivotTables

Refreshing PivotTables when data changes
Expanding the source data dynamically
Changing the layout and structure of PivotTables

Working with Subtotals and Layout

Using subtotals to summarise grouped data
Creating clearer report layouts
Building cross-reference PivotTables

Visualising Data

Creating PivotCharts from PivotTables
Using slicers to filter reports visually
Building interactive PivotTable reports

This course is designed for Excel users who work with lists of data and want to summarise and analyse that information more effectively.

During the session, you will learn how PivotTables organise and summarise data, how to build them step-by-step, and how to customise them to answer real business questions. The course also introduces sorting, grouping, calculated views, and visual tools such as PivotCharts and slicers.

Practical examples and exercises will help you understand how PivotTables can simplify reporting and reveal patterns that would otherwise be difficult to spot.