Google Sheets Tutorials · Better Sheets

Create a Trello Board with Transpose Formula in Google Sheets

Use Transpose() to create a web-based, Kanban style, list-making application inside your Google Sheet! Learn how to display tasks and to-do’s in vertical categories.

Sheet Improvement: Better Band Bureau Better Schedule

A few tips: Delete extra columns and rows to improve readability, change the colors and fonts to incorporate branding, and adjust the sheet to promote the Better Band Bureau podcast more.

Dashboard Principles - Design a Better Dashboard Part 1

One of the best examples of a dashboard I got from a great talk on just totally like SASS dashboards, and they talked about the speedometer and why the speedometer is such a great dashboard is that it is it encapsulates all of the principles of what goes into a great dashboard.

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

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

Create awesome progress bars with sparkline formula. You can make progress bar colors can change based on the input.

Intermediate

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

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

Use Index Match when you want Vlookup

If you find Vlookup a difficult formula to understand, this formula combination might be better. It's also much more flexible than Vlookup. Index/Match is the best. It's one of my favorite formula combinations.

Intermediate

INDEX() MATCH() MAX() VLOOKUP()

Added Categories to 100 Twitter Templates Template

Add one more feature to the 100 Twitter Templates tool.

Intermediate

Ken Asks: How can I count true and false? Answer: w/ CountIF()

the answer is if you have a column of true or false you can use the count if statement argument formula. That's just count if, and then you say your range, and then comma, true. Or false, whichever one you want and you'll get a count.

Beginner

COUNTIF()

Create a Radio Button From Checkboxes Using Google Apps Script

Let's code a Radio button that turns off all checkboxes except the one clicked.

Data validation Advanced

IFS() NOT() OR()

Adding Number and dot to rank or order lists

This is like one of those things that is incredibly frustrating about Google Sheets. I will tell you right now. It is the simplest, stupidest solution

Beginner

CONCAT() ROW()

Find the Start date of the Current and End date of the Current Month

We want to know, based on today's date, what is the start of the month and what's the date at the end of the month.

EOMONTH() TODAY()

Wallace Asks: How To Find New Names

Got a list of names, need to add new ones to main list.

ARRAYFORMULA() IF() IFERROR() ISBLANK() MATCH()

Extract URLs from Google Sheets

When you can't get the url of a hyperlinked cell, do this instead.

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

Learn to Code in Google Sheets, For Programmers

Google Sheets uses a scripting language called Google Apps Script, which is based on JavaScript. If you know how to code in JavaScript, you'll find Google Apps Script very familiar. To get started, open a new Google Sheet and go to the "Extensions" menu, then click "Apps Script".

Intermediate

IMAGE()

Why Code in Google Sheets? - Learn to Code in Google Sheets Part 1

welcome to part one of Learn to Code in Google Sheets. In this video, we're gonna get started to code.

Beginner

Google Sheets Error: Unknown Range Name and How to Fix it

Unknown Range Name means we've typed in a formula the wrong format of a sheet name. I show you how to fix that and some other errors that might pop up.

Beginner

Spreadsheet Automation 101: Camel Case

Learn the importance of camel case. Camel Case is a simple technique that involves capitalizing the first letter of each word in a text string, except for the first word. This creates a consistent and easily readable format for text that may be used in formulas, labels, or other applications.

Spreadsheet Automation 101 Lesson 3: Email Other People For Loop

Send the same email to different people by using the same Four Loop to figure out which ones we’re sending. Do cool things with this Mail App and email system.

Displaying items 81-100 of 112 in total

TAGS

FORMULAS

TOPICS

112 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Create a Trello Board with Transpose Formula in Google Sheets

Sheet Improvement: Better Band Bureau Better Schedule

Dashboard Principles - Design a Better Dashboard Part 1

Ken Asks: Can We Add Star Ratings?

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

Search for Photos in a Google Sheet

Use Index Match when you want Vlookup

Added Categories to 100 Twitter Templates Template

Ken Asks: How can I count true and false? Answer: w/ CountIF()

Create a Radio Button From Checkboxes Using Google Apps Script

Adding Number and dot to rank or order lists

Find the Start date of the Current and End date of the Current Month

Wallace Asks: How To Find New Names

Extract URLs from Google Sheets

David Asks: About Primary Keys

Learn to Code in Google Sheets, For Programmers

Why Code in Google Sheets? - Learn to Code in Google Sheets Part 1

Google Sheets Error: Unknown Range Name and How to Fix it

Spreadsheet Automation 101: Camel Case

Spreadsheet Automation 101 Lesson 3: Email Other People For Loop