Current project
Google Sheets
1
.
Learn how to use VLOOKUP
3:53
Current project
Google Sheets
2
.
Learn how to use Index Match
4:07
Current project
Google Sheets
3
.
What are Macros: absolute versus relative
3:19
Current project
Google Sheets
4
.
Create a full macro
2:04
Current project
Google Sheets
5
.
Pivot Tables 101
2:39
Current project
Google Sheets
6
.
Using Slicers when building Pivot Tables
4:14
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
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