Better Sheets

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!

Pabbly Connect Countdown - "Sheet Improvement!"

Create a countdown timer inside of a google sheet. Unlock the secret to a lifetime deal... TIMEI! Discover their amazing live Google sheet and join the countdown to their exclusive offer. Watch as we recreate and enhance their sheet with stunning colors. Don't miss out on this epic journey. Click now!

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

Biggest Flaw In Dashboards with Dark Colors

An optical illusion in Google Sheets and how to fix it.

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

Let's figure out how a sheet is structured.

Beginner

COLUMN() INDEX() ROW()

Basics - 4 Ways to Change Column Width

you might actually find something new and interesting about it. We're just changing the column width.

Beginner

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.

Find Keywords in Any Column. Create quick search dropdown to find keywords

Create a quick search dropdown to find keywords in any column.

Intermediate

Anders Asks: Can I Highlight Whole Row if Certain Columns have text?

Yes, using conditional formatting we can do this.

Conditional Formatting Beginner

Unique Features - Design a Better Dashboard Part 2

We're gonna talk about some features that we're gonna be using that might be new to you, or, just remind you that we're gonna use them to make 'em very interesting and unique to, using dashboards.

Advanced

Create an Auto-Update Sales Chart: Trailing 12 Months

how to create an auto-updating sales chart that displays the trailing 12 months of data in Google Sheets. The tutorial uses a sample dataset to demonstrate how to build a dynamic chart that updates automatically as new data is added.

Intermediate

SUM() IF() ISBLANK() INDEX() COUNTA()

Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!

Combine Databases and Backup Your Information Effortlessly - Learn how to merge two databases and compare backups with ease. Get all the information you need from past years and multiple sheets. Follow our step-by-step guide and simplify your data management today!

Intermediate

IMPORTRANGE()

How To Set Up Stripe Webhook to Google Sheets with Google Script

Learn how to set up a Stripe web hook in a Google sheet and Stripe to track new customers, payments, and cancellations with ease! Get the script and code on GitHub, available for everyone. No need to be a Better Sheets member.

Advanced

Use Cmd + Y To Do It Again, and Again, and Again

Very quick interesting little keyboard shortcut where you might not even know it exists. Repeat what you're doing, over and over again.

Beginner

Create a Trello Board with Transpose Formula in Google Sheets

Use Transpose() to create a web-based, Kanban style, list-making application inside your Google Sheet! Learn how to display tasks and to-do’s in vertical categories.

Let's Make a Bookmarklet!

Curate a newsletter. Collect YouTube videos. Research competitors. All with this one line of javascript. Build your own web clipper. Use the Bookmarklet to clip web content to your Google Sheet. Clip text and links directly from the web to your Google Sheet with just a few clicks.

Write Your First Script

I walk you through everything you may encounter along the way of coding in Google Apps Script. Discover the challenges and pitfalls before you fail. If you’ve never coded before, I’m right there with you all the way.

Hide Gridlines for Better Communication

Without gridlines our sheets become a lot easier to communicate exactly what we want to communicate.

Beginner

Basic Keyboard Shortcuts To Speed Up Your Productivity

We're gonna talk about some of the most basic keyboard shortcuts that incredibly time saving and are gonna make you so much faster when using Google Sheets.

Beginner

Get Data With Comments

A great way to manage your data if you have a small group of people who want to add data, but you want control over that data in the sheet. Give them the ability to comment on your data.

Beginner

How to Refer to Other Cells - A1 and R1C1 Explained

Get down to basics of spreadsheets.

Beginner

Displaying items 541-560 of 635 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

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons