TRY ME!
→ Random Tutorial

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

Create an Email Campaign Stats Calculator

Create an Email Campaign Stats Calculator

Take your email marketing to the next level with our Google Sheet Campaign Stats Calculator. Analyze open rates, click-throughs, and conversions, and make data-driven decisions to improve your campaigns. Build a sheet from scratch. We're going to build a calculator, with some functions and some custom functions in apps script. We'll also design the sheet like a funky dashboard.
Advanced
CONCATENATE() ROUNDDOWN() UPPER()
Create Drop Shadows! This makes your dashboards pretty.

Create Drop Shadows! This makes your dashboards pretty.

Add extra pizzazz. a little more snazz to your sheets. Make dashboards with very flexible drop shadows. A great google Sheet trick for any occasion.
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/
Create a Public Sheet and Private Sheet: Using ImportRange()

Create a Public Sheet and Private Sheet: Using ImportRange()

Stick around after the 1st portion of the video for bonus content.
Intermediate
FILTER() IMPORTRANGE()
Combine Sheets Into One Sheet As It Happens

Combine Sheets Into One Sheet As It Happens

Jodi asked:  ab out Building a sales CRM spreadsheet that has 4-5 tabs at the bottom. Each sales person gets their own sheet and then I want a master spreadsheet that pulls each salespersons Information they enter (customer, job, status etc) into one place. 

I’m not sure how to get the master sheet to pull in from the other sheets as they enter the data so that the master sheet shows real-time what’s happening without making one row = a row from another sheet.  I just want it to come in one row after the next as it happens.

Other Videos Mentioned in this video:
https://bettersheets.co/tutorials/add-a-timestamp-to-task-lists-without-now-formula
https://bettersheets.co/tutorials/spreadsheet-automation-101-lesson-2-onedit-trigger

Spreadsheet Automation 101: https://bettersheets.co/courses/spreadsheet-automation-101
Intermediate
IMPORTRANGE() SORT()
Turn Bland Sheets Into Glam Sheets!

Turn Bland Sheets Into Glam Sheets!

A few tips to make your Google Sheets look better.
Beginner
Create Navigation Buttons in Sheets to Other Sheets

Create Navigation Buttons in Sheets to Other Sheets

Add a button to go to another sheet inside your sheet.
Intermediate
Create a Self-Adding Dropdown Menu

Create a Self-Adding Dropdown Menu

Make a dropdown menu inside Google Sheets you can add to anything and it makes it available in the dropdown.
Roast: Sidekick Recipes

Roast: Sidekick Recipes

Unlock the Secrets of Recipe Organization with this Google Sheet review. A deep dive into a Google Sheet and how to improve it. Not just a Google Sheet Tutorial. Dive deep into a sheet that hold recipes. Great video for those looking to organize and share Recipes in a Google Sheet. Whether you're a home cook or a budding professional chef. You're probably already curating your recipes in a Google Sheet. Here's how to make your sheet better.
Beginner
Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!

Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!

Turning a drab sheet into a fab sheet. Transform your job search with this amazing job application tracker template! Get it now from the Land of Random newsletter and streamline your job hunt.
 5 Ways to use IF() Formula to Create Magic in Your Sheets

5 Ways to use IF() Formula to Create Magic in Your Sheets

We're going to create some magic here. Some if magic, sprinkle a little magic on your sheets, you can use these formulas in existing sheets.
Intermediate
AND() IF() IFS() ISBLANK() OR() +1 more
Automatically Delete All Sheets If Not Listed Name

Automatically Delete All Sheets If Not Listed Name

A raw, 1 shot take of figuring out how to automatically delete all sheets not named on a whitelist of sheet names. Using the on Change Installable trigger. This video was tough to make!
Advanced
Show Sheet Tabs Based on Edit

Show Sheet Tabs Based on Edit

Show a sheet or tab based on a code being entered in one sheet.
Intermediate
Sheet Improvement: Electric Vehicle Stock Tracker by evuniverse.io

Sheet Improvement: Electric Vehicle Stock Tracker by evuniverse.io

An epic sheet improved in under one hour. Watch this video to see me revamp a Google Sheet and Take it to the Next Level!  Discover the Secrets to Improving this EV Universe Sheet, Including Customized Colors, Easy Navigation and Valuable Updates. 
 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
How To Color Cell Blocks So Others Enter Data Easily

How To Color Cell Blocks So Others Enter Data Easily

Use neon blue to show where someone needs to enter data.
Beginner
Add Team Members to the Quick CRM

Add Team Members to the Quick CRM

We have a question from Rupesh about the quick CRM. He wants to add some team members.
Intermediate
FILTER() IMPORTRANGE()
Sheet Improvement: Better Band Bureau Better Schedule

Sheet Improvement: Better Band Bureau Better Schedule

A few tips: Delete extra columns and rows to improve readability, change the colors and fonts to incorporate branding, and adjust the sheet to promote the Better Band Bureau podcast more.
Basics - Structure of a Sheet: Index() Row() and Column()

Basics - Structure of a Sheet: Index() Row() and Column()

Let's figure out how a sheet is structured.
Beginner
COLUMN() INDEX() ROW()
Add A Timestamp to Task Lists (without Now Formula)

Add A Timestamp to Task Lists (without Now Formula)

How to add a timestamp to done tasks. Learn how to easily add timestamps to your done tasks! Say goodbye to manual formatting and hello to this simple code. Click now to save time! 
Advanced
FILTER() NOW()

Displaying items 181-200 of 354 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