Microsoft Excel Pivot Tables Training Course - Beginners Training in Heathrow

Heathrow Beginners Microsoft Excel Pivot Tables Course Overview

Heathrow is a convenient location for teams who need accessible training close to major road, rail and airport links. This makes it a practical choice for Microsoft Excel Pivot Tables Training Course training.

The venue works well for PivotTables training because delegates have time to sort, summarise and analyse larger datasets without rushing through the practical exercises.

450 Bath Road
Longford
Heathrow
London UB7 0EB

The venue is close to Terminal 5 and is useful for organisations bringing delegates together from different areas. That makes it particularly useful for teams who want to turn raw spreadsheet data into clearer reports and more useful summaries.

If you are looking at alternatives, you can also explore our computer training courses in Heathrow.

Microsoft Excel Pivot Tables training for Heathrow teams

We can deliver Microsoft Excel Pivot Tables Beginners training for organisations in Heathrow and nearby areas such as Hayes, Hounslow, Uxbridge, Slough, Staines, Feltham and West London. Sessions can be run live online, at your premises, or at a local training venue where that suits your team better.

Access and venue details

The Heathrow venue on Bath Road is useful for teams travelling from different parts of London and the South East, especially where airport, road and rail access matter.

Local training use cases

Microsoft Excel Pivot Tables training in Heathrow is useful for teams who want skills they can apply quickly in real work. The venue works well for PivotTables training because delegates have time to sort, summarise and analyse larger datasets without rushing through the practical exercises. That makes it particularly useful for teams who want to turn raw spreadsheet data into clearer reports and more useful summaries. It suits users who need practical reporting skills they can apply quickly in day-to-day spreadsheet work.

Our instructor-led Microsoft Excel Pivot Tables Training Course Beginners training in Heathrow is designed for teams and individuals who want practical skills they can use straight away. The venue works well for PivotTables training because delegates have time to sort, summarise and analyse larger datasets without rushing through the practical exercises. That makes it particularly useful for teams who want to turn raw spreadsheet data into clearer reports and more useful summaries.

You need to get answers to questions and you need them quickly. How many people buy a certain product? In which month should we discount that product? If you've yet to embrace Pivot Tables, then you won't know how quickly you can get answers. Not only that but you can within minutes create effective summary tables and charts to be used in presentations and reports.

This course is designed specifically to look at Pivot Tables. You will learn how to correctly structure data, learning various Excel formulas and functions to enable you to do this. We will also take a look at the PowerPivot plugin in Excel, giving you an opportunity to use DAX with multiple data sources.

What You'll Learn

• Quickly summarise large sets of data using powerful Pivot Tables.
• Easily structure your data with Excel formulas like VLOOKUP, SUMIF, and INDEX MATCH.
• Create interactive visual reports with Pivot Charts, Slicers, and Timelines.
• Discover how PowerPivot and DAX calculations can connect multiple data sources.
• Gain practical skills to prepare insightful presentations and reports in minutes.

Course Duration: 1 Days

Course Prerequisites for your training in Heathrow

To make the most out of this course, you should have:

• Experience using Excel, including creating simple formulas.
• A basic understanding of managing worksheets, such as adding rows and columns.

Complete Course Outline

Pivot Table Formulas

• If Function
• SUMIF
• Flash Fill
• VLookup
• Index Match Function

Tables

• Creating Tables
• Using Functions with Tables
• Sorting Data in Tables
• Adding & Deleting Rows
• Converting a Table back to a Range

Pivot Tables

• Creating a Pivot Table from existing data in Excel
• Formatting Pivot Table Data
• Filtering and Sorting Data in Pivot Tables
• Dates and Pivot Tables
• Slicers and Timelines
• Connecting Pivot tables using Slicers
• Timelines
• Pivot Charts

PowerPivot

• Installing PowerPivot
• Adding a Table to PowerPivot

Performing Basic DAX calculations

• Inserting a column in PowerPivot
• Creating a calculated column
• Formatting data in columns
• Adding data from a text file
• Creating relationships
• Pivot Tables the PowerPivot way
• Date calculations in DAX
• Setting a Date Order
• Calculated Fields
• Year to Date function in DAX
• Viewing Sales from previous day
• Using a Calendar Table

Other Related Courses

Microsoft Excel 365 Training Course Beginners

Microsoft Excel 365 Training Course Intermediate

Microsoft Excel 365 Training Course Advanced

Microsoft Excel Power BI Training Course Beginners

Microsoft Word 365 Training Course Beginners

Microsoft PowerPoint 365 Training Course Beginners

Microsoft Office 365 Training Course Beginners

Microsoft Outlook 365 Training Course Beginners

Microsoft Power BI Training Course Beginners

Microsoft Power BI Training Course Intermediate

Power BI DAX Training Course Beginners

Browse all of our Excel Training Courses

Post-Course Resources

• Training notes & exercise files
• Online materials: video tutorials & shortcuts
• 3 months post training support

All you need to know about our Live Online Training.

Live Online Training

Helpful Links for Heathrow Learners

• View the main Microsoft Excel Pivot Tables Training Course Beginners course page
• Browse all computer training courses in Heathrow
• See this course in other training locations

Location FAQs for Heathrow

Excel training centres near Heathrow

If Heathrow is not the most convenient option, we can also arrange instructor-led Excel training at nearby Computer Tutoring training centres.