Google Sheets Tutorials · Better Sheets

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

Make Your Headers Useful

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

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

5 Ways to use IF() Formula to Create Magic in Your Sheets

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.

Intermediate

AND() IF() IFS() ISBLANK() OR() +1 more

Better Header Fonts - Best Fonts To Use In Google Sheets

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

Use Row() For Math You Need to Iterate

Create easy to use math iterators with the ROW() formula. It tells you the row your cell is on, but why do you need that? you can iterate math equations! It's neat!

Beginner

ROW()

How to Write a Function - Learn to Code in Google Sheets Part 2

Continuing to show you how to write a function in Apps Script.

Beginner

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!

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

Use Cmd + Y To Do It Again, and Again, and Again

Very quick interesting little keyboard shortcut where you might not even know it exists. Repeat what you're doing, over and over again.

Beginner

Zunaid Asks: How to get Get Meta from URLS? Answer: Use ImportXML()

how would I do the following? In Google Sheets, it's in column A I have a list of URLs. For each of those URLs, I want to pull that URL's featured image and meta description, and put those in columns B and C. Here's how you do it. I just grabbed Wikipedia articles for this example.

Advanced

IMPORTXML()

Create a new Spreadsheet from just a Name in a Sheet.

Create the Apps Script to create a new sheet from some data inside your sheet. Script included in the sheet below.

Advanced

Use Min and Max for More Average Averages

What happens very often is we want to figure out an average averages, help us tell the story of a large set of data, but averages also can lie.

Beginner

AVERAGE() MAX() MEDIAN() MIN()

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

Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

Learn how to track every change in your Google Sheets with a simple custom function in this video on "What Changed." Discover how to compare sentences, paragraphs, and more with ease. Follow along as we create the function from scratch. Get ready to streamline your editing process!

We code a little apps script to figure out the difference between two cells.

Advanced

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

Take a list and make it Vertical, Using Split Join or RegexReplace

Create vertical lists in Google Sheets.

Beginner

JOIN() REGEXREPLACE() SPLIT() TRUE()

Create a Public Sheet and Private Sheet: Using ImportRange()

Stick around after the 1st portion of the video for bonus content.

Intermediate

FILTER() IMPORTRANGE()

Create a CPM Custom Function (Create Better Calculators!)

this is gonna be fun because we get to create a calculator with Apps Script.

Beginner

Displaying items 21-40 of 170 in total

TAGS

FORMULAS

TOPICS

170 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

3 Ways to Count in Google Sheets

Make Your Headers Useful

4 Ways to Make a New Spreadsheet

5 Ways to use IF() Formula to Create Magic in Your Sheets

Better Header Fonts - Best Fonts To Use In Google Sheets

Use Row() For Math You Need to Iterate

How to Write a Function - Learn to Code in Google Sheets Part 2

Spreadsheet Automation 101: Introduction to Pre-course Videos

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

How to Use Sheets For Network Building

Use Cmd + Y To Do It Again, and Again, and Again

Zunaid Asks: How to get Get Meta from URLS? Answer: Use ImportXML()

Create a new Spreadsheet from just a Name in a Sheet.

Use Min and Max for More Average Averages

Use Index Match when you want Vlookup

Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

Create a Radio Button From Checkboxes Using Google Apps Script

Take a list and make it Vertical, Using Split Join or RegexReplace

Create a Public Sheet and Private Sheet: Using ImportRange()

Create a CPM Custom Function (Create Better Calculators!)