×
Hey, I'm Seth
Each week I share the latest No Code MBA tutorials, interviews, and tool recommendations with 4000 subscribers.
I'd love for you to join as well.
  • 2 minute read
  • Practical lessons
  • Free access to content
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

New members: get your first 7 days of No Code MBA Unlimited for free! Click here to redeem

🎉 Flash Sale: Get 30% off No Code MBA Unlimited with code SPRING30 at checkout ➞

00
D
00
H
00
M
00
S
Current project
Google Sheets Basics

1

.

Learn the basic interface
1:29
Current project
Google Sheets Basics

3

.

Learn how to use AVERAGEIF
8:10
Current project
Google Sheets Basics

4

.

Share your sheet and set up version history
2:42
Current project
Google Sheets Basics

5

.

Learn how to use UNIQUE and AVERAGE
2:26
Current project
Google Sheets Basics

7

.

Absolute vs relative references
4:39
Part of course

The Complete Guide to Google Sheets

Formatting in Google Sheets

3

.

Hiding rows and columns
1:19
Formatting in Google Sheets

6

.

Conditional Formatting by Text
1:38
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

4

.

Create a full macro
2:04
Advanced Google Sheets

5

.

Pivot Tables 101
2:39

YOUR MEMBERSHIP

Basic

Includes No Code 101

Learn how to use UNIQUE and AVERAGE

2:26
)
Lesson 5
Download File

You finished the course! 🥳

What did you think?
Oops! Something went wrong while submitting the form.
Download File

You finished the project! 🥳

What did you think?
Oops! Something went wrong while submitting the form.

Notes

You can follow along on this Google Sheet

Member Discussion

Upgrade to No Code MBA Unlimited to unlock member discussion