Google Sheets Tutorials · Better Sheets

Ken Asks: Can We Add Star Ratings?

One common feature that users often request is the ability to add star ratings to their spreadsheets. While this feature is not built into Google Sheets, it is possible to create a star rating system using emojis and data validation.

Beginner

AVERAGE() SWITCH() VLOOKUP()

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 and or inside of an if and what happens is we want to use this when we want an if formula to have multiple criteria.

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 and or inside of an if and what happens is we want to use this when we want an if formula to have multiple criteria.

Beginner

AND() IF() OR()

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

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.

Make Your Headers Useful

Today we're gonna talk about headers. I'm gonna give you three really cool ways to use your headers.

How to Find Duplicates and create a Duplicate Detector

Create a duplicate detector with a few google sheet formulas.

Beginner

CONCATENATE() COUNTA() IF() MATCH() ROW() +1 more

Find Keywords in Any Column. Create quick search dropdown to find keywords

Create a quick search dropdown to find keywords in any column.

Intermediate

How to Create a CRM in google sheets w/ Dashboard

Build a Customer Relationship Manager right inside a Google Sheet. Track your customers, your sales progress, and your revenue in an easy to create dashboard.

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

Create a Headline Generator

Learn to create lead magnet or sellable worksheets for your business. Included are more topic ideas so you can take this template and run with it.

Better Header Fonts - Best Fonts To Use In Google Sheets

Find out what fonts to use to make your headers better.

Create a Timer with Apps Script

Create a start time and end time and duration of that, with a little bit of Apps Script.

Intermediate

IF() ISBLANK()

Spreadsheet Automation 101: Introduction to Pre-course Videos

Learn how to automate spreadsheets with Apps Script. The pre-course videos equip you with the fundamentals of coding before you start.

Spreadsheet Automation 101 Lesson 1: onOpen() Trigger - Custom Menu

This lesson will get you started on your first trigger. It’s the first real spreadsheet automation you can do. Fun stuff!

Create a Stop Watch in a Google Sheet

We'll create a stop watch from scratch. Including Apps Script. What it will do is when you click a button (a checkbox) in a sheet, the script on every edit will add a start or a stop time, then add another time and calculate the duration.

How to Use Sheets For Network Building

Using People Chips and Date Chips to make a quick network building list even faster. Great to integrate Sheets with Gmail like this. Makes building the list and doing follow up so much faster.

Beginner

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a more elegant solution in Apps Script using JsDoc syntax to create an autocomplete native function. We use the formula combination of Concatenate / Round to create the ratio, but in Apps Script we do it a whole lot better.

Intermediate

CONCATENATE() ROUND()

Create a Progress Bar - Make Progress Bars with Sparkline: Part 1

Let's make a progress bar in Google Sheets.

SPARKLINE()

Create a Self-Adding Dropdown Menu

Make a dropdown menu inside Google Sheets you can add to anything and it makes it available in the dropdown.

Displaying items 41-60 of 238 in total

TAGS

FORMULAS

TOPICS

238 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Ken Asks: Can We Add Star Ratings?

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

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

Search for Photos in a Google Sheet

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

Make Your Headers Useful

How to Find Duplicates and create a Duplicate Detector

Find Keywords in Any Column. Create quick search dropdown to find keywords

How to Create a CRM in google sheets w/ Dashboard

4 Ways to Make a New Spreadsheet

Create a Headline Generator

Better Header Fonts - Best Fonts To Use In Google Sheets

Create a Timer with Apps Script

Spreadsheet Automation 101: Introduction to Pre-course Videos

Spreadsheet Automation 101 Lesson 1: onOpen() Trigger - Custom Menu

Create a Stop Watch in a Google Sheet

How to Use Sheets For Network Building

Calculate ROAS in Google Sheets

Create a Progress Bar - Make Progress Bars with Sparkline: Part 1

Create a Self-Adding Dropdown Menu