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

Hacks You Might Not Know

Hacks You Might Not Know

These are simple spreadsheet hacks you might not know about. Simple interface tricks that knowing about will make your spreadsheet life better.
How Starter Story Designs Data

How Starter Story Designs Data

Learn how Starter Story, and Pat Walls, created a report that is well designed and packed with information.

Get the report at starterstory.com/solopreneur
Mr. Beast Renamed My YouTube Titles

Mr. Beast Renamed My YouTube Titles

I need help to supercharge my YouTube channel! Are you struggling to find the best strategies to boost your YouTube channel's performance too? Let's see if Mr. Beast can help.


ROW() INDEX() JOIN()
The First Thing I Do When Starting a Google Sheet

The First Thing I Do When Starting a Google Sheet

Are you tired of the default look of your Google Sheets? In this video, I'll show you the ultimate way to revitalize your workspace and enhance your productivity. By changing the background and text color in Google Sheets, you can create a more personalized and visually appealing environment that suits your preferences. Join me as I guide you through the simple steps to achieve a vibrant and eye-friendly spreadsheet experience.

Get Sheet Styles here: https://sheet-styles.bettersheets.co/
Replace 1,000 Formulas Instantly

Replace 1,000 Formulas Instantly

Learn a cool trick you can do with the ArrayFormula. If you don't know what the ArrayFormula does, I show you how to use it in the first few minutes of this video.  Then show you how to use it better.
ARRAYFORMULA() SORT()
Creating a Live Message in Google Sheets

Creating a Live Message in Google Sheets

Sit back and enjoy this comprehensive tutorial on how to create a live message in Google Sheets. In this video, we dive deep into the process of live message creation, providing step-by-step instructions and practical examples. Whether you're a beginner or an experienced user, this tutorial will empower you to unleash the full potential of Google Sheets.
Explore Readable Hex Codes

Explore Readable Hex Codes

Welcome to the captivating world of Readable Hex Codes! In this video, we dive into the intriguing realm of colors represented by hex codes. You'll witness the magic unfold as we explore the delightful hues of "Coffee," "Decade," and many more. With a click, we'll reveal the true essence of these hex codes and bring them to life on a Google Sheet.
How to Focus on One Thing

How to Focus on One Thing

Create a simple checklist checker that shows us the first unchecked item in a task list.
How to Replace Text with a Blank Cell in Google Sheets

How to Replace Text with a Blank Cell in Google Sheets

Learn the Quick Fix! Replace Text with Blank Cell in Google Sheets Hassle-Free. Say Goodbye to Data Glitches. Super helpful when you need to find and replace in google sheets any text.
MicroManager: Hourly Email Reminders

MicroManager: Hourly Email Reminders

I'll show you how to set up a super powered checklist that can act like a micro manager. It emails you hourly with the top unchecked item on your To-Do list.
Fast FAQS

Fast FAQS

New Tool for you: Fast FAQs. Create a quick 10 question FAQ for any new product or new feature you want. Even great for topics and theories. 
Sheet uses your own API Key from Open AI to power an AI FAQ generator. Then you answer the questions in the sheet. 

Once you've written the proper answers you can publish directly to Ghost, along with FAQpage schema structured data that is optimized for Google.
Marketplace Opportunities

Marketplace Opportunities

Wanted to share with you some opportunities where you can optimize your listing and get the most people installing your Add-on.
Marketplace Approval

Marketplace Approval

We did it! The Add-on is approved. You can now go find the Add-on in the Google Workspace Marketplace.
Rejection!

Rejection!

We get our Add-on rejected. Oh no! But wait, stay calm. We'll read the email and see why it was rejected.
Submit Store Listing for Approval

Submit Store Listing for Approval

After you get OAuth consent screen approval you can go ahead and submit the store listing for review.
Marketplace Store Listing

Marketplace Store Listing

We will write our Store listing in this video.
Marketplace SDK Install and App Configuration

Marketplace SDK Install and App Configuration

Yet another confusing step in this whole process. In our cloud project we will have to search for, and enable the Marketplace SDK. Watch as I do it in this step-by-step guide.
OAuth Approval Request Granted

OAuth Approval Request Granted

YES! 
This is what the request granted email looks like! 
Phase 1 of 2 done. The next thing we need to do is submit our application to the Google Workspace Marketplace.
OAuth - Action Needed

OAuth - Action Needed

We got a reply from our OAuth submission. It says "Action Needed" In this video we'll go over the action needed and I'll show you what to do.
Complete the OAuth Consent Screen

Complete the OAuth Consent Screen

We'll finish up the OAuth consent screen form in this video.

Displaying items 241-260 of 635 in total