Instructions
In our Pivot Table macro tutorial you will learn how to build pivot tables and perform various operations.
Add the Pivot Table macro:
- Hover over the table.
- Click the plus icon
at the top right corner of the table and select the 
option. - The table transforms into the pivot table.
70 %
Training table
Student's progress sheet
| Student | Group | Average rating | Admission to the exam |
|---|---|---|---|
| Diana Lyndon | Group 1 | 7 |  |
| Quin Rich | Group 3 | 5 | |
| Clint Pamila | Group 2 | 8 |  |
| Andy Asia | Group 1 | 4 | |
| Primula Linnie | Group 3 | 9 | |
| Leith Eireann | Group 2 | 6 | |
| Mary Saxon | Group 1 | 8 | |
| Robina Cletis | Group 3 | 5 | |
| Allyn Arlo | Group 1 | 10 | |
| Dave Bertie | Group 3 | 9 | |
| Matty Lowell | Group 2 | 10 | |
| Sheridan Anselm | Group 2 | 6 | |
| Kemp Emmet | Group 2 | 8 | |
| Sarah Milly | Group 1 | 9 | |
| Anna Kassy | Group 2 | 7 | |