Hey I’m Seth!

Founder, No Code MBA
Each week I share the latest No Code MBA tutorials, interviews, and tool recommendations with 20,000 subscribers.
I'd love for you to join as well.
2 min read only
Practical lessons
Free access to content
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form...
Ends 5/2/24
Our Sprig Sale is now live! Get 50% off an annual membership  →

The Complete Guide to Google Sheets

The only course you'll ever need to learn Google Sheets
4.6
rating
179
reviews

The Complete Guide to Google Sheets

The only course you'll ever need to learn Google Sheets
4.6
rating
179
reviews

The Details

During the process of building, you'll learn how to:
  • 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

Description

This is the only course on Google Sheets you'll ever need.

It's for anyone who wants to go from a spreadsheet novice to a spreadsheet expert.

Do you feel like you’d be more likely to get hired or promoted if you were better at spreadsheets?

Do you waste countless hours building spreadsheets when others take a fraction of the time?

Would you be more confident at work if you understood how to use spreadsheets?

Do you want to learn advanced Google Sheets techniques that will impress your boss?

If you answered yes to any of these questions, this is the course for you.

You’ll learn everything you need to know to go from spreadsheet novice to spreadsheet expert.

And almost everything you learn in this course can also be applied to Microsoft Excel, since they are so similar.

By the end of this course: you’ll:

  • You’ll be confident using spreadsheets at work
  • You’ll be the go-to Google Sheets wiz at work
  • You’ll know how to approach and think about data problems
  • You’ll understand how to format spreadsheet effectively

In this course, I’ve condensed everything I’ve learned about Google Sheets over the last 10 years into one easy-to-follow course. I've used Google Sheets at my own companies, working for venture-backed startups, and to earn tens of thousands of dollars freelancing for other businesses.

You’ll learn through practical, real-world examples to help you easily understand the material.

This course is up-to-date (as of 2023), and will be consistently updated as Google Sheets adds new features.

If you have any questions at all before signing up, please reach out to me at seth@nocode.mba so I can help make sure this course is right for you.

Show more

Pre-requisites

No prerequisites are required for this course! You don't need any coding or AI knowledge to start. All you need is a computer, an internet connection, and a willingness to learn!

This course is for...

Entrepreneurs
Freelancers
Marketers
Operators
  • Professionals who want to expand their skillset
  • Beginners who want a basic understanding of Google Sheets in an easy-to-understand way
  • Students who want to be prepared for the professional world
  • Entrepreneurs
  • Marketers
  • Operators
  • Consultants
Cliche but TRUE. I'm now capable of building out MVPs 10x faster and fulfill my clients' needs easier. My work-life balance has improved and so has my social life.
Ahmed Atlas
Get full access with a 60-day money-back guarantee

Empowering 1000s of Students

Terrific way to learn No-Code
Nocode mba builds confidence bh straightaway taking you to the meaningful projects. You build your muscle by doing real life projects including those using High end AI. I even learnt more about open AI and APIs during the course than before it.
Neetish
Great practical examples and projects
I signed up for NoCode MBA a long time ago when it didn't have much content available, the value has only increased as more high quality content has been added. Great practical examples and projects.
Charlie Moseley
Very detailed and curated for all!
I’ve been in this community for the last 2 and a half years and it has been nothing but excellence. Seth is quick to recognise trends and show us how to build SaaS apps of the time.
Meddy
Show all 400+ reviews

Curriculum

