Google Sheets

Learn to use Google Sheets

Bestseller
Created By: Barton Poulson
FREE

About This Course

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 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

Course created by Barton Poulson from datalab.cc.

License type: CC-BY

Other Information

  • Certificate will provided in this course on Completion
  • Full lifetime access
  • Available on Mobile & Laptop

What Students Will Learn In Your Course?

  •  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.

Are There Any Course Requirements Or Prerequisites?

  •  No prior knowledge or experience needed. Only a passion to be successful
  •  You'll need a desktop computer or a laptop

Who Are Your Target Students?

  •  Anyone interested to learn how to use Google Sheets

Course Content

  • 41 lectures
  • 03:02:34
  • Welcome
    00:04:53
  • Pictures first
    00:05:29
  • Anatomy of a spreadsheet
    00:05:06
  • Data types
    00:07:15
  • Formatting cells
    00:06:58
  • Tidy data
    00:02:57
  • Sharing files
    00:02:57
  • Sharing folders
    00:02:25
  • Entering data
    00:04:30
  • Importing data
    00:02:56
  • Copying & pasting data
    00:04:37
  • Notes
    00:01:57
  • Comments
    00:03:24
  • Chat
    00:02:20
  • Selecting & moving data
    00:04:26
  • Sorting data
    00:02:25
  • Filtering data
    00:02:21
  • Filter views
    00:03:07
  • Publishing files
    00:02:31
  • Version history
    00:02:11
  • REPT charts
    00:02:39
  • Bar charts with table data
    00:03:18
  • Bar charts with raw data
    00:01:47
  • Grouped bar charts
    00:06:35
  • Bar charts with highlighting
    00:02:18
  • Pie charts
    00:07:58
  • Histograms
    00:05:07
  • Line charts
    00:07:13
  • Timelines
    00:03:25
  • Sparklines
    00:07:26
  • Scatterplots
    00:03:13
  • Scatterplots with highlighting
    00:02:13
  • Automatic charts with Explore
    00:03:18
  • Publishing charts
    00:05:20
  • Cell references
    00:06:47
  • Counts, sums, & means
    00:04:29
  • Dates & times
    00:10:42
  • Selecting text
    00:06:26
  • Combining text & data
    00:05:47
  • Conditional formatting
    00:05:17
  • Next steps
    00:06:31
Image

Barton Poulson

  • 4.32 (3842)
  • 790 Reviews
  • 3842 Students
  • 4 Courses