Spreadsheets: Excel for Archivists - Two key techniques for working with text

Dates:

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.

Topics include:

  • Using filters to view rows
  • Sorting rows, including sorting and using multiple criterias 

Intended Audience

Archivists and others working in archival institutions who use Excel to list and catalogue archives

Format

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.

Objectives

  • Understand and apply fitering techniques when using Excel with text in an archive context

Pre-Requisites

Will be of most benefit to those with some experience of using Excel, especially with text.

Booking

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 courses@it.ox.ac.uk

Members of the University of Oxford should book through our online course booking system (CoSy).

Course enquiries


Use our online contact form
Email us at courses@it.ox.ac.uk

 

Thames Suite enquiries


Use our room enquiry form
Email us on thames-suite@it.ox.ac.uk

 

Instructional design enquiries


Use our instructional design enquiry form
Email us on instructional.design@it.ox.ac.uk

 

CoSy enquiries


Email us on cosy-support@it.ox.ac.uk

 

IT Services


The IT Learning Centre is part of Customer Services at IT Services