Learn Google Sheets interactively using openly shared data!

Learn to become a Google Sheets master. Data used is shared, you are encouraged to follow along!
4.5 (27 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
797 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 20
  • Length 1.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2016 English

Course Description

Save time at your job and build marketable skills by mastering Google Sheets. This course takes you from beginner level to intermediate/advanced (think industry analyst level). You'll learn how to:

  • Create, name, share sheets
  • Format sheets, best practices
  • Conditional formatting
  • Filter and sort data
  • Use TEXT functions to clean/manipulate data
    • CONCATENATE, LEFT, RIGHT, MID, SUBSTITUTE
  • Use basic math functions, including
    • SUM
    • AVERAGE
    • COUNT
    • MIN
    • MAX
    • ROUND
  • More advanced math functions
    • SUMIFS
    • COUNTIFS
    • AVERAGEIFS
  • Create and customize charts
  • Pivot tables
  • Lookups
    • VLOOKUP, INDEX/MATCH
  • Use logical functions such as IF, OR, AND
  • Use INDIRECT and pair with INDEX/MATCH
  • Link data together from multiple spreadsheets using IMPORTRANGE

This course will give you you everything you need to know about Google Spreadsheets, an increasingly important tool and rapidly growing in the enterprise sector.

Additionally, this course will provide you with the example sheets covered, so you can follow along! How fun :)

What are the requirements?

  • You will need to have a Google account to follow along
  • Brush through the lectures before signing up, and if you're already a Google Sheets master (i.e. you are proficient with pivots, index/match, lookups, importing ranges) then this course may not be for you

What am I going to get from this course?

  • Use Google Spreadsheets at an intermediate/advanced level
  • Format data, create charts and tables
  • Quickly manipulate and clean data to uncover trends and communicate actionable insights
  • Link data across multiple interdependent Google Sheets using ImportRange
  • Display stock price information and set up a portfolio tracker
  • Much, much more (think helpful tips + shortcuts + best practices)

What is the target audience?

  • This course is for all levels, I'll cover the entry level stuff up front and progress down in difficulty, so those who are more advanced can skip to lectures of interest
  • Anyone who is looking at being an analyst or simply wants to improve their skill with Google Sheets or Excel

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
03:22
My background, high-level course offerings, and target audience.
Article

The attached article contains the link to the data shared in the course (shared via Google drive)

Section 2: The Basics
02:01

In this lecture, we cover the basics of creating a Google Spreadsheet, naming it, and sharing it with others.

If you're already comfortable with this portion feel free to skip down to the more advanced topics.

08:23

In this lecture, we cover the basics of formatting a Google Spreadsheet:

  • Changing text/background cell colors
  • Adding/removing borders
  • Add/remove gridlines
  • Freezing rows/columns

If you're already comfortable with this portion feel free to skip down to the more advanced topics.

Dataset(s) used:

  • McDonald's Menu - Nutrition + Prices
04:23

Here I'll show you how to automatically format cells in large tranches of data to quickly uncover trends using both built in and user defined formatting rules.

If you're already comfortable with this portion feel free to skip down to the more advanced topics.

Dataset(s) used:

  • McDonald's Menu - Nutrition + Prices


Section 3: Sort, Filter, and Clean Data (beginner level)
02:54

Showing you how to filter data, both by filtering out specific values and setting a condition.

Using data covering McDonald's nutrition facts and price prices in an eventual effort to uncover the cheapest/most expensive items on a price per calorie basis. Data is stored in shared folder from Introduction, so feel free to follow along!

Dataset(s) used:

  • McDonald's Menu - Nutrition + Prices
07:07

Find and replace is used to both search spreadsheets and replace with an input of your choice. Tool can also be used to search formulas within your spreadsheet which can come in handy.

Using data covering McDonald's nutrition facts and price prices in an eventual effort to uncover the cheapest/most expensive items on a price per calorie basis. Data is stored in shared folder from Introduction, so feel free to follow along!

Dataset(s) used:

  • McDonald's Menu - Nutrition + Prices
07:51

Covering some of the more basic text formulas used for cleaning up data (removing unwanted spaces, joining fields together):

  • CONCATENATE
  • LEFT
  • RIGHT
  • MID
  • SUBSTITUTE

Using data covering McDonald's nutrition facts and price prices in an eventual effort to uncover the cheapest/most expensive items on a price per calorie basis. Data is stored in shared folder from Introduction, so feel free to follow along!

Dataset(s) used:

  • McDonald's Menu - Nutrition + Prices


05:38

Covering some of the more basic math functions, including:

  • SUM
  • AVERAGE
  • COUNT
  • MIN
  • MAX
  • ROUND


More advanced mathematical functions using logical operators can be found in "Pivots, Lookups, Logicals" section!

Dataset(s) used:

  • McDonald's Menu - Nutrition + Prices

Section 4: Charts, charts, and more charts! (beginner, but good refresher for most)
15:30

In this lecture, show you how to customize and create a variety of charts, including:

  • Column
  • Bar
  • Line
  • Combination (column + line)
  • Scatterplot
  • Stacked bar

Dataset(s) used:

  • Shark Tank Deals - Dataset containing deal statistics from the TV show Shark tank
01:13

Here (again using the Shark Tank data) I'll show you how to publish an interactive version of your chart to a stand alone web link, or embed it in a web page (blog, etc)

Dataset(s) used:

  • Shark Tank Deals
Section 5: Pivots, lookups, logicals (faster-paced, higher-level topics)
05:04

Here you'll learn to:

  • Create pivot tables to quickly summarize information + uncover trends
  • Apply filters and manipulate the views

Dataset(s) used:

  • Caffeine Content - contains the amount of caffeine and half life (how long the caffeine lasts) for several popular beverages

11:02

In this lecture, I'll show you how to use the most popular LOOKUP functions to search data ranges and return specified values.

Dataset(s) used:

  • Caffeine Content - contains the amount of caffeine and half life (how long the caffeine lasts) for several popular beverages

07:25

Intro to building logical functions using IF, OR, and AND to create rules and create true/false test cases to manipulate data.

Dataset(s) used:

  • Caffeine Content - contains the amount of caffeine and half life (how long the caffeine lasts) for several popular beverages


05:05

Here I'll cover the following math functions:

  • SUMIFS
  • COUNTIFS
  • AVERAGEIFS


Dataset(s) used:

  • McDonald's Menu - Nutrition + Prices
07:36

Showing you an example of INDIRECT, which returns a cell reference specified by a string and is especially useful for aggregating data from multiple tabs having a similar layout.

Dataset(s) used:

  • Caffeine Content - contains the amount of caffeine and half life (how long the caffeine lasts) for several popular beverages

04:03

IMPORTRANGE is used to import a range of cells from a specified spreadsheet, meaning you can link multiple, separate, Google sheets together.

Dataset(s) used:

  • Caffeine Content and Shark Tank Data
Section 6: My favorite keyboard shortcuts/time savors (extra)
Article

Article contains my most used keyboard shortcuts; these are extremely valuable time savors and well worth putting the effort in to learn for those who use Sheets on a frequent basis.

Section 7: Bonus lectures!
Further learning resources (links)
Article
Further learning resources (video)
03:21

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Erik Rood, Analyst at Google

Hi! My name is Erik. I currently work as an analyst at Google. I have a strong interest in data visualization and analysis, so the content I publish here will be more or less related to that.

Feel free to reach out via email with any questions, hope you find the courses useful!

Ready to start learning?
Take This Course