TRY ME!
→ Random Tutorial

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

Find The Most Common Word(s)

Find The Most Common Word(s)

Find out which words in your sheet are the most common. Highest count of each individual word.
Intermediate
Change the Default Font

Change the Default Font

Set a different default font for each sheet you open.
Beginner
Get Data With Comments

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
Hide Gridlines for Better Communication

Hide Gridlines for Better Communication

Without gridlines our sheets become a lot easier to communicate exactly what we want to communicate.
Beginner
Write Your First Script

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.
Most Popular Beginner
Switch Data

Switch Data

We're going through the switch formula because in the past if I've ever had to change, say a day of the week or a month on the calendar to a number, or I have to change that number to the month or text, it's really hard.
Intermediate
SWITCH() VLOOKUP()
Create Square Cells for Dashboards or Beautiful Information

Create Square Cells for Dashboards or Beautiful Information

I offer an alternative design for your dashboards. Any time you want to present information, stats, numbers, it's a good idea to see what else is possible. Design something that makes your sheets stand out from the drudgery we've been dealing with for decades of spreadsheets and dashboards.
Beginner
4 Ways to Make a New Spreadsheet

4 Ways to Make a New Spreadsheet

Here's four ways to make a new sheet. There's lots of reasons why you wanna know all of them. Makes you a more flexible, faster spreadsheeter.
Beginner
CONCAT()
Made a Conference Schedule Better - Member Request!

Made a Conference Schedule Better - Member Request!

Go through a fun sheet and make it better.
Advanced
Use Min and Max for More Average Averages

Use Min and Max for More Average Averages

What happens very often is we want to figure out an average averages, help us tell the story of a large set of data, but averages also can lie.
Beginner
AVERAGE() MAX() MEDIAN() MIN()
How to Use Smarket

How to Use Smarket

This video covers how a user would use Smarket to list items to be sold and then unlist those items to be sold. It uses two different forms for the listing and the unlisting. The key connection is that you use a unique number, or a unique text when entering the item to be sold. Then use that item to delist it once it's been sold. Also you can wait 7 days, and the item will be unlisted.
Beginner
Richard Asks: Copy Template Tab and Rename to Date Every Week

Richard Asks: Copy Template Tab and Rename to Date Every Week

Member Richard asks this question. Answer: use Google Script and a Trigger.
Tagging Titles, Create a Comma Separated List of Tags

Tagging Titles, Create a Comma Separated List of Tags

The video tutorial is about tagging and creating comma-separated lists of tags for a list of titles. The tutorial demonstrates how to use data validation to create a drop-down menu of tags for each title and how to keep track of the number of videos or items in each tag category. The tutorial also shows how to create a comma-separated list of tags for each title using the JOIN function.
Intermediate
COUNTIF() FILTER() JOIN() TRANSPOSE()
Anika Asks: How to Bring value from other cells | How to Reference an array in a cell

Anika Asks: How to Bring value from other cells | How to Reference an array in a cell

She has a cell, this D one, in which it says, for instance, another array or a row or column in this case, a column, a on sheet one where we're on and she's referencing that from another cell.
Intermediate
INDIRECT() SORT() TRANSPOSE()
Better Than Happy | Redesign of The Feelings Wheel

Better Than Happy | Redesign of The Feelings Wheel

Turning an infographic into a useful Copy Writing cheat sheet
Beginner
Announcing Sell Daily and How I Built Sell Daily

Announcing Sell Daily and How I Built Sell Daily

Send daily emails to yourself to master sales every single day. 100% completely free for Better Sheet members.
Beginner
FILTER() HYPERLINK() IF() INDEX() MATCH() +3 more
Spreadsheet Automation 101: Functions

Spreadsheet Automation 101: Functions

Get introduced to Apps Script functions and functions syntax. Learn how to write new functions, how to name functions and call functions from your sheet.
 Think Like a Programmer: Develop The Mindset of an Apps Script Coder

Think Like a Programmer: Develop The Mindset of an Apps Script Coder

Learn how to think like a programmer and develop a coding mindset with these expert tips from a seasoned Google Sheets programmer. Don't fall for the common, ineffective advice, and instead follow this practical advice, including learning the process, figuring out how to search, and avoiding memorization. With these habits, you'll be on the path to successful coding. 

It's hard to code. It's even harder to learn to code. This is my thought process to help you become resilient enough to learn, and continue to learn to code.
 Seek Errors When Coding Apps Script

Seek Errors When Coding Apps Script

It's healthy programming. I'll show you some common errors you will encounter when you first start programming in Apps Script
Advanced
BetterSheets.co Tour for Lifetime Members

BetterSheets.co Tour for Lifetime Members

Find out all that Better Sheets has to offer you. Learn where to learn. Find out the features available to lifetime members at BetterSheets.co

Displaying items 301-320 of 329 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