Google Sheets Tutorials · Better Sheets

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

Intro Video - Make Better Sheets

Transform your Google Sheets game with Better Sheets tutorials! Learn how to create dynamic databases, design-friendly sheets, and more. Discover hidden formulas and tools, and even build your own. Don't miss out on leveling up your productivity. Create dynamic tools, revamp your skillset, and ultimately master Google Sheets like never before. Better Sheets platform offers more than just tutorials. There is a deep directory of every Google Sheets formula with links to step-by-step tutorials as well as blog posts and youtube videos. It's the ultimate resources to learn how to use formulas in Google Sheets. Every tutorial has listed categories and courses it's a part of. In addition to that any formula featured is listed. And you can click on any formula to see that formula in action in other tutorials on the Better Sheets platform. Watch this walkthrough of the Better Sheets platform.

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

Add a Checkbox to Turn on Dark Mode

Get ready to shake things up, formula fanatics! Learn how to add a dark mode button to your Google Sheets with this dead simple trick. Using conditional formatting and a custom formula, you can turn on dark mode with just one click. Don't miss out on this cool feature! Made this really quick dark mode click button. And I wanted to show you how I did it because it's dead simple, super simple. It's literally just using conditional formatting

Conditional Formatting Beginner

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

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 2x2 Priority Matrix

Boost Your Productivity with a Priority Matrix: Learn How to Prioritize Your Tasks and Achieve More! Join us in this different kind of video and discover the best tips and tools to create a two by two grid that helps you determine what's important and urgent. Perfect for daily planners, long-term projects, decision-making, gift-picking, and more! Don't miss out on this collaborative and time-saving approach!

Great use case for the formula combination of JOIN/FILTER.

FILTER() JOIN()

Roast: Mortgage Calculator for Google Sheets

Reviewing an existing sheet called "mortgage calculator for Google sheets" I point out the really nice "back to dashboard" button. This seems like a minor point but ends up improving the user interface, and user experience. Users tend to get lost in sheets with tabs, and providing another path to a sheet you know your users will want to go to, is great. At the end of the video I point out that you probably want to provide more outputs than inputs. Meaning that if someone puts in a few numbers, they get out of it a few years of statistics, or calculations in this case. Calculators are cool, but generators are even better. Calculators have a tendency to have more inputs than outputs. You're trying to get to one magical result. But a spreadsheet can be so much more powerful and show many more outputs if you do those calculations,. Especially here for a mortgage, you can show a range of calculations in addition to a single calculation.

How to Find Duplicates

Learn how to find duplicates with a simple formula in Google Sheets.

CONCATENATE() FILTER() IF() MATCH() ROW()

Create a Sheet of Sheets for Project Management and/or Data Management

Create an epic organization sheet of all your spreadsheets. Unlock the secret to compiling all your scattered information into one easy-to-use sheet. Learn how to merge data from multiple tabs with this one-sheet solution. Perfect for creating summaries and dashboards. Get started now and streamline your workflow!

COUNT() INDIRECT() REPT() SPLIT() TRANSPOSE()

Capitalize Each Word

Every word can be capitalized with this formula.

LOWER() PROPER() UPPER()

Hide Completed Bars - Make Progress Bars with Sparkline: Part 2

Use the IF() formula to hide completed bars and display messages instead of bars depending on the situation.

Search Every Function in Google Sheets

Built a useful tool to filter Google Sheet formulas based on keywords.

Add Character Count and Character Limit

I'm gonna show you how to make a character counter and then account characters. And then I'm also gonna show you how to make a limit. It's really simple. It's one formula and some conditional formatting

Beginner

LEN()

3 More Ways to Count in Google Sheets

Learn how to use CountBlank() and more counting formulas.

Beginner

COUNTBLANK() COUNTIFS() COUNTUNIQUE()

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

How to Refer to Other Cells - A1 and R1C1 Explained

Get down to basics of spreadsheets.

Beginner

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Make your Google Sheets visually appealing and easier to understand with our expert tips on using gridlines, border styles, and colors. Learn how to create a professional-looking spreadsheet that effectively communicates your data to your audience. Boost your productivity today! We're gonna be talking about how to communicate better with grid lines, border styles, and border colors. Really interesting thing happens when you hide grid lines. You lose the grid, and I'll show you how to add that in. And some really interesting things you can do with different styles of border.

Beginner

Switch Data

We're going through the switch formula because in the past if I've ever had to change, say a day of the week or a month on the calendar to a number, or I have to change that number to the month or text, it's really hard.

Intermediate

SWITCH() VLOOKUP()

Displaying items 81-100 of 126 in total

TAGS

FORMULAS

TOPICS

126 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Creating a Custom URL Link for Your Spreadsheet

Intro Video - Make Better Sheets

Use Index Match when you want Vlookup

Add a Checkbox to Turn on Dark Mode

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

Calculate ROAS in Google Sheets

Create a 2x2 Priority Matrix

Roast: Mortgage Calculator for Google Sheets

How to Find Duplicates

Create a Sheet of Sheets for Project Management and/or Data Management

Capitalize Each Word

Hide Completed Bars - Make Progress Bars with Sparkline: Part 2

Search Every Function in Google Sheets

Add Character Count and Character Limit

3 More Ways to Count in Google Sheets

How to Find Duplicates and create a Duplicate Detector

How to Refer to Other Cells - A1 and R1C1 Explained

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Switch Data