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 testimonials from Cambridge

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!"

Industrial Inkjet LTD

"Very good Excel for beginners training learnt a lot thankyou. very friendly and easy to understand tutor. would definitely recommend and do another course"

Ground Control Ltd

"Very clear and easy to follow, brought the training to life with specific examples and tried to tailor the training to our needs and our needs of the business."

Foster Denovo

Training session was great. Despite it being an all day session, it did not feel too tiring or boring. I learned a lot and will now be looking at all my spreadsheets to see how to apply it.

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

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

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

Cambridge is a strong location for business-focused software training, with a long history of innovation, research and professional development. We regularly deliver Learn Excel Pivot Tables in 90 Minutes Part 1 training for organisations in and around the area.

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.

Whether you want us to come to your premises or use a local venue, we can usually provide the equipment needed, including laptops and a projector where required. This is especially useful for teams who want practical, hands-on training that improves confidence with everyday spreadsheet tasks.

We also run a wider range of computer training courses in Cambridge if you are reviewing other options.


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

We can deliver Learn Excel Pivot Tables in 90 Minutes Part 1 Beginners training for organisations in Cambridge and nearby areas such as Ely, Newmarket, Huntingdon, St Neots, Royston and Saffron Walden. 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

Cambridge training can be delivered at your workplace or arranged at a suitable local venue. Where needed, we can usually provide laptops, a projector and course materials so the session stays practical and easy to run.

Local training use cases

Learn Excel Pivot Tables in 90 Minutes Part 1 training in Cambridge 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.

If you need Excel training in Cambridge at beginners level, this page gives you a location-specific overview of the course. 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.

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 Cambridge

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 Cambridge

Where can this training take place in Cambridge?

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

Can you come to our office in Cambridge?

Yes. We regularly deliver on-site training for teams in Cambridge 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.