New users: get 7 free days of No Code MBA Unlimited

00
D
00
H
00
M
00
S

Invest in yourself with No Code MBA Unlimited ➞

00
D
00
H
00
M
00
S
Current project
Cleaning and working with data in Google Sheets

1

.

Import data to Google Sheets
1:58
Current project
Cleaning and working with data in Google Sheets

2

.

Concatenate and Split function
3:54
Current project
Cleaning and working with data in Google Sheets

3

.

Left, Right, and Len functions
2:19
Current project
Cleaning and working with data in Google Sheets

4

.

Upper, Lower, and Proper functions
0:39
Current project
Cleaning and working with data in Google Sheets

5

.

Removing duplicates
1:31
Current project
Cleaning and working with data in Google Sheets

6

.

Use ImportRange to pull in data from another Google Sheet
3:26
Current project
Cleaning and working with data in Google Sheets

7

.

Using the IfError formula to clean data
2:31
Current project
Cleaning and working with data in Google Sheets

8

.

Paste as value only / paste as format only
3:07
Current project
Cleaning and working with data in Google Sheets

9

.

Learn how to use the Random functions
4:36
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

Removing duplicates

1:31
)
Lesson 5

Member Discussion

Upgrade to No Code MBA Unlimited to unlock member discussion