1. Home
  2. Training Library
  3. Additional Resource Videos

Quick Pivot Tables

Developed with
QA
Start course
Overview
Difficulty
Beginner
Duration
33m
Students
231
Ratings
4.7/5
starstarstarstarstar-half
Description

Additional information

Transcript

- [Narrator] To insert quick pivot tables, start by clicking the Insert tab. Just beneath the word is the phrase Recommended Pivot Table. Select this button and you'll then see a series of automatically generated pivot table ideas. I can click onto each of these as I go to see which one suits the data that I want to see best. In this case, I'm going to do the sum of salary by location and pension. Click OK and this builds me an automatic pivot table without any effort at all.

About the Author
Avatar
QA
Training Provider
Students
9798
Labs
31
Courses
133
Learning Paths
33

QA: A world-leading tech and digital skills organisation

We help many of the world’s leading companies to build their tech and digital capabilities via our range of world class training courses, reskilling bootcamps, work-based learning programmes and Apprenticeships. We also create bespoke solutions, blending elements to meet specific client needs.