Research Guides: DPDS Social Sciences Workshop Resources: Intro to Data Organization

Intro to Data Organization

Organizing your data tables according to tidy data principles will make them easier for you and others to use for analysis. Spreadsheets are used to create data tables for publications, generating summary statistics, and creating figures.

Introduction to Data Organization Video Demonstration
Watch the workshop zoom video demonstration on the value of utilizing spreadsheets for data collection and analysis. Video length is 5 minutes 25 seconds.
Social Science Workshop Registration
Register for the Social Science Workshop to gain hands-on experience and practice section objectives alongside a certified instructor.

Recommended Guides

Introduction to Data Organization Guide
Workshop guide provided by Data Carpentry that explains the limitations of spreadsheets and the uses of spreadsheets for data entry and data cleaning.
Microsoft Support: Excel help & learning
Explore Excel topics like collaborating in Excel, using formulas and functions, formatting data, importing and analyzing data, troubleshooting, and more.

Online Tutorials

Microsoft Support: Excel video training
Explore Excel video tutorials on various topics like working with rows and columns, cells, formatting, formulas and functions, tables, charts, PivotTables, sharing capabilities, linked data types and more.

Recommended Books

Microsoft Excel Step by Step (Office 2021 and Microsoft 365) by Joan Lambert; Curtis Frye
ISBN: 9780137564279
Publication Date: 2021-12-16
Learn how to use Microsoft Excel in this step-by-step guidebook. Quickly set up workbooks, enter data and format it for effective visual impact, perform calculations, find and correct errors, and more.
Head First Excel by Michael Milton
ISBN: 9781449370091
Publication Date: 2010-03-11
Explains in-depth how to incorporate Excel into every aspect of your workflow.