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.
- What is a formula? What is a function?
- Relative and absolute cell references
- Conditional formulas
- Combining formulas
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. 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 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
Will be of most benefit to those with an elementary or intermediate knowledge of Excel. No prior knowledge of using formulas is required
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 email@example.com
Members of the University of Oxford should book through our online course booking system (CoSy).