Skip to main content
University of Texas University of Texas Libraries

Data & Donuts

Working with Data in Spreadsheets

Working with Data in Spreadsheets

Jessica Trelogan, Research Data Services, UT Libraries

February 9, 2018

3-4:30pm (hands on*)

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 and data manipulation, and exporting data.

*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.

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial 2.0 Generic License.