Spreadsheets

Basic Skills

• GCF LearnFree - Excel 2019, or pre-2016 versions  (Video) 
  • Excel Quick Tips
  • Formulas in Excel (Video)
• Linked In Learning - Free with Mason Login
  • Excel Tutorials
• DataCamp - Some free content, free for classrooms, monthly subscription otherwise
  • All Spreadsheet Courses
  • Free Lesson: Introduction to spreadsheets
  • Free Lesson: Data Analysis with Spreadsheets

More Useful Tutorials

• Google Sheets 101 (Zapier) - Good tips for spreadsheets

• Advanced Spreadsheet formulas (School of Data) 
  • Including Substitute and VLOOKUP
• Excel Is Fun! – YouTube videos for advanced users
  • Includes advanced topics and provides a link for the files used in videos.

To create a tidy data table you organize your data in:

• Observations - The rows
• Variables - The columns
• Values - The cells

Words to know:

• Unit of Observation - What each row has data about: sometimes a person, a place, or a company.

• Video: What is a dataset? (Elon University Poll)
• Data Organization in Spreadsheets for Ecologists (Data Carpentry)
• Spreadsheets for Historians (Spencer W. Roberts)

• See also the InfoGuide Intro to Data Analysis & Statistics