Additional information
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.
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.