Current project
Formatting in Google Sheets
1
.
Use number formats (like currency) in Google Sheets
2:53
Current project
Formatting in Google Sheets
2
.
Add hyperlinks to your Google Sheet
1:41
Current project
Formatting in Google Sheets
3
.
Hiding rows and columns
1:19
Current project
Formatting in Google Sheets
4
.
Conditional Formatting with Numbers
2:26
Current project
Formatting in Google Sheets
5
.
Conditional formatting with a Color Scale
1:58
Current project
Formatting in Google Sheets
6
.
Conditional Formatting by Text
1:38
Current project
Formatting in Google Sheets
7
.
Conditional Formatting by Dates and Blanks
1:36
Current project
Formatting in Google Sheets
8
.
Build drop downs into your spreadsheet
4:18
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
Use number formats (like currency) in Google Sheets
2:53
)
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
Member Discussion
Upgrade to No Code MBA Unlimited to unlock member discussion