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

Read our in-depth 2022 no-code tool guide

The Google Sheets Masterclass

Become a Google Sheets power user! Solve complex data analysis, learn hacks and hidden features and automate your work.

Sign up

What you will learn

  • Google Sheets Interface
  • Basic formatting and sorting
  • Lookup formulas like VLOOKUP and Index Match
  • If Statements
  • Version History
  • Protect Sheets
  • Importing data
  • Text functions
  • Removing duplicates
  • Import data from other sheets
  • IfError formula
  • Macros
  • Using Google Sheets in real-world projects

Why take this course

Google Sheets is one of the most fundamental skills needed in the business world today.

In the past, you might have been able to get away understanding how to use word documents and email, but in today’s world understanding spreadsheets is a must.

If you don’t know how to use spreadsheets effectively, you might feel frustrated at work building out simple workflows or analysis.

You might find yourself thinking - there must be a better way to do this.

It doesn’t have to be this way.

No Code MBA’s Google Sheets course teaches you how to build powerful spreadsheets and handle complex data analysis and automations.

Through step-by-step video tutorials, you’ll learn everything from the fundamental basics of Google Sheets, all the way to advanced techniques like Pivot Tables and Macros.

You could comb through forums and Youtube to learn these tools on your own. Or you could learn the easy and fun way with real-world examples.

Plus, get access to the No Code MBA community to ask questions, and get support if you're stuck.

You’ll leave this course feeling confident with just about any spreadsheet situation you could come across.

Start building with No Code MBA today!

What makes No Code MBA different?

Our focus on real-world examples. Each course includes project tutorials from beginning to end, so you'll finish each course with something real to share with the world.

Who this course is for

  • Entrepreneurs
  • Freelancers
  • Marketers
  • Operators
  • Anyone who wants to make an impact

Course Content

2. Formatting in Google Sheets

Learn how to format like a pro in Google Sheets

Preview →

Use number formats (like currency) in Google Sheets

2:53
2. Formatting in Google Sheets

Learn how to format like a pro in Google Sheets

Preview →

Add hyperlinks to your Google Sheet

1:41
2. Formatting in Google Sheets

Learn how to format like a pro in Google Sheets

Preview →

Hiding rows and columns

1:19
2. Formatting in Google Sheets

Learn how to format like a pro in Google Sheets

Preview →

Conditional Formatting with Numbers

2:26
2. Formatting in Google Sheets

Learn how to format like a pro in Google Sheets

Preview →

Conditional formatting with a Color Scale

1:58
2. Formatting in Google Sheets

Learn how to format like a pro in Google Sheets

Preview →

Conditional Formatting by Text

1:38
2. Formatting in Google Sheets

Learn how to format like a pro in Google Sheets

Preview →

Conditional Formatting by Dates and Blanks

1:36
2. Formatting in Google Sheets

Learn how to format like a pro in Google Sheets

Preview →

Build drop downs into your spreadsheet

4:18
4. Analyzing with Logic in Google Sheets

Preview →

Using AND and OR statements

5:03
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Import data to Google Sheets

1:58
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Concatenate and Split function

3:54
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Left, Right, and Len functions

2:19
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Upper, Lower, and Proper functions

0:39
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Removing duplicates

1:31
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Use ImportRange to pull in data from another Google Sheet

3:26
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Using the IfError formula to clean data

2:31
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Paste as value only / paste as format only

3:07
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Learn how to use the Random functions

4:36
6. Advanced Google Sheets

Preview →

Create a full macro

2:04
6. Advanced Google Sheets

Preview →

Pivot Tables 101

2:39

Meet your instructor

Seth Kramer is an entrepreneur living in Washington DC. He's especially interested in technology, online education and the digital economy.

Seth started No Code MBA as a way to teach people how to build and start their own business using no-code tools. Within a few months, the business made over $10,000 in a single month, and now has over 1000 students learning no-code together.

FAQs

What if I'm new to Google Sheets?

Then you're in the right place! You'll get all the training you need, even if you're completely new.

Where do I attend the classes?

All classes are online, so you'll attend from the comfort of your own home at your own pace.

Can I get a preview?

Yes, definitely! Here's a preview of my teaching style to give you an idea of what you'll get.

What's your refund policy?

You may receive a full refund within 2 weeks of purchasing for any reason whatsover.

How long do I get access?

If you sign up for a lifetime membership, you'll get access forever! If you sign up for a subscription, you'll have access as long as you are a member.

Have more questions?

Feel free to reach out at seth@nocode.mba

What you will learn

  • Google Sheets Interface
  • Basic formatting and sorting
  • Lookup formulas like VLOOKUP and Index Match
  • If Statements
  • Version History
  • Protect Sheets
  • Importing data
  • Text functions
  • Removing duplicates
  • Import data from other sheets
  • IfError formula
  • Macros
  • Using Google Sheets in real-world projects

Course Content

2. Formatting in Google Sheets

Learn how to format like a pro in Google Sheets

Preview →

Use number formats (like currency) in Google Sheets

2:53
2. Formatting in Google Sheets

Learn how to format like a pro in Google Sheets

Preview →

Add hyperlinks to your Google Sheet

1:41
2. Formatting in Google Sheets

Learn how to format like a pro in Google Sheets

Preview →

Hiding rows and columns

1:19
2. Formatting in Google Sheets

Learn how to format like a pro in Google Sheets

Preview →

Conditional Formatting with Numbers

2:26
2. Formatting in Google Sheets

Learn how to format like a pro in Google Sheets

Preview →

Conditional formatting with a Color Scale

1:58
2. Formatting in Google Sheets

Learn how to format like a pro in Google Sheets

Preview →

Conditional Formatting by Text

1:38
2. Formatting in Google Sheets

Learn how to format like a pro in Google Sheets

Preview →

Conditional Formatting by Dates and Blanks

1:36
2. Formatting in Google Sheets

Learn how to format like a pro in Google Sheets

Preview →

Build drop downs into your spreadsheet

4:18
4. Analyzing with Logic in Google Sheets

Preview →

Using AND and OR statements

5:03
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Import data to Google Sheets

1:58
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Concatenate and Split function

3:54
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Left, Right, and Len functions

2:19
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Upper, Lower, and Proper functions

0:39
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Removing duplicates

1:31
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Use ImportRange to pull in data from another Google Sheet

3:26
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Using the IfError formula to clean data

2:31
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Paste as value only / paste as format only

3:07
5. Cleaning and working with data in Google Sheets

Learn more advanced formatting, formulas, and techniques in Google Sheets

Preview →

Learn how to use the Random functions

4:36
6. Advanced Google Sheets

Preview →

Create a full macro

2:04
6. Advanced Google Sheets

Preview →

Pivot Tables 101

2:39
Start learning today
Buy course