Data tips: pivot tables in Excel
In this self-help video, you will learn:
- how to create a pivot table in Excel to summarise data;
- how to refresh a pivot table to take account of new or changed data.
This tutorial uses demonstration data from the fictitious project, The Letters of Bilbo Baggins: A Critical Digital Edition.
Methods shown here were tested in 2019 versions of Excel, on both Windows and Mac.
Links
