For Beginners

About this topic

Google Sheet tutorials for Beginners at Google Sheets. What to watch when you're just starting out using Google Sheets.

Are you new to using Google Sheets? Looking for a comprehensive guide to help you get started? Everything you need to know to get started using Google Sheets.

Explore what Google Sheets can do in this section of videos.

Find out what data validation can do for you, your data, and your mental health. Discover the basic structure of a sheet, and more.

Tutorials

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

Hacks You Might Not Know

These are simple spreadsheet hacks you might not know about. Simple inte...

Beginner

How to Focus on One Thing

Create a simple checklist checker that shows us the first unchecked item...

Beginner

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

Let's figure out how a sheet is structured.

Beginner

COLUMN() INDEX() ROW()

The First Thing I Do When Starting a Google Sheet

Are you tired of the default look of your Google Sheets? In this video, ...

Beginner

Count How Many Subscribers In a Company by BetterSheets.co

I download it from MailChimp and then I try to figure out which companie...

Intermediate

ARRAYFORMULA() COUNTIF() LOWER() SORT() SPLIT() +1 more

Every Tab Has a Unique ID called GID

Less than 2 minute tip to help you link directly to a tab in a sheet. Ea...

Beginner

Combine Filters in One Column

Using the ampersand and ARRAYFORMULA to combine two filters into a singl...

Beginner

ARRAYFORMULA() FILTER()

How To Send Two Emails in Same Trigger

Without having to create two functions and two triggers you can combine ...

Intermediate

Big Year - a Whole Year in One Google Sheets Tab

Get "Big Year" for free via Gumroad. Get perspective on your 2024 plan ...

Turn Titles Into Lower Case Hyphened Slugs

Create a slug maker inside your sheet. We'll take any title with any cas...

Beginner

ARRAYFORMULA() LOWER()

Google Sheets Easter Eggs Beyond PRIDE

Going beyond PRIDE, to show you some undocumented google sheets hacks th...

Advanced Intermediate Beginner

How to Insert Multiple Rows in Google Sheets (Easy to Hard)

Learn how to add multiple rows to your google sheets by hand, and automa...

Advanced Intermediate Beginner

One Million Checkboxes

Check out this fun onEdit() counting you can do with checkboxes in a fun...

Beginner

Two Things to Know When Starting to Learn Google Sheets

Two things I would teach every beginner to immediately improve your skil...

Beginner

IF() ISBLANK()

Timestamp When Done (With Code)

Automatically create a timestamp when a certain cell is marked as Done. ...

Beginner

Clean Up Names in a List

In this video, I will show you how to clean up a list of names that may ...

Beginner

TRIM() UNIQUE()

Curate Google Sheets Easily - Automatic Bookmarklet Maker

Curated sites, articles, and more web resources super easily into a Goog...

Beginner

Automatically Check Past Stages

Create an automation that runs whenver we check off a checklist item the...

Beginner

Currency Exchange Tricks In Google Sheets

Little tricks to make Currency Exchange in Google Sheets better for you,...

Advanced Intermediate Beginner

GOOGLEFINANCE()

Invoicing in Google Sheets for Freelancers

Introduction to creating a filter so that you can bill for a certain tim...

Beginner

FILTER() IFNA() SUM()

How To Select an Image based on Text in a Dropdown Menu

This video is a tutorial on how to create a dynamic weekly planner in Go...

INDEX() MATCH() VLOOKUP()

Your First Formula

Learn how to use Formulas in Google Sheets. Use the Equal sign "=" to un...

Beginner

CONCATENATE() TRANSPOSE()

Move Cells to New Row with Formula

Move a range, or a set of cells, to a new area with a simple formula tha...

Beginner

I Created an Advent Calendar

Just in time for the holidays. Great for making promotion calendars to r...

Beginner

IMPORTRANGE()

Twitter Sort Tool

I'll show you how I created a Twitter tool sort to organize my list of e...

Beginner

LEN() SORT()

Find a Value in a Range

