TRY ME!
→ Random Tutorial

107 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!

Build a Domain Grader

Build a Domain Grader

Create a way to grade the quality of a domain based on many different votes and inputs and qualities. Like measuring the length and ranking the results.
ARRAYFORMULA() CONCAT() COUNTA() COUNTIF() LEN() +1 more
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()
Ian Asks: How to sort dates by year/month (can't do with filter)

Ian Asks: How to sort dates by year/month (can't do with filter)

In Excel you actually have these options of sorting by year, by month, by date. But let's do it in Google Sheets.
Change the Default Font

Change the Default Font

Set a different default font for each sheet you open.
Beginner
Basics - 5 Ways to Change Row Height

Basics - 5 Ways to Change Row Height

You can change the row height in 5 different ways in a google sheet. Consider adding padding around your text with more row height. and column width.
Beginner
How to Refer to Other Cells - A1 and R1C1 Explained

How to Refer to Other Cells - A1 and R1C1 Explained

Get down to basics of spreadsheets.
Beginner
Combine 2 Columns into 1: First Names and Last Names Together

Combine 2 Columns into 1: First Names and Last Names Together

Add together two columns data.
Beginner
ARRAYFORMULA() CONCATENATE()
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()
Search for Photos in a Google Sheet

Search for Photos in a Google Sheet

This feature is really handy for designers who want to create notes around designs and mockups to showcase to clients. As a photographer, I can also use this to create a searchable sheet with keywords for my photos. You can even use screenshots instead of Unsplash photos like I'm using here. Basically, all you have to do is insert the images into cells and use V lookup to search for them using the ID numbers. You can use this to mock up a newsletter, test out different thumbnails as a YouTuber, or create a landing page or workflow for your business. It's really easy to change the photos by just changing the ID number.
VLOOKUP()
Count Domains In a List of Emails - Part 2

Count Domains In a List of Emails - Part 2

Part two. Count domains of emails you get. List of emails and get which domains are there!
Advanced
How To Replace First Word | Great for SEO keyword research

How To Replace First Word | Great for SEO keyword research

Replace and find word will search your documents for specific text, replaced with different text, or you can replace it with something else.
Beginner
MID()
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
Quadrant to List and List to Quadrant

Quadrant to List and List to Quadrant

We're going to like take some data, twist it and turn it into a different type of like look and feel. And then we're going to do the same thing in reverse.
Intermediate
FILTER() FIND() IF() IFERROR() JOIN()
How to Iterate Counting Blank Cells in Google Sheets

How to Iterate Counting Blank Cells in Google Sheets

Count different types of blank cells. Cells with nothing in them.
Intermediate
ARRAYFORMULA() IF() ISBLANK() MAX()
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()
David Asks: About Primary Keys

David Asks: About Primary Keys

Create relational databases with index/match. Discover the secret to efficient data management with primary keys! Learn how to sort, filter, and create tables based on unique identifiers in this expert video. Say goodbye to complicated spreadsheets and hello to easy data management.
Intermediate
INDEX() MATCH()
Discover Misspelled Duplicates

Discover Misspelled Duplicates

Discover effective methods to handle misspelled duplicates in Google Sheets using formulas without destroying your data. Search and find duplicates that are spelled differently.

Unveiling the Art of Taming Misspelled Duplicates: A Harmonious Symphony of Google Sheets Tricks and Tips

Embark on a captivating journey as we unravel enchanting secrets in this video guide.

Discover an ethereal dance of formulas that transcends the limitations of Google Sheets' native features, gracefully addressing the conundrum of misspelled duplicates. 

Delve into the profound intricacies of the issue, where statuses and names intertwine, inviting chaos into your CRM or meeting records. 

Witness the mesmerizing revelation of unorthodox yet elegant techniques that preserve your data's essence without sacrificing its integrity. Unveil the hidden world of the duplicate detector, where rows are harmoniously synchronized, leaving no spelling errors unnoticed. 

Prepare to be enchanted by the sublime artistry of equals unique, a symphony of transformation that transforms hundreds or thousands of rows into a carefully curated masterpiece. Immerse yourself in this poetic quest and unlock the mystique of finding truth amidst a sea of missteps.
Beginner
ARRAYFORMULA() COUNTIF() LOWER() SORT() UNIQUE() +1 more

Displaying items 81-100 of 107 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