79% OFF online library of tutorials for mastering Google Sheets

One time purchase $149

Better Sheets
Create Free accountMember Login

This course is not available for free users. Please purchase a subscription to enroll in this course and view its contents.

Upgrade
AppSumo badge

For Beginners

19 Tutorials

1 hour and 47 minutes

What to watch when you're just starting out using Google Sheets.

19Tutorials

FREE

Google Sheet Basics - The Absolute Basics
Let's start at the basics of Google Sheets. Where every beginner spreadsheet expert starts!
Beginner

1

FREE

Basics - Structure of a Sheet: Index() Row() and Column()
Let's figure out how a sheet is structured.
Beginner

2

Count How Many Subscribers In a Company by BetterSheets.co
I download it from MailChimp and then I try to figure out which companies are subscribed to me most. And I do, I have to figure out the domain and count the domain. And we're gonna do that all in Google Sheets.
Intermediate

FREE

4 Ways to Make a New Spreadsheet
Beginner

4

FREE

How To Select an Image based on Text in a Dropdown Menu
Create a schedule inside of Google Sheets.

5

FREE

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.

6

FREE

Facebook Ads Mockup Generator
Create a simple facebook ad mockup with image and primary text in a google sheet. Get character count too!
Beginner

7

Every Tab Has a Unique ID called GID
Less than 2 minute tip to help you link directly to a tab in a sheet. Each spreadsheet file has it's own unique id, a url. But also every tab has a unique "gid" that you can use to link directly to a tab in a sheet. Saving people a click.
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 create blank cells. In this video I'll show you the good reasons you want blank cells.

FREE

Basics - 5 Ways to Change Row Height
Beginner

10

FREE

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

11

FREE

Getting Started Coding in Apps Script
A short 10 minute video to get you started with Apps Script. Showing you menu: Extensions > Apps Script. And shows off how to write a function, do some math, manipulate some text. Members can get Spreadsheet Automation 101 in https://BetterSheets.co/courses
Beginner

12

Basic Keyboard Shortcuts To Speed Up Your Productivity
Beginner

FREE

Magical Numbering
Create a sequence of numbers that magically appears as you type in each row. Put this in A1 and start typing in column B: =SEQUENCE(COUNTA(B:B),1,1,1)
Beginner

14

Basic Keyboard Shortcuts To Speed Up Your Productivity - by BetterSheets.co
Learn some simple keyboard shortcuts.
Intermediate

FREE

6 Ways to Make Your Checkboxes Better
We're going to take a basic function of Google sheets, which is the checkbox, and we are going to take it to its nth degree.
Data validationBeginner

16

FREE

How to Make Hangman Game In Google Sheets
Create a game of hangman inside Google Sheets. Showcases a few functions like SEARCH()

17

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 magic on your sheets, you can use these formulas in existing sheets.
Intermediate

FREE

Merge Cells for Dashboards
to make better Dashboards consider merging cells.
Beginner

19