×
Hey, I'm Seth
Each week I share the latest No Code MBA tutorials, interviews, and tool recommendations with 10,000 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 →

🎉 30% off No Code MBA Unlimited. Sale Ends Friday ➞

00
D
00
H
00
M
00
S
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
The Complete Guide to Google Sheets

›

Advanced Google Sheets

›

Lesson 2

Learn how to use Index Match

4:07
)
Lesson 2

Member Discussion

Upgrade to No Code MBA Unlimited to unlock member discussion