I'll show you how to easily find a specific value in a range using two p...

Beginner

INDEX() MATCH() VLOOKUP()

Spreadsheet Automation for Beginners

I start off this video with the idea to show beginners how to automate e...

Beginner

INDEX() SPLIT()

Replace 1,000 Formulas Instantly

Learn a cool trick you can do with the ArrayFormula. If you don't know w...

Beginner

ARRAYFORMULA() SORT()

Automate Google Sheets With Zero Experience

By the end of this video you should be knowledgeable about how to automa...

Beginner

3 Ways to Count in Google Sheets

The video explains three ways to count cells or information in Google Sh...

Beginner

COUNTA() COUNTIF()

Tips to Navigating Thousands of Lines of Code In Apps Script

Find out how I use Apps Script built in features to code very quickly an...

Beginner

Get Sheets Wrapped 2024 | Your Year in Google Sheets

Get this free review of your Google Sheets in 2024. https://bettersheet...

Beginner

DATEDIF() TODAY() YEAR()

Automatically Uncheck A Daily Checklist

Create an automatic unchecker for a daily checklist. Fun way to learn Ap...

Beginner

Facebook Ads Mockup Generator

Create a simple facebook ad mockup with image and primary text in a goog...

Beginner

IMAGE() LEN()

Project Based Task Management

Create a better checklist for project based task management.

Conditional Formatting Beginner

COUNTA() COUNTIF() IF()

Creating a Random Motivational Quote Checklist

I'll show you how to create a motivational quote checklist that generate...

Beginner

COUNTA() INDEX() RANDBETWEEN()

User Filter a Google Sheet Database based on Dates, Checkboxes, Dropdown!

Search through and filter data to get what you want, when you want it. T...

Beginner

FILTER() IF()

4 Ways to Make a New Spreadsheet

Here's four ways to make a new sheet. There's lots of reasons why you wa...

Beginner

CONCAT()

Optimize SEO with Google Sheets and Google Search Console

Use Google Sheets to quickly find pages we can optimize. Using data dire...

Beginner

AND() FILTER() IF() SORT()

How to Make Better Lead Magnets

Learn how to make better lead magnets from Google Sheet checklists. Grea...

Beginner

HYPERLINK() IF()

10 Things I Hate About Your Spreadsheets

10 Things I Hate About Your Spreadsheets and how to fix them. Here is a ...

Conditional Formatting Data validation Beginner

IF() ISBLANK() ISEMAIL() ISURL()

Open Spreadsheet to Motivational Quote Automatically

Create a simple script to open a particular tab. In this case we're open...

Beginner

COUNTA() INDEX() RAND() ROUNDUP()

How to Count Numbers in a Row

Got this question in the Facebook Group: How to count the number of numb...

Beginner

AND() COUNT() COUNTA() COUNTIF() FILTER() +1 more

Meet Asa: Ask Sheets Anything

GPT3 Powered Answers to your spreadsheet questions. Ask sheets anything,...

Ultimate Checklist in Google Sheets

how to create and customize checklists using Google Sheets. I show you h...

Beginner

COUNTA() COUNTIF() IF() SPARKLINE()

Count Unique Attendees For Each Event

Find out how many people attended each event even if they are double cou...

Beginner

COUNTUNIQUE() FILTER() SUM() UNIQUE()

Discover Misspelled Duplicates

Discover effective methods to handle misspelled duplicates in Google She...

Beginner

ARRAYFORMULA() COUNTIF() LOWER() SORT() UNIQUE() +1 more

How To Add Columns in Google Sheets

Do you know all the ways to add columns to your Google Sheets?

Beginner

Creating Blank Cells For Good Reasons with IfError Formula and if(isBlank) Formula

There are surprisingly few times you want to have blank cells, or even c...

Basics - 5 Ways to Change Row Height

You can change the row height in 5 different ways in a google sheet. Con...

Beginner

Allow Multiple Selections is in Google Sheets Yay!

