For everyone in the University
The workshop covers two themes, Data Improvement and Data Migration, using genuine archive lists to explore the Excel features most valuable to archivists and others. The Data Cleaning theme covers Excel techniques for transforming and improving data to make it more consistent or to prepare it for migration into another system. Topics include conditional formulas, combining formulas, and removing duplicate records. The Data Migration theme includes discussions on how data migrations work and planning a data migration project, exploration of how to structure data in Excel to enable successful migration to specific archive catalogue systems. It includes practising some basic migration techniques.
Aimed primarily at archivists and those responsible for archive lists and catalogues who have previously attended "Spreadsheets: Archival lists and text"
Presentation with practical exercises
Computer and software are provided. There is limited space for any device you use for note-taking.
Either previous attendance at any level 1 Excel for Archivists Workshop [including Spreadsheets: Archival lists and text]. Or familiarity with and understanding of the following within Excel: data filters; sorting data using multiple criteria; data types (number formats); using simple functions and formulas.
Attendees will be given a full set of teaching material (including sample Excel workbooks) for additional practice at home.
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).
Use our online contact form
Email us at email@example.com
Use our room enquiry form
Email us on firstname.lastname@example.org
Use our instructional design enquiry form
Email us on email@example.com
Email us on firstname.lastname@example.org
The IT Learning Centre is part of Customer Services at IT Services