<p dir="ltr">In this self-help video, you will learn:</p><ul><li>how to create a pivot table in Excel to summarise data;</li><li>how to refresh a pivot table to take account of new or changed data.</li></ul><p dir="ltr">This tutorial uses demonstration data from the fictitious project, <i>The Letters of Bilbo Baggins: A Critical Digital Edition</i>.</p><p dir="ltr">Methods shown here were tested in 2019 versions of Excel, on both Windows and Mac.</p><p dir="ltr"><b>Links</b></p><ul><li><a href="https://www.sds.ox.ac.uk/" rel="noreferrer" target="_blank">The Sustainable Digital Scholarship service</a></li><li><a href="https://www.it.ox.ac.uk/it-training" rel="noreferrer" target="_blank">Training courses at IT Services</a></li></ul><p></p>
