Data and Donuts Workshop @PCL: Organizing Data in Spreadsheets

Spreadsheets can be a powerful tool for entering, analyzing, and managing data, but it’s crucial to ensure that they are well-formatted from the outset, before you even start entering data. This 1.5 hour hands-on* workshop will teach you how to think about data organization to increase your efficiency and help ensure that your data are reusable. We will discuss good data entry practices, how to avoid common formatting mistakes, basic quality control, data manipulation, and exporting. *Laptops are available for check-out. Feel free to use your own if you prefer, with the spreadsheet software of your choice (e.g., Open Office or Microsoft Exel) pre-installed.

Taught by Jessica Trelogan, Research Data Services, UT Libraries

PCL Learning Lab 1