Data Organization in Spreadsheets

beginner


Overview

Do you collect or store data in spreadsheets? Do you work with others who do? Then this workshop is for you. We’ll discuss best practices for formatting and organizing data in spreadsheets to avoid errors, making data files ready for import into statistical software, improving consistency, and saving your colleagues and your future self headaches and trouble. We’ll look at examples of spreadsheets to discuss ways they could create problems for researchers and discover ways to improve them.

Things you’ll learn in this workshop

  • How to structure data in a spreadsheet for easier analysis and processing
  • Common sources of errors in spreadsheets
  • The problem with dates
  • Formatting is not data!
  • Strategies for documenting your data

Prerequisites

  • You’ve used a spreadsheet program before

Required Software

Bring your laptop. No specific software required.