The Complete Google Sheets Course: Beginner to Advanced!
4.5 (2,302 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9,696 students enrolled

The Complete Google Sheets Course: Beginner to Advanced!

A crash course in basic and advanced functions: Learn VLOOKUP, QUERY & MORE! Use many of these skills in Excel too!
Bestseller
4.5 (2,302 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9,687 students enrolled
Last updated 4/2020
English
English [Auto], French [Auto]
Current price: $121.99 Original price: $174.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 8 hours on-demand video
  • 2 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Create beautiful spreadsheets with amazing formatting tricks
  • Learn to manipulate text in formulas
  • Connect multiple Google Sheets together using a single formula
  • Analyze data sets with ease using complex functions & formulas
  • Learn to build incredible data visualizations using charts
  • Feel completely comfortable in a spreadsheet environment
  • Learn formulas that work in both Google sheets & Excel!
Requirements
  • A computer, a Google account, and the ability to navigate the internet
  • Know how to use a keyboard!
Description

In this course you will learn the fundamentals of Google Sheets (much of which translates to MS Excel!). You will not only learn the basics, like adding and subtracting. But you will also learn valuable advanced formulas like VLOOKUP, INDEX(MATCH()MATCH()), and IMPORTRANGE.

Never heard of those before? Don't worry! I start from the beginning - so those terms will become clear when the time is right.

Along the way, you will develop an amazing spreadsheet toolkit. Wondering what tools will be in that toolkit? Check out the list below for some highlights of the course:

  1. Learn the basics like how to create a Google Account and a Google Spreadsheet

  2. Arithmetic Functions like SUM, COUNT, and AVERAGE

  3. Shortcuts like filling formulas across THOUSANDS of cells

  4. Advanced charts & Beautiful Visualizations

  5. PIVOT TABLES - though I don't particularly like them...

  6. Advanced functions like INDEX MATCH MATCH and IMPORT RANGE

  7. QUERY, the function that DOES IT ALL! NOTE: More lectures incoming on this one :)

Ultimately, the point of this course is to get some awesome skills for professional or personal use. And - above all - have fun doing it!

My course isn't like a lot of other online Excel or Google Sheet courses. Most of these courses force you to watch them build things and hope that you understand what they are doing. Instead of that old model, I've incorporated everything I've learned from my experience in the real professional world to make this the best online Google sheets course. The course includes:

  • Lectures

  • Activities

  • Projects

  • Exercises

  • Slides

  • Comprehensive Workbooks WITH Answer Keys

  • Extra Learning Resources

If you have any questions, please don't hesitate to contact me. Sign up today and see how fun, exciting, and rewarding web development can be!


Who this course is for:
  • Spreadsheet users of all levels, those who want to get better at analyzing data or building spreadsheets for personal use!
  • This course is not for you if you are an experienced data analyst or power spreadsheet user.
  • Students who want to start a career in management consulting or tech operations!
Course content
Expand all 66 lectures 08:03:47
+ Spreadsheet Basics! What are they and how do they work?
8 lectures 45:11

Students will be able to create a Google account & spreadsheet.

Preview 00:24
Pre-Work: Creating a copy of my Spreadsheet Templates!
02:50
Spreadsheet Basics! What are they and how do they work?
06:22
Toolbar Walkthrough
10:27
Data Types in a Spreadsheet
06:34
Navigating Spreadsheets with Shortcuts!
11:19
+ Introduction to Functions!
4 lectures 40:29
Get Familiar with SUM, COUNT, AVERAGE, & MORE!
13:38
More Simple Functions: COUNTA, MIN & MAX
07:19
Intro to Activity: Your First Day at the Dumpling Stand
02:58
Solution to Activity: Your First Day at the Dumpling Stand
16:34
+ Conditional Functions
6 lectures 01:04:44
The IF Statement
11:34
AND/OR Statements
09:10
Nesting IF Statements & the IFS Statement
11:08
Solution to Activity & Crash Course in Conditional Formatting!
12:54
Conditional Arithmetic Functions (ie. SUM + IF)
08:39
HW Problem Solution & Wrap Up
11:19
+ Pivot Tables, Sorting, and Filtering!
10 lectures 01:05:57
Introduction to Raw data and the new Section Format
01:25
Crash Course in Pivot Tables Part II
10:48
Intro to Activity: Building a Pivot Table for the Dumpling Business
07:26
Sorting & Filtering Part II
06:19
Sorting & Filtering Part III
08:17
NOTE: There is a small error in the next lecture!
00:14
Solution to Activity: Sorting & Filtering!
13:43
Wrapping Up: Cool Applications of Sort & Filter
03:15
+ Charts & Graphs: Visualizing Data in Spreadsheets!
4 lectures 26:07
Intro to Charts & Graphs
05:12
Creating Charts in Google Sheets
14:05
Intro to Activity: Creating AMAZING Visuals
02:03
Solution to Activity: Creating AMAZING Visuals
04:47
+ Data Validation & an Introduction to Dynamic Models
5 lectures 37:58
What is Data Validation?
06:42
Data Validation: Hands on Activities
06:09
Creating Basic Dynamic Models
08:11
Intro to Activity: Beginner Data Validation & Intermediate Modeling
04:47
Solution to Activity: Beginner Data Validation & Intermediate Modeling
12:09
+ Errors, IFERROR, and creating Named Ranges
4 lectures 25:42
Every error you need to know, and how to fix 'em
10:10
The IFERROR formula. A machine to keep your spreadsheets clean!
04:24
Named Ranges - Prehabbing before you mess up your formulas!
03:35
Activity with Solutions - Another Day at the Dumpling Stand!
07:33
+ The Infamous VLOOKUP, Lookups, and INDEX(MATCH(),MATCH())
4 lectures 34:36
Let's get into the VLOOKUP Function! Also HLOOKUP...I guess
11:54
Activity: Housing Info with VLOOKUP & HLOOKUP
03:45
The BEST Lookup Formula! (INDEX(MATCH()MATCH()))
11:14
Activity: Finding Information with VLOOKUP & INDEX(MATCH,MATCH())
07:43
+ Working with Text Functions: Becoming a Wordsmith!
4 lectures 32:01
Introduction to Text Functions: Adding words together and changing their case!
08:08
Using LEFT, RIGHT, LEN and more to extract characters from cells!
11:50
Activity: Extracting First & Last Names from a cell!
05:20
TRIM & Final Activity with Solutions!
06:43
+ Date & Time Functions
4 lectures 19:06
Date Functions Continued! EDATE, EOMONTH, and MORE!
07:19
Exercise Solution: The Countdown Clock!
03:59
Synthesizing Sections: An Interactive Calendar
02:20