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

Quick Pivot Tables

Developed with
QA
Start course
Overview
Difficulty
Beginner
Duration
33m
Students
216
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
7308
Labs
20
Courses
27
Learning Paths
33

QA is the UK's biggest training provider of virtual and online classes in technology, project management and leadership.