15 JUNE (10:00-11:30 hrs)
This course is a demonstration of two key techniques applicable to using MS Excel with text, especially in the context of creating and using archival lists. It will be an online demonstration with the opportunity to ask questions. The techniques discussed will be demonstrated using the specially prepared Excel workbooks featured in the standard Excel for Archivists workshops, so the session can serve as a ‘taster’ for the conventional course when it resumes. There are also some additional exercises for further practice following the session.
- Using filters to view rows
- Sorting rows, including sortingusing multiple criterias
Archivists and others working in archival institutions who use Excel to list and catalogue archives
Online teacher-led (via Teams)
What You Will Need
You will need to provide your own computer with a browser and the Teams desktop app installed, as well as MS Excel. You need to be online with a reliable internet connection. More information will be emailed to you when you book. Demonstrations will use Excel 2016 but any version of Excel from 2007 onwards is suitable.
- Understand and apply fitering techniques when using Excel with text in an archive context
Will be of most benefit to those with some experience of using Excel, especially with text.
If you are not a member of the University of Oxford, the cost of each session is £40 To book this workshop, please complete this form and email to firstname.lastname@example.org
Members of the University of Oxford should book through our online course booking system (CoSy).