Computer Tutoring Logo

Flexible Training Options

Choose a single focused 90-minute session, combine several sessions into a short course, or ask us about ongoing training support for your team.
  • Focused 90-minute sessions for specific skills
  • Grouped sessions to build a complete learning path
  • Ongoing support options for teams who need regular help
Tell us what you need

Tell Me More






First NumberPlusSecond Number  = 

Please enter the answer to prove that you are human and not a machine.

Excel training feedback

FMG Consulting

"Very engaging & helpful, Simon my course teacher was great!"

Bedfordshire OPCC

"Simon was a fantastic training facilitator and made the session fun and easy to engage with. When one of my colleagues was concerned about how the skills learnt would transfer to her role, Simon took the time to design an activity (on the spot) that would apply to her and her role. Thank you for the brilliant session Simon - we can't wait to put our new skills to the test!"

BUUK Infrastructure

" I found the training excellent, I thought Simon's knowledge was great and he helped with some slightly off topic excel queries - I learnt so much from this workshop! I have undertaken this course before and the learning did not stick, but Simon's story telling and contextulisation has made it much more memorable."

GKN Aerospace

"Great, Gary was amazing and taught me loads "

Learn Excel Pivot Tables in 90 Minutes Part 1 - Beginners Training in Chiswick

Chiswick Beginners Learn Excel Pivot Tables in 90 Minutes Part 1 Overview

Learn Excel Pivot Tables in 90 Minutes Part 1 Beginners training in Chiswick

Chiswick provides a convenient West London base for practical, instructor-led Learn Excel Pivot Tables in 90 Minutes Part 1 training. It is a good option for teams who want a professional venue without travelling into the centre of London.

The venue works particularly well for spreadsheet-based training where delegates need time to practise formulas, reporting and data analysis without day-to-day interruptions.

Building 3
Chiswick Park
566 Chiswick High Road
Chiswick
London W4 5YA

The Chiswick venue is in a modern business park with strong transport links and a professional learning environment. This is especially useful for teams who want practical, hands-on training that improves confidence with everyday spreadsheet tasks.

If this course is not quite right, you can also explore our computer training courses in Chiswick.


Learn Excel Pivot Tables in 90 Minutes Part 1 training for Chiswick teams

We can deliver Learn Excel Pivot Tables in 90 Minutes Part 1 Beginners training for organisations in Chiswick and nearby areas such as Hammersmith, Acton, Ealing, Brentford, Richmond 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 Chiswick Park venue on Chiswick High Road is useful for West London teams who want a professional training space without travelling into the centre of London.

Local training use cases

Learn Excel Pivot Tables in 90 Minutes Part 1 training in Chiswick is useful for teams who want skills they can apply quickly in real work. The venue works particularly well for spreadsheet-based training where delegates need time to practise formulas, reporting and data analysis without day-to-day interruptions. This is especially useful for teams who want practical, hands-on training that improves confidence with everyday spreadsheet tasks. It suits delegates who need to use spreadsheets more effectively in real working situations.

Chiswick is a strong setting for Learn Excel Pivot Tables in 90 Minutes Part 1 Beginners training. The venue works particularly well for spreadsheet-based training where delegates need time to practise formulas, reporting and data analysis without day-to-day interruptions. It suits delegates who need to use spreadsheets more effectively in real working situations.

This course introduces the power of PivotTables in Microsoft Excel and shows how they can quickly turn raw data into meaningful insights. Participants will learn how to create PivotTables, analyse trends, group information, and customise reports so that large data sets become easier to understand and present.

By the end of the session, you will feel confident exploring data, summarising results, and presenting clear analytical views using PivotTables and PivotCharts.

Compare Pivot Table Training Options

90-Minute Pivot Table Course (Essentials) Full-Day Pivot Table Course (Advanced & Comprehensive)
Best for Beginners or users who need a quick, practical overview of PivotTables. Users who want to master PivotTables and work confidently with more complex datasets.
Main focus Focuses purely on core PivotTable skills. Includes PivotTables plus a wider range of advanced Excel analysis techniques.
Coverage Step-by-step introduction from data preparation to building, analysing and visualising PivotTables. Covers everything from the basics through to advanced reporting, modelling and analytical techniques.
Tools covered Sorting, grouping, filtering, slicers and PivotCharts. PivotTables, formulas such as IF, SUMIF, VLOOKUP and INDEX MATCH, plus Excel Tables, PowerPivot and DAX.
Advanced features Keeps the focus on practical everyday reporting and essential PivotTable use cases. Teaches data modelling, relationships, advanced calculations and deeper analytics.
Ideal choice if... You want a concise session that gets you using PivotTables quickly and confidently. You want comprehensive training that goes beyond PivotTables into advanced Excel analysis.

Need a more comprehensive Pivot Table course instead? View the Full-Day Pivot Table Course

Course Duration: 90 Minutes

Course Prerequisites for your training in Chiswick

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.

Location FAQs for Chiswick

Where can this training take place in Chiswick?

We can deliver this Excel training at your premises in or around Chiswick, live online, or at a suitable local training venue if you would prefer an external location.

Can you come to our office in Chiswick?

Yes. We regularly deliver on-site training for teams in Chiswick and can usually tailor the session to your team, your documents and the way you work.

Computer Tutoring Training Centres

We can also arrange instructor-led training from these Computer Tutoring training centres.