Designing Reproducible Spreadsheets

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.

Learning Objectives

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

Instructor

Ariel Deardorff, Data Services Librarian, UCSF Library

Dial-In Information

Register for Zoom link

Wednesday, March 31 at 11:00am to 12:00pm

Virtual Event
Event Type

Professional Development, Research & Academia

Audience

Students, Postdocs, Faculty, Staff

Location

Online

Tags

Excel, Data Science Initiative, reproducibility, spreadsheet, data organization

Website

https://calendars.library.ucsf.edu/ev...

Department/Group
UCSF Library
Contact Info

ariel.deardorff@ucsf.edu

Subscribe

You're not going yet!

This event requires registration.