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

Quick Pivot Tables

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

Additional information

Transcript

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
Students
23207
Labs
113
Courses
883
Learning Paths
43

A world-leading tech and digital skills organization, 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 programs, and apprenticeships. We also create bespoke solutions, blending elements to meet specific client needs.