Spreadsheets: Excel for Archivists - Introduction to using formulas in Excel

Dates:

16 JUNE (10:00-11:30 hrs)

This course is a demonstration of what formulas are and how to use them, especially in the context of using and improving existing archival data. The session will begin with the absolute basics, and will also include more advanced techniques in order to demonstrate the potential power of formulas, given practice. 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:

  • What is a formula? What is a function?
  • Relative and absolute cell references
  • Conditional formulas
  • Combining formulas

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. 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 the concept of functions and formulas, especially in the context of using and improving archival data in Excel
  • Understand the concepts of relative and absolute cell references and conditional formulas
  • Create and use simple formulas acting on textual data in Excel

Pre-requisites

Will be of most benefit to those with an elementary or intermediate knowledge of Excel. No prior knowledge of using formulas is required

Booking

If you are not a member of the University of Oxford, the cost of each session is £40. To book on this workshop, please complete the booking 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