Current project
Advanced Google Sheets
1
.
Learn how to use VLOOKUP
3:53
Current project
Advanced Google Sheets
2
.
Learn how to use Index Match
4:07
Current project
Advanced Google Sheets
3
.
What are Macros: absolute versus relative
3:19
Current project
Advanced Google Sheets
4
.
Create a full macro
2:04
Current project
Advanced Google Sheets
5
.
Pivot Tables 101
2:39
Current project
Advanced Google Sheets
6
.
Using Slicers when building Pivot Tables
4:14
Part of course
The Complete Guide to Google Sheets
Google Sheets Basics
1
.
Learn the basic interface
1:29
Google Sheets Basics
2
.
Learn basic formatting, sorting, and how to freeze rows
2:14
Google Sheets Basics
3
.
Learn how to use AVERAGEIF
8:10
Google Sheets Basics
4
.
Share your sheet and set up version history
2:42
Google Sheets Basics
5
.
Learn how to use UNIQUE and AVERAGE
2:26
Google Sheets Basics
6
.
Learn how to use version history and protect your sheet
4:05
Google Sheets Basics
7
.
Absolute vs relative references
4:39
Formatting in Google Sheets
1
.
Use number formats (like currency) in Google Sheets
2:53
Formatting in Google Sheets
2
.
Add hyperlinks to your Google Sheet
1:41
Formatting in Google Sheets
3
.
Hiding rows and columns
1:19
Formatting in Google Sheets
4
.
Conditional Formatting with Numbers
2:26
Formatting in Google Sheets
5
.
Conditional formatting with a Color Scale
1:58
Formatting in Google Sheets
6
.
Conditional Formatting by Text
1:38
Formatting in Google Sheets
7
.
Conditional Formatting by Dates and Blanks
1:36
Formatting in Google Sheets
8
.
Build drop downs into your spreadsheet
4:18
Analyzing with Logic in Google Sheets
1
.
Learn how to use If Statements in Google Sheets
2:45
Analyzing with Logic in Google Sheets
2
.
Using AND and OR statements
5:03
Cleaning and working with data in Google Sheets
1
.
Import data to Google Sheets
1:58
Cleaning and working with data in Google Sheets
2
.
Concatenate and Split function
3:54
Cleaning and working with data in Google Sheets
3
.
Left, Right, and Len functions
2:19
Cleaning and working with data in Google Sheets
4
.
Upper, Lower, and Proper functions
0:39
Cleaning and working with data in Google Sheets
5
.
Removing duplicates
1:31
Cleaning and working with data in Google Sheets
6
.
Use ImportRange to pull in data from another Google Sheet
3:26
Cleaning and working with data in Google Sheets
7
.
Using the IfError formula to clean data
2:31
Cleaning and working with data in Google Sheets
8
.
Paste as value only / paste as format only
3:07
Cleaning and working with data in Google Sheets
9
.
Learn how to use the Random functions
4:36
Advanced Google Sheets
1
.
Learn how to use VLOOKUP
3:53
Advanced Google Sheets
2
.
Learn how to use Index Match
4:07
Advanced Google Sheets
3
.
What are Macros: absolute versus relative
3:19
Advanced Google Sheets
4
.
Create a full macro
2:04
Advanced Google Sheets
5
.
Pivot Tables 101
2:39
Advanced Google Sheets
6
.
Using Slicers when building Pivot Tables
4:14
Learn how to use Index Match
4:07
)
Get all access with No Code MBA Unlimited
- Unlock premium step-by-step tutorials building real apps and websites
- Easy to follow tutorials broken down into lessons between 2 and 20 minutes
- Get access to the community to share what you're building, ask questions, and get support if you're stuck
Companies often reimburse No Code MBA memberships. Here's an email template to send to your manager.
Member Discussion
Upgrade to No Code MBA Unlimited to unlock member discussion