Google Sheets

Course Description

Google Sheets is a free, web-based spreadsheet application that is part of the Google Drive office suite, along with Google Docs and Google Slides. Google Sheets has a clean, human-friendly design that encourages collaboration and facilitates insight into your data. In this introductory course, you'll learn how you can use Google Sheets to enter, organize, refine, analyze, and visualize your data to present your story.

Course Information

  • Introductory level
  • 41 streaming video tutorials
  • 3 hours 6 minutes of instruction
  • Created by Barton Poulson
  • Published 04 June 2018 
  • Videos are shared freely with a Creative Commons Attribution license
  • Download the free course files here

Note. To navigate the videos, click on the menu icon (☰) in the top left of the video.

Table of Contents

GETTING STARTED

  • Welcome {4:54}
  • Pictures first {5:30}
  • Anatomy of a spreadsheet {5:07}
  • Data types {7:16}
  • Formatting cells {6:59}
  • Tidy data {6:40}
  • Sharing files {2:58}
  • Sharing folders {2:26}

PREPARING DATA

  • Entering data {4:31}
  • Importing data {2:57}
  • Copying & pasting data {4:38}
  • Notes {1:58}
  • Comments {3:25}
  • Chat {2:21}
  • Selecting & moving data {4:27}
  • Sorting data {2:26}
  • Filtering data {2:22}
  • Filter views {3:08}
  • Publishing files {2:32}
  • Version history {2:12}

MAKING CHARTS

  • REPT charts {2:40}
  • Bar charts with table data {3:19}
  • Bar charts with raw data {1:48}
  • Grouped bar charts {6:36}
  • Bar charts with highlighting {2:18}
  • Pie charts {7:59}
  • Histograms {5:08}
  • Line charts {7:14}
  • Timelines {3:26}
  • Sparklines {7:27}
  • Scatterplots {3:14}
  • Scatterplots with highlighting {2:14}
  • Automatic charts with Explore {3:19}
  • Publishing charts {5:21}

USING FORMULAS

  • Cell references {6:48}
  • Counts, sums, & means {4:30}
  • Dates & times {10:43}
  • Selecting text {6:27}
  • Combining text & data {5:48}
  • Conditional formatting {5:18}

WRAPPING UP

  • Next steps {6:32}