Data Organization in Spreadsheets
Spreadsheet programs like Microsoft Excel or Apple's Numbers have powerful capabilities, but we often format our data in spreadsheets to be readable by a human, by merging cells for headings or putting long paragraphs of text into individual cells. Problems then arise when we want our tabular data - data stored in a table or spreadsheet - to be machine-readable, so that when we export our data to other programs for analysis, a computer can make sense of the data.
This workshop will address some of the common challenges to formatting data in spreadsheets and introduce some best practices for good data organization. Data wranglers of all skill levels are welcome to join!
This workshop is part of the local LoveDataWeek2019 celebration taking place February 11-15 in the UB Libraries. All are welcome!
Related LibGuide: Digital Scholarship @ UB by Rachel Starry
- Monday, February 11, 2019
- 1:00pm - 2:00pm
- 310 Silverman
- North Campus