79% OFF online library of tutorials for mastering Google Sheets

One time purchase $149

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

For Beginners

19 Tutorials

1 hour and 47 minutes

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

19Tutorials

Let's start at the basics of Google Sheets. Where every beginner spreadsheet expert starts!

1

Let's figure out how a sheet is structured.

2

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.
Create a schedule inside of Google Sheets.

5

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

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

7

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.
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.
you might actually find something new and interesting about it. We're just changing the column width.

11

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

12

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)

14

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.

16

Create a game of hangman inside Google Sheets. Showcases a few functions like SEARCH()

17

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.
to make better Dashboards consider merging cells.

19