The Complete Guide to Google Sheets

Categories: Programming & Tech

Course Content

Google Sheets Basics

Learn the basic interface

01:30
Learn basic formatting, sorting, and how to freeze rows

02:14
Learn how to use AVERAGEIF

08:11
How to share your sheet

02:42
Learn how to use UNIQUE and AVERAGE

02:27
Learn how to use version history and protect your sheet

04:05
Absolute vs relative references

04:40

Formatting in Google Sheets

Analyzing with Logic in Google Sheets

Cleaning and working with data in Google Sheets

Import data to Google Sheets

01:59
Concatenate and Split function

03:55
Left, Right, and Len functions

02:19
Upper, Lower, and Proper functions

00:39
Removing duplicates

01:31
Use ImportRange to pull in data from another Google Sheet

03:27
Using the IfError formula to clean data

02:31
Paste as value only / paste as format only

03:08
Learn how to use the Random functions

04:37

Advanced Google Sheets

Student Ratings & Reviews

No Review Yet

No Review Yet

Want to receive push notifications for all major on-site activities?

✕