Better Sheets

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

Scrape Google Maps Added Phone and Reviews

Added two helper functions to get Phone numbers and reviews of the Google Maps Results.

Tweet From a Sheet

See how to tweet from a sheet and get the code below.

Google Maps Scraper for Outreach

Get this fun template to search on google maps via API, and quickly message via Whatsapp. Then Manage the outreach.

Intermediate

Better Sheets Members Tour March 2026

Walk through what's available in Better Sheets. For beginners and advanced users alike.

Advanced Intermediate Beginner

100 Tweet Starters

Created a simple tweet starter sheet. Tweet directly from this Google Sheet. Free for Members.

Beginner

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

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/

Track Every Edit (Almost)

Create a Log sheet in Google Sheets

Visicalc 2023 Technical Walkthrough

welcome to the technical walkthrough of VisiCalc 2023. This is the sheet that I released on April 1st for April Fool's Day. Learn how to use the onEdit() function in Apps Script. We learn the Apps Script for: Save a Sheet , Active Cell coloring, and the Out of Memory Toast.

Advanced

2 New Ways To Add Emoji Reactions

Revolutionize the way you react with emojis! Discover two new methods to add emoji reactions and take your spreadsheets to the next level. Learn how to create a reaction clicker and a reaction picker to personalize your sheets with emojis. Don't miss out on this game-changing method in Google Sheets.

We're adding some emoji reactions to Google Sheets.

Create a Progress Bar - Make Progress Bars with Sparkline: Part 1

Let's make a progress bar in Google Sheets.

SPARKLINE()

My Favorite Fonts

Learn the best fonts to use in Google Sheets.

Beginner

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.

Member Asks: How do I calculate from a set of Form entries?

Use arrayformula to deal with Google form entries on a sheet. Even as they keep getting added.

ARRAYFORMULA()

Add a Checkbox to Turn on Dark Mode

Get ready to shake things up, formula fanatics! Learn how to add a dark mode button to your Google Sheets with this dead simple trick. Using conditional formatting and a custom formula, you can turn on dark mode with just one click. Don't miss out on this cool feature! Made this really quick dark mode click button. And I wanted to show you how I did it because it's dead simple, super simple. It's literally just using conditional formatting

Conditional Formatting Beginner

Send Daily Email Updates

extending Google Sheets in a really fun way. We're gonna be sending emails. I have had literally two people in the past week and a half ask me for this and I answered their question very specifically, but I wanna generally reach out to everyone here, give everyone the opportunity to learn this.

Advanced

Announcing OnlySheets

Introducing OnlySheets, the paywall for Google Sheets.

Dark Mode / Better Font Color

While the desktop version of Google Sheets does not have a dark mode, doesn't mean we can't make it ourselves. Create dark mode in one click. You'll learn to make a dark mode toggle.