Google Sheets Tutorials · Better Sheets

Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales

Analyze sales with COUNTUNIQUEIFS Formula.

Intermediate

COUNTA() COUNTUNIQUEIFS() FILTER() TEXT() UNIQUE()

What Sucks About Selling Spreadsheets And How to Solve These Problems

I go through a few of the darkest parts of selling spreadsheets and how you can fix them. I offer how to do updates that generate revenue and what marketplaces to sell on to avoid marketing into the void.

Advanced

You Should Know The Limitations of Data Validation

You should know the difference between Data Validation and Data Veracity (or truthfulness of data)
This video points out some incredibly simple concepts of Data Validation you may want to use in your Google Sheets to make your data analysis better.

Intermediate Beginner

Expense Tracker Template with Data Entry Form Inside Sheets

Create a data entry form for an expense tracker. Simple dashboard too with sum and sum between two dates.

Intermediate

FILTER() IFNA() SUM()

Creating a Custom URL Link for Your Spreadsheet

Create an apps script function that gets the url of your spreadsheet into a cell.

CONCAT() HYPERLINK()

Great Sheets! Corona Hiring Sheet

Reviewing a Corona hiring sheet. A great example of using Google Sheets. I have high praise for the design and the use of forms for data validation. The sheet makes great use of white space, circular image, and icons instead of text. While I suggest other ways to monetize the job board, I acknowledge the creator's decision to avoid exploiting the situation.

3 Ways to Count in Google Sheets

The video explains three ways to count cells or information in Google Sheets: using the Explorer, using the COUNT function, and using the COUNTALL function. The Explorer is a tool located at the bottom right of the screen that allows you to quickly understand your data and find the count of items in a column. The COUNT function allows you to count the number of cells that contain numbers in a range of cells, while the COUNTALL function counts all the cells in a range, including those that contain formulas or are blank. The video also mentions other functions such as SUM and UNIQUE

Beginner

COUNTA() COUNTIF()

Alejandro Asks: How do I Sum up Study hours from a Calendar Format?

A member, Alejandro, asks about taking their custom calendar inputs and figuring out study totals for a week. They created a beautiful input and just need to the calculations. I show how to use the data to do the calculations. If you've never used the FLATTEN() formula, this is a good example! And we use double UNIQUE().

FILTER() FLATTEN() SORT() SUM() UNIQUE()

Create an Auto-Update Sales Chart: Trailing 12 Months

how to create an auto-updating sales chart that displays the trailing 12 months of data in Google Sheets. The tutorial uses a sample dataset to demonstrate how to build a dynamic chart that updates automatically as new data is added.

Intermediate

COUNTA() IF() INDEX() ISBLANK() SUM()

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()

David Asks: About Primary Keys

Create relational databases with index/match. Discover the secret to efficient data management with primary keys! Learn how to sort, filter, and create tables based on unique identifiers in this expert video. Say goodbye to complicated spreadsheets and hello to easy data management.

Intermediate

INDEX() MATCH()

Concat Because Concatenate is too hard to Remember!

One more function beyond Concatenate and Join that is useful in so many different ways. Concat can be used to quickly create unique columns of data. But watch out for dates!

CONCAT() CONCATENATE() JOIN()

Embed a Number in a Website from a Google Sheet

Ever wanted to display some data from a google sheet on your site? Without using 3rd party tools here is the javascript, html and the sheet you will need. and step by step instructions on how to use it.

Advanced

Transform Information Into an Info Product

Transform your information into a money-making machine! Learn how to turn your data into an info product using Google Sheets. Easy steps to follow. Boost your business now! We are selling a Google sheet here. We're selling information, we're selling curation, we're selling the time and the effort and the energy and the focus around, uh, this kind of information that of course information is free online. But we'll make it better.

Intermediate

How to Name Sheet Tabs

Organize tabs appropriately to decrease the friction that other users will have when reading or using your spreadsheets.

Beginner

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

Search for Photos in a Google Sheet

This feature is really handy for designers who want to create notes around designs and mockups to showcase to clients. As a photographer, I can also use this to create a searchable sheet with keywords for my photos. You can even use screenshots instead of Unsplash photos like I'm using here. Basically, all you have to do is insert the images into cells and use V lookup to search for them using the ID numbers. You can use this to mock up a newsletter, test out different thumbnails as a YouTuber, or create a landing page or workflow for your business. It's really easy to change the photos by just changing the ID number.

VLOOKUP()

Unique Features - Design a Better Dashboard Part 2

We're gonna talk about some features that we're gonna be using that might be new to you, or, just remind you that we're gonna use them to make 'em very interesting and unique to, using dashboards.

Advanced

Quickstart Tutorial OpenAI API in Google Sheets

Use the power of OpenAI's GPT-3 inside of Google Sheets. In this quick start tutorial I show you how to take OpenAI's curl commands and change them into Apps Script to use GPT-3 inside of sheets. We write a tweet, we ask questions. And now you can use this power for greater good!

Benoit Asks: How to Convert Case

How can I use this function, lower, upper, or proper as a conditional formatting? And then the other question is, how can I use this to apply on a bunch of cells without having to double the cells?

ARRAYFORMULA() LOWER() PROPER() UPPER()

Displaying items 101-120 of 185 in total

TAGS

FORMULAS

TOPICS

185 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales

What Sucks About Selling Spreadsheets And How to Solve These Problems

You Should Know The Limitations of Data Validation

Expense Tracker Template with Data Entry Form Inside Sheets

Creating a Custom URL Link for Your Spreadsheet

Great Sheets! Corona Hiring Sheet

3 Ways to Count in Google Sheets

Alejandro Asks: How do I Sum up Study hours from a Calendar Format?

Create an Auto-Update Sales Chart: Trailing 12 Months

Tagging Titles, Create a Comma Separated List of Tags

David Asks: About Primary Keys

Concat Because Concatenate is too hard to Remember!

Embed a Number in a Website from a Google Sheet

Transform Information Into an Info Product

How to Name Sheet Tabs

Every Tab Has a Unique ID called GID

Search for Photos in a Google Sheet

Unique Features - Design a Better Dashboard Part 2

Quickstart Tutorial OpenAI API in Google Sheets

Benoit Asks: How to Convert Case