Excelling with Excel: Best Practices for Keeping Your Data Tidy
February 8 @ 3:00 pm - 5:00 pm
Registration is required. You will receive a confirmation once you are accepted into the workshop and a communication with the workshop materials and Zoom links.
This workshop is open to all members of the UC Davis community. DataLab Affiliates receive priority registration.
This workshop introduces learners to best practices for data entry and organization for data-driven projects. With interactive, hands-on examples we’ll practice using data validation tools including filters, restricted vocabularies, and flags in Microsoft Excel. These skills are also applicable to working in Google Sheets, LibreOffice, and other spreadsheet software. At the end of the workshop, learners should be able to identify the best practices for designing a spreadsheet and entering data, compare different data formats, and be able to use spreadsheet software for basic data validation.
This workshop is designed for learners who have basic familiarity with Microsoft Excel, Google Sheets, LibreOffice or similar spreadsheet programs. No coding experience is required. All participants will need a computer with Microsoft Excel 2016 or newer, and the latest version of Zoom.
For more information on how to get access to Microsoft 365 Suite as a UC Davis student, see here: https://office.ucdavis.edu/
Dr. Pamela Reynolds is DataLab’s Associate Director.
Victoria Farrar is a Ph.D. student in Animal Behavior Graduate Group at UC Davis and a Professors for the Future (PFTF) fellow. This workshop is part of her PFTF service project on “Data management training for transparent, reproducible science.”
This workshop is being offered during “UC Love Data Week,” a week-long offering of presentations and workshops focused on data access, management, security, sharing, and preservation. All members of the University of California community are welcome to attend. Make sure to register with your UC-campus email. See the UC Love Data Week website for the full lineup of cross-UC workshops and events.