1. Google Sheets Basics
Learn the basics of Google Sheets and take control of your data.
35 min
preview
Learn the basic interface
1:29
1. Google Sheets Basics
Learn the basics of Google Sheets and take control of your data.
35 min
preview
Learn basic formatting, sorting, and how to freeze rows
2:14
1. Google Sheets Basics
Learn the basics of Google Sheets and take control of your data.
35 min
preview
Learn how to use AVERAGEIF
8:10
1. Google Sheets Basics
Learn the basics of Google Sheets and take control of your data.
35 min
preview
Share your sheet and set up version history
2:42
1. Google Sheets Basics
Learn the basics of Google Sheets and take control of your data.
35 min
preview
Learn how to use UNIQUE and AVERAGE
2:26
1. Google Sheets Basics
Learn the basics of Google Sheets and take control of your data.
35 min
preview
Learn how to use version history and protect your sheet
4:05
1. Google Sheets Basics
Learn the basics of Google Sheets and take control of your data.
35 min
preview
Absolute vs relative references
4:39
2. Formatting in Google Sheets
Format Google Sheets like a pro to create data-driven spreadsheets for any industry.
20 min
preview
Use number formats (like currency) in Google Sheets
2:53
2. Formatting in Google Sheets
Format Google Sheets like a pro to create data-driven spreadsheets for any industry.
20 min
preview
Add hyperlinks to your Google Sheet
1:41
2. Formatting in Google Sheets
Format Google Sheets like a pro to create data-driven spreadsheets for any industry.
20 min
preview
Hiding rows and columns
1:19
2. Formatting in Google Sheets
Format Google Sheets like a pro to create data-driven spreadsheets for any industry.
20 min
preview
Conditional Formatting with Numbers
2:26
2. Formatting in Google Sheets
Format Google Sheets like a pro to create data-driven spreadsheets for any industry.
20 min
preview
Conditional formatting with a Color Scale
1:58
2. Formatting in Google Sheets
Format Google Sheets like a pro to create data-driven spreadsheets for any industry.
20 min
preview
Conditional Formatting by Text
1:38
2. Formatting in Google Sheets
Format Google Sheets like a pro to create data-driven spreadsheets for any industry.
20 min
preview
Conditional Formatting by Dates and Blanks
1:36
2. Formatting in Google Sheets
Format Google Sheets like a pro to create data-driven spreadsheets for any industry.
20 min
preview
Build drop downs into your spreadsheet
4:18
3. Analyzing with Logic in Google Sheets
Analyze with logic functions in Google Sheets
15 min
preview
Learn how to use If Statements in Google Sheets
2:45
3. Analyzing with Logic in Google Sheets
Analyze with logic functions in Google Sheets
15 min
preview
Using AND and OR statements
5:03
4. Cleaning and working with data in Google Sheets
Learn more advanced formatting, formulas, and techniques in Google Sheets
25 min
preview
Import data to Google Sheets
1:58
4. Cleaning and working with data in Google Sheets
Learn more advanced formatting, formulas, and techniques in Google Sheets
25 min
preview
Concatenate and Split function
3:54
4. Cleaning and working with data in Google Sheets
Learn more advanced formatting, formulas, and techniques in Google Sheets
25 min
preview
Left, Right, and Len functions
2:19
4. Cleaning and working with data in Google Sheets
Learn more advanced formatting, formulas, and techniques in Google Sheets
25 min
preview
Upper, Lower, and Proper functions
0:39
4. Cleaning and working with data in Google Sheets
Learn more advanced formatting, formulas, and techniques in Google Sheets
25 min
preview
Removing duplicates
1:31
4. Cleaning and working with data in Google Sheets
Learn more advanced formatting, formulas, and techniques in Google Sheets
25 min
preview
Use ImportRange to pull in data from another Google Sheet
3:26
4. Cleaning and working with data in Google Sheets
Learn more advanced formatting, formulas, and techniques in Google Sheets
25 min
preview
Using the IfError formula to clean data
2:31
4. Cleaning and working with data in Google Sheets
Learn more advanced formatting, formulas, and techniques in Google Sheets
25 min
preview
Paste as value only / paste as format only
3:07
4. Cleaning and working with data in Google Sheets
Learn more advanced formatting, formulas, and techniques in Google Sheets
25 min
preview
Learn how to use the Random functions
4:36
5. Advanced Google Sheets
Learn essential Google Sheets skills with this beginner-friendly project. VLOOKUPs, macros, and more!
20 min
preview
Learn how to use VLOOKUP
3:53
5. Advanced Google Sheets
Learn essential Google Sheets skills with this beginner-friendly project. VLOOKUPs, macros, and more!
20 min
preview
Learn how to use Index Match
4:07
5. Advanced Google Sheets
Learn essential Google Sheets skills with this beginner-friendly project. VLOOKUPs, macros, and more!
20 min
preview
What are Macros: absolute versus relative
3:19
5. Advanced Google Sheets
Learn essential Google Sheets skills with this beginner-friendly project. VLOOKUPs, macros, and more!
20 min
preview
Create a full macro
2:04
5. Advanced Google Sheets
Learn essential Google Sheets skills with this beginner-friendly project. VLOOKUPs, macros, and more!
20 min
preview
Pivot Tables 101
2:39
5. Advanced Google Sheets
Learn essential Google Sheets skills with this beginner-friendly project. VLOOKUPs, macros, and more!
20 min
preview
Using Slicers when building Pivot Tables
4:14

About the instructor/s

Seth Kramer

Hi! I'm Seth, the founder and lead instructor at No Code MBA.

I've built massive no-code automations for venture-backed startups, beautiful Webflow-powered websites (including one for a celebrity chef), and bootstrapped a 7-figure marketplace business.

No-code tools have helped me reach my entrepreneurial dreams without writing a line of code, and I'm thrilled to share everything I've learned with you through No Code MBA courses.

FAQs

What if I have zero experience with this stuff?

Don't worry at all if you have zero experience! This course has been specially designed with beginners in mind. You'll start with the fundamentals and gradually move on to more complex concepts. Every step will be explained in detail, and you'll have the chance to learn by doing, which is the best way to learn new skills!

Will I build a working app with your course?

Yes, absolutely! A major component of our course is a step-by-step guided project where you will build a working AI app from scratch. By the end of the course, not only will you have a fully functional app that you can showcase, but you'll also understand the principles behind it, allowing you to build your own apps in the future.

How long does it take to learn Google Sheets?
It can vary. This course is 32 lessons, with more than 3 hours of material. To fully grasp the material, I suggest spending double that time practicing. You could cram it all in a few days, but students usually find 1-2 hours a day managable and the best strategy for learning.
Do you have a refund policy?

Yes! If you're not satisfied with the course for any reason, you can request a full refund within 60 days of purchase, zero questions asked.

How long do I get access?

Once you purchase the course, you'll have access as long as your No Code MBA membership is active. We offer both annual and lifetime memberships.

Why should I purchase this course instead of learning on my own?
While self-learning can be a rewarding experience, it often involves a lot of trial and error, which can be time-consuming. The process of figuring out what works and what doesn't can take weeks, if not months. On the other hand, our course is designed to provide you with a clear, direct path to learning how to build. We've curated the course content based on years of experience and distilled it into lessons that are easy to understand and implement. This allows you to bypass the time and frustration of sorting through countless resources and making common beginner mistakes.

We break down complex concepts into simple, digestible parts, and our step-by-step approach ensures that you're never left wondering what to do next. You'll also have the opportunity to ask questions and get feedback, something that isn't usually possible with self-learning. Plus, the course is structured to keep you motivated and engaged, making the learning process not only effective but also fun! :)
Have more questions?

Feel free to reach out at seth@nocode.mba

Get full access to
The Complete Guide to Google Sheets
4.6
rating
179
reviews
Sign up now