Current project
Google Sheets
1
.
Import data to Google Sheets
1:58
Current project
Google Sheets
2
.
Concatenate and Split function
3:54
Current project
Google Sheets
3
.
Left, Right, and Len functions
2:19
Current project
Google Sheets
4
.
Upper, Lower, and Proper functions
0:39
Current project
Google Sheets
5
.
Removing duplicates
1:31
Current project
Google Sheets
6
.
Use ImportRange to pull in data from another Google Sheet
3:26
Current project
Google Sheets
7
.
Using the IfError formula to clean data
2:31
Current project
Google Sheets
8
.
Paste as value only / paste as format only
3:07
Current project
Google Sheets
9
.
Learn how to use the Random functions
4:36
Part of course
Google Sheets
Google Sheets
1
.
Learn the basic interface
1:29
Google Sheets
3
.
Learn how to use AVERAGEIF
8:10
Google Sheets
4
.
Share your sheet and set up version history
2:42
Google Sheets
5
.
Learn how to use UNIQUE and AVERAGE
2:26
Google Sheets
7
.
Absolute vs relative references
4:39
Google Sheets
2
.
Add hyperlinks to your Google Sheet
1:41
Google Sheets
3
.
Hiding rows and columns
1:19
Google Sheets
4
.
Conditional Formatting with Numbers
2:26
Google Sheets
5
.
Conditional formatting with a Color Scale
1:58
Google Sheets
6
.
Conditional Formatting by Text
1:38
Google Sheets
7
.
Conditional Formatting by Dates and Blanks
1:36
Google Sheets
8
.
Build drop downs into your spreadsheet
4:18
Google Sheets
2
.
Using AND and OR statements
5:03
Google Sheets
1
.
Import data to Google Sheets
1:58
Google Sheets
2
.
Concatenate and Split function
3:54
Google Sheets
3
.
Left, Right, and Len functions
2:19
Google Sheets
4
.
Upper, Lower, and Proper functions
0:39
Google Sheets
5
.
Removing duplicates
1:31
Google Sheets
7
.
Using the IfError formula to clean data
2:31
Google Sheets
8
.
Paste as value only / paste as format only
3:07
Google Sheets
9
.
Learn how to use the Random functions
4:36
Google Sheets
1
.
Learn how to use VLOOKUP
3:53
Google Sheets
2
.
Learn how to use Index Match
4:07
Google Sheets
3
.
What are Macros: absolute versus relative
3:19
Google Sheets
4
.
Create a full macro
2:04
Google Sheets
5
.
Pivot Tables 101
2:39
Google Sheets
6
.
Using Slicers when building Pivot Tables
4:14
Import data to Google Sheets
1:58
)
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