Better Sheets

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

Spreadsheet Automation 101 Lesson 1: getActiveSpreadsheet() vs getActiveSheet()

Learn the difference between getActiveSpreadsheet() and get ActiveSheet(). Don’t get confused. Learn more with this lesson.

Spreadsheet Automation 101 Lesson 4: OmdbAPI Parameter Picker

Get more things than just the poster and movie title by changing our script a bit. By creating different functions, we can get other data such as movie posters or directors.

Meet Asa: Ask Sheets Anything

GPT3 Powered Answers to your spreadsheet questions. Ask sheets anything, literally any question about Google Sheets! This might put me out of a job as a Google Sheets Expert.

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.

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.

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

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 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.

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.

Intermediate

How to Find Duplicates

Learn how to find duplicates with a simple formula in Google Sheets.

CONCATENATE() FILTER() IF() MATCH() ROW()

Find "Entry Number" for Bookmarklet

Followup to the Bookmarklet video. To help you find the entry number for each form field.

Headline Generator: Add Dropdowns

Create a headline generator inside Google Sheets. Add dropdown menus to make the generator easy to us.

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.

Generate Hundreds of Business Names

Create business names quickly with this Google Sheets trick.

How to Download a Sheet as a CSV with a URL only

So you want to download a Google Sheet as a CSV. Let's do it!