TRY ME!
→ Random Tutorial

141 Google Sheet Tutorials

💡

An exclusive library of Google Sheet Tutorials

🚀
Efficient: Automation techniques to supercharge your workflow and automate repetitive tasks.
🎯
Precise: Ensure your data is always accurate and your analysis is clear.
🌈
Creative: Discover new ways to use Google Sheets.
❌
Can't Find a Video?: Members can reach out and ask me anything!

Better Sheets Videos Checklist

Better Sheets Videos Checklist

How to create a video checklist. Create a sheet with check boxes that you check off to mark the videos as seen. Great for those creating lead magnets or checklist digital products. Enables you to create a video course without having to download/upload any videos. Your users can keep track of their progress and get all the benefit of your knowledge.
Data validation Beginner
COUNTA() COUNTIF() FILTER() IFNA() SORT() +1 more
User Filter a Google Sheet Database based on Dates, Checkboxes, Dropdown!

User Filter a Google Sheet Database based on Dates, Checkboxes, Dropdown!

Search through and filter data to get what you want, when you want it. Tired of sifting through endless rows and columns? Learn how to filter your Google Sheet database with dates, checkboxes, and dropdowns. Simplify your workflow today!
Beginner
FILTER() IF()
Create a Sheet of Sheets for Project Management and/or Data Management

Create a Sheet of Sheets for Project Management and/or Data Management

Create an epic organization sheet of all your spreadsheets. Unlock the secret to compiling all your scattered information into one easy-to-use sheet. Learn how to merge data from multiple tabs with this one-sheet solution. Perfect for creating summaries and dashboards. Get started now and streamline your workflow!
COUNT() INDIRECT() REPT() SPLIT() TRANSPOSE()
Better Font Colors

Better Font Colors

While this advice and all well and good, try out Sheet Styles, a free Google Sheets Add-on that enables you to do this less contrast style in one click. https://sheet-styles.bettersheets.co/
10 Google Sheets I Wish Someone Would Make

10 Google Sheets I Wish Someone Would Make

if you're looking for ideas on what sheets to make I think this video is going to be super, super helpful to you because I'm going to explain not just the sheet I want and what it does, but over the course of all of these, I think you'll get a sense of some really interesting ideas on how to make sheets that sell.
Advanced
How To Track Crypto Prices

How To Track Crypto Prices

Get crypto prices into a Google Sheet.
Intermediate
GOOGLEFINANCE()
Transform Information Into an Info Product

Transform Information Into an Info Product

Transform your information into a money-making machine! Learn how to turn your data into an info product using Google Sheets. Easy steps to follow. Boost your business now! We are selling a Google sheet here. We're selling information, we're selling curation, we're selling the time and the effort and the energy and the focus around, uh, this kind of information that of course information is free online. But we'll make it better.
Intermediate
Make Unsplash in a Google Sheet w/ BuyMeACoffee - Part 1

Make Unsplash in a Google Sheet w/ BuyMeACoffee - Part 1

Create a photo search site inside with Google Sheets. Using this template you can empower users to: Enter a search term and get an image without leaving the sheet! And learn how to monetize this Google Sheet.
Most Popular Intermediate
QUERY()
Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Make your Google Sheets visually appealing and easier to understand with our expert tips on using gridlines, border styles, and colors. Learn how to create a professional-looking spreadsheet that effectively communicates your data to your audience. Boost your productivity today! We're gonna be talking about how to communicate better with grid lines, border styles, and border colors. Really interesting thing happens when you hide grid lines. You lose the grid, and I'll show you how to add that in. And some really interesting things you can do with different styles of border.
Beginner
Google Sheet Basics - The Absolute Basics

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreadsheet expert starts!
Beginner
Create Square Cells for Dashboards or Beautiful Information

Create Square Cells for Dashboards or Beautiful Information

I offer an alternative design for your dashboards. Any time you want to present information, stats, numbers, it's a good idea to see what else is possible. Design something that makes your sheets stand out from the drudgery we've been dealing with for decades of spreadsheets and dashboards.
Beginner
Ken Asks: Can We Add Star Ratings?

Ken Asks: Can We Add Star Ratings?

One common feature that users often request is the ability to add star ratings to their spreadsheets. While this feature is not built into Google Sheets, it is possible to create a star rating system using emojis and data validation.
Beginner
AVERAGE() SWITCH() VLOOKUP()
Aesthetics Teaser: How To Use Alternating Colors

Aesthetics Teaser: How To Use Alternating Colors

How to use alternating colors in your spreadsheets.
Beginner
RANK()
Make Your Lists Spicy Hot in Google Sheets

Make Your Lists Spicy Hot in Google Sheets

Create fun funky bullet points to get your point across better. Put emojis in your sheets to bring them to life.
Beginner
CONCAT() ROW()
Ken Asks: How can I count true and false? Answer: w/ CountIF()

Ken Asks: How can I count true and false? Answer: w/ CountIF()

the answer is if you have a column of true or false you can use the count if statement argument formula. That's just count if, and then you say your range, and then comma, true. Or false, whichever one you want and you'll get a count.
Beginner
COUNTIF()
Create a Summary Tab with Min and Max

Create a Summary Tab with Min and Max

Free tutorial for finding Minimum and Maximum data points.
Intermediate
INDEX() MAX() MIN()
More LinkInBio Templates for Google Sheets | SheetInBio

More LinkInBio Templates for Google Sheets | SheetInBio

You can easily add your own links and improve your bio for free.
Beginner
How to Name Sheet Tabs

How to Name Sheet Tabs

Organize tabs appropriately to decrease the friction that other users will have when reading or using your spreadsheets.
Beginner
Convert Your Bullet Journal To Google Sheets

Convert Your Bullet Journal To Google Sheets

Find out how you can make your spreadsheets like a Bullet Journal. It's like a super powered Bullet Journal.
Beginner
VLOOKUP()
Figure Out Frequency

Figure Out Frequency

Fid out how to get the frequency of ProductIds, or Names, or Emails. or how many times they appear in a sheet/column/row.

Displaying items 101-120 of 141 in total

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Explore

Academy

Tools

Add ons