Home

All courses

The Complete Google Sheets Course: Beginner to Advanced!

Google Sheets

Business

Business Analytics & Intelligence

The Complete Google Sheets Course: Beginner to Advanced!

A crash course in basic to advanced functions: Learn VLOOKUP, QUERY & MORE! Use many of these skills in Excel too!

4.7

(13276)

50618 enrolled on this course

Last updated 11/2021

Evan Ramsey

₹ 3099.0

₹ 4599.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

In this course you will learn the fundamentals of Google Sheets (some of which translates to Microsoft 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:
Learn the basics like how to create a Google Account and a Google Spreadsheet
Arithmetic Functions like SUM, COUNT, and AVERAGE
Shortcuts like filling formulas across THOUSANDS of cells
Advanced charts &
Beautiful Visualizations
PIVOT TABLES
- though I don't particularly like them...
Advanced functions
like INDEX MATCH MATCH and IMPORT RANGE
QUERY
, the function that DOES IT ALL!
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!
There are some updates to Google Sheets like Tables and others. We may be adding more content to the course to address these - stay tuned!
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!

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

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Spreadsheet Basics! What are they and how do they work?

1.1-Introduction: MANDATORY PLEASE READ

1.2-Pre-Work: Creating a Google Drive Account

1.3-Pre-Work: Creating a copy of my Spreadsheet Templates!

1.4-Spreadsheet Basics! What are they and how do they work?

1.5-Toolbar Walkthrough

1.6-Data Types in a Spreadsheet

1.7-Navigating Spreadsheets with Shortcuts!

1.8-Simple Formatting Tricks - Beautify your Spreadsheets!

2-Introduction to Functions!

2.1-Get Familiar with SUM, COUNT, AVERAGE, & MORE!

2.2-More Simple Functions: COUNTA, MIN & MAX

2.3-Intro to Activity: Your First Day at the Dumpling Stand

2.4-Solution to Activity: Your First Day at the Dumpling Stand

3-Conditional Functions

3.1-The IF Statement

3.2-AND/OR Statements

3.3-Nesting IF Statements & the IFS Statement

3.4-Solution to Activity & Crash Course in Conditional Formatting!

3.5-Conditional Arithmetic Functions (ie. SUM + IF)

3.6-HW Problem Solution & Wrap Up

4-Pivot Tables, Sorting, and Filtering!

4.1-Introduction to Raw data and the new Section Format

4.2-Crash Course in Pivot Tables Part I

4.3-Crash Course in Pivot Tables Part II

4.4-Intro to Activity: Building a Pivot Table for the Dumpling Business

4.5-Sorting & Filtering Part I

4.6-Sorting & Filtering Part II

4.7-Sorting & Filtering Part III

4.8-NOTE: There is a small error in the next lecture!

4.9-Solution to Activity: Sorting & Filtering!

4.10-Wrapping Up: Cool Applications of Sort & Filter

5-Charts & Graphs: Visualizing Data in Spreadsheets!

5.1-Intro to Charts & Graphs

5.2-Creating Charts in Google Sheets

5.3-Intro to Activity: Creating AMAZING Visuals

5.4-Solution to Activity: Creating AMAZING Visuals

6-Data Validation & an Introduction to Dynamic Models

6.1-What is Data Validation?

6.2-Data Validation: Hands on Activities

6.3-Creating Basic Dynamic Models

6.4-Intro to Activity: Beginner Data Validation & Intermediate Modeling

6.5-Solution to Activity: Beginner Data Validation & Intermediate Modeling

7-Errors, IFERROR, and creating Named Ranges

7.1-Every error you need to know, and how to fix 'em

7.2-The IFERROR formula. A machine to keep your spreadsheets clean!

7.3-Named Ranges - Prehabbing before you mess up your formulas!

7.4-Activity with Solutions - Another Day at the Dumpling Stand!

8-The Infamous VLOOKUP, Lookups, and INDEX(MATCH(),MATCH())

8.1-Let's get into the VLOOKUP Function! Also HLOOKUP...I guess

8.2-Activity: Housing Info with VLOOKUP & HLOOKUP

8.3-The BEST Lookup Formula! (INDEX(MATCH()MATCH()))

8.4-Activity: Finding Information with VLOOKUP & INDEX(MATCH,MATCH())

9-Working with Text Functions: Becoming a Wordsmith!

9.1-Introduction to Text Functions: Adding words together and changing their case!

9.2-Using LEFT, RIGHT, LEN and more to extract characters from cells!

9.3-Activity: Extracting First & Last Names from a cell!

9.4-TRIM & Final Activity with Solutions!

10-Date & Time Functions

10.1-Simple, but essential date & time functions: TODAY & NOW!

10.2-Date Functions Continued! EDATE, EOMONTH, and MORE!

10.3-Exercise Solution: The Countdown Clock!

10.4-Synthesizing Sections: An Interactive Calendar

11-Rounding & Randomizing: Keeping your spreadsheets SPICY!

11.1-Randomizing using RAND & RANDBETWEEN!

11.2-Rounding Out the Numbers with ROUND, ROUNDUP, and ROUNDDOWN!

11.3-Activity Intro: Build a Meal Randomizer!

11.4-Activity Solutions: Build a Meal Randomizer!

12-Stock Picking & Real-time Translators with GOOGLEFINANCE & GOOGLETRANSLATE!

12.1-Introduction to GOOGLEFINANCE: Get Stock Information INSTANTLY!

12.2-Introduction to GOOGLETRANSLATE: Become a Polyglot!

12.3-Activity: Creating the Stock Picker & Translator!

13-The Final Quest: IMPORTRANGE & QUERY!

13.1-Pull Spreadsheets together from ALL OVER the Google sheets universe!

13.2-CRASH Course in SQL! Introduction to SQL jargon and logic!

13.3-Building QUERY() in your Spreadsheet!

13.4-Mixing QUERY() with IMPORTRANGE(): Achieve Greatness.

13.5-QUERY() with IMPORTRANGE() Activity: Apply EVERYTHING to Analyze some Data!

13.6-The Final Lecture: Create Cell References within QUERY()!

Course Categories

Popular Courses

The Complete Google Sheets Course: Beginner to Advanced!

Description

What you'll learn

Requirements

Course Content

You May Like