Now you can select multiple options in a dropdown. Hip Hip Hooray!

Beginner

FILTER() IFNA() JOIN() SEARCH() SPLIT() +1 more

Better Sheets Videos Checklist

How to create a video checklist. Create a sheet with check boxes that yo...

Data validation Beginner

COUNTA() COUNTIF() FILTER() IFNA() SORT() +1 more

Kristy Asks How to Get Percentages from Scores

How to figure out a percentage score when our reporting numbers are a fo...

Beginner

ARRAYFORMULA() IF() INDEX() ISBLANK() LEFT() +3 more

Add Character Count and Character Limit

I'm gonna show you how to make a character counter and then account char...

Beginner

LEN()

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!

Beginner

Create a Course Outline in Google Sheets

Wanted to share with members this course outline I am using for my own c...

Beginner

CONCAT() CONCATENATE() COUNTA() COUNTIF() IF() +4 more

How to Use AND(), OR() in IF() in Google Sheets For Multiple Criteria

One of the most simplest and useful formula combinations is using and an...

Beginner

Getting Started Coding in Apps Script

A short 10 minute video to get you started with Apps Script. Showing you...

Beginner

Basics - 4 Ways to Change Column Width

you might actually find something new and interesting about it. We're ju...

Beginner

Roast: Sidekick Recipes

Unlock the Secrets of Recipe Organization with this Google Sheet review....

Beginner

How to Use Sheets For Network Building

Using People Chips and Date Chips to make a quick network building list ...

Beginner

How To Filter Dates (They Are Numbers Too!)

Dates are numbers so you can filter them with greater than and less than.

Beginner

FILTER() IFERROR()

Magical Numbering

Create a sequence of numbers that magically appears as you type in each ...

Beginner

COUNTA() SEQUENCE()

Learn simple keyboard shortcuts to save you time

Learn some simple keyboard shortcuts.

Intermediate

SPLIT()

Basic Keyboard Shortcuts To Speed Up Your Productivity

We're gonna talk about some of the most basic keyboard shortcuts that in...

Beginner

How to Use AND() and OR() in IF() in Google Sheets For Multiple Criteria

One of the most simplest and useful formula combinations is using and an...

Beginner

AND() IF() OR()

That Viral Growing Plant Progress Chart

Create a growing flower pot from checkboxes with this bountiful formula ...

Data validation Beginner

COUNTIF() IMAGE() SWITCH()

6 Ways to Make Your Checkboxes Better

Learn How to Take Your Google Sheets Checkbox to the Next Level and Get ...

Data validation Beginner

Data Validation with Formulas

The issues you might run into validating data and 4 formulas you can use...

Intermediate

IF() ISBLANK() ISFORMULA() ISTEXT() ISURL()

Magical Things You Can do with Checkboxes in Google Sheets

Turn your sheets into web apps with interactive checkboxes. Make your sh...

Data validation Beginner

Make Color Changing Progress Bars - Make Progress Bars with Sparkline: Part 4

Create awesome progress bars with sparkline formula. You can make progre...

Intermediate

COUNTIF() MAX() SPARKLINE() TRUE()

How to Make Hangman Game In Google Sheets

Learn to create a fun game called Hangman in Google Sheets with Better S...

COUNTA() IF() IFERROR() JOIN() LEN() +1 more

5 Ways to use IF() Formula to Create Magic in Your Sheets

We're going to create some magic here. Some if magic, sprinkle a little ...

Intermediate

AND() IF() IFS() ISBLANK() OR() +1 more

How To Export Your Beautiful Sheets to PDF

Want to create sleek, stunning PDFs from your Google Sheets? Look no fur...

Beginner

My Favorite Fonts

Learn the best fonts to use in Google Sheets.

Beginner

Merge Cells for Dashboards

to make better Dashboards consider merging cells.

Beginner

Add a Checkbox to Turn on Dark Mode

Get ready to shake things up, formula fanatics! Learn how to add a dark ...

Conditional Formatting Beginner