Designing Reproducible Spreadsheets Online
Have ever been frustrated by an Excel spreadsheet with missing data or struggled to import data from a spreadsheet to another data analysis tool? This workshop covers best practices for structuring, naming, and organizing spreadsheets in Excel, Google Sheets, and LibreOffice. We will discuss common pitfalls, and practice redesigning a messy spreadsheet. Whether you are new to working with spreadsheets, or consider yourself an Excel master, you will take away practical tips for designing spreadsheets that can enable any kind of data-driven project.
By the end of the this workshop attendees will be able to:
- Describe best practices for reproducible data organization in spreadsheets
- Design tidy spreadsheets that can be used in a wide variety of data analysis software
Ariel Deardorff, Data Services Librarian, UCSF Library
Related LibGuide: Reproducible Data Management by Ariel Deardorff
- Wednesday, Mar 31 2021
- 11:00am - 12:00pm
- Time Zone:
- Pacific Time - US & Canada (change)
- This is an online event. Event URL will be sent via registration email.