Spreadsheets: Archival lists and text

December 2020

This one-day workshop will use genuine archive lists to explore the features available in Excel which are useful to archivists and others. It aims to increase participants' confidence in using Excel for listing and cataloguing archives, including box listing and preparing catalogues for export into Calm or other systems, although we will not cover the actual import/export of data. There will be plenty of opportunity for hands-on practice and sharing experiences of using Excel for listing and cataloguing. See objectives below for more details of actual content.

Intended Audience

This course is primarily aimed at archivists and those with cataloguing responsibilities.

Format

Presentation with practical exercises

Taught Using

Windows; MS Excel

What You Will Need

Computer and software are provided. There is limited space for any device you use for note-taking.

Objectives

  • Become familiar with Excel
  • Work with text
  • Understand data entry techniques
  • Explore functions and formulas
  • Use filtering and sorting

Pre-Requisites

We will assume that you know how to find your way around a spreadsheet and edit data.

Booking

If you are not a member of the University of Oxford, the cost of each session is £165 (including refreshments and lunch). Discounts are available for members of other academic institutions. To book on this workshop, please contact us.

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

Call to action


Use this WYSIWYG to display the login button for a system, or a button to register for an event

UPPERCASE

Contact us


Display contact details for your department or team here

Popular links