Learn Pivot Tables in 90 Minutes Part 1 Beginners Northampton

Northampton is a town with a rich history, including its famed shoe-making heritage.

Victory House
400 Pavilion Drive
Northampton Business Park
Northampton
NN4 7PA
United Kingdom

This centre is located in one of Northampton's premier business parks. The building occupies a prime position on Pavilion Drive, with rear office views overlooking a parkland Golf course. Perfect for your Beginners Learn Pivot Tables in 90 Minutes Part 1 training course.

Alternatively if you live in and around Northampton and wish to have your training on-site the we can provide all the equipment, included laptops and projector, required. All we ask is that you provide a little space for the trainer to set up.

Apart from Learn Pivot Tables in 90 Minutes Part 1 training courses we also conduct many other training courses in Northampton.

Course Prerequisites for your training in Northampton

Participants should have:

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

Knowledge of PivotTables is not required.

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.

Birmingham | Brentwood | Cambridge | Coventry | Guildford | Ipswich| Leicester | Luton | Milton Keynes | Northampton | Norwich | Oxford | Peterborough | London (Chiswick) | London (Hammersmith) | London (Heathrow) | London (Kensington) | Reading