In our Pivot Table macro tutorial you will learn how to build pivot tables and perform various operations.

Add the Pivot Table macro:

  1. Move the cursor over the table.
  2. See special icons appear on the top right of the table and click the button "Create a pivot table": 
  3. The table transforms into the pivot table. To show the source table again сlick the settings button  on the control panel, appeared on the top right of the table, and click "Show source table". You can hide it again the same way.
  4. Click the settings button  and "Save changes".

Student's progress sheet

StudentGroupAverage ratingAdmission to the exam
Diana LyndonGroup 17(minus)
Quin RichGroup 35(minus)
Clint PamilaGroup 28(plus)
Andy AsiaGroup 14(minus)
Primula LinnieGroup 39(plus)
Leith EireannGroup 26(minus)
Mary SaxonGroup 18(plus)
Robina CletisGroup 35(minus)
Allyn ArloGroup 110(plus)
Dave BertieGroup 39(plus)
Matty LowellGroup 210(plus)
Sheridan AnselmGroup 26(minus)
Kemp EmmetGroup 28(plus)
Sarah MillyGroup 19(plus)
Anna KassyGroup 27(minus)