| DAL4 A1.2 |
- [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.
QA is the UK's biggest training provider of virtual and online classes in technology, project management and leadership.