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

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreadsheet expert starts!

Beginner

Wordle in a Google Sheet | Work in Progress

Building a clone of Wordle inside Google Sheets.

Intermediate

COLUMN() IF() INDEX() MID() TEXT()

Redirect a Domain to a Google Sheet

Learn how to redirect a domain to a google sheet. Set up subdomains and MVPs of sites easily.

Beginner

Most Common Errors and How To Handle Them in Google Sheets

Today we're gonna talk about errors in Google Sheets and how you can fix them. #N/A, #ERROR, #REF!, #NAME?, #DIV/0

Beginner

CONCATENATE() VLOOKUP()

Add Pics to Marketplace in a Google Sheet

Add pictures to your marketplace inside a google sheet. Might be great for garage sales, and community events.

Beginner

FILTER() IMAGE() INDEX() MATCH()

How do I Insert Emojis into Google Sheets?

Using Control+Command+Space in inserting emojis into Google Sheets.

Beginner

How To Create An AutoFill in Google Sheets

Autofill inside of google sheets is possible with Dropdowns.

Beginner

INDEX() MATCH() VLOOKUP()

Twitter App Clone in a Google Sheet

I built a twitter clone in Google Sheets

Beginner

Naughty or Nice? - Google Sheets' New Dropdown Chips

Google Sheets has a new way to do dropdowns. Is it naughty or nice?

Learn Google Sheet Formulas The Hard Way

One weird way to learn more about what Google Sheets can do. https://bettersheets.co/formulas

Better Google Ad Writing Tool Sheet Makeover

Got an amazing tool from Inside Google Ads course by Jyll. She shares this tool, and I went for 30 minutes reviewing it, improving it, and redesigning it. Hope members can learn from this video. Jyll graciously allows me to share this sheet with members only!

CONCATENATE() IF() ISBLANK() LEN()

5 Ways To Use Google Sheets for Advanced Project Management

Here are 5 advanced ways to manage projects inside of Google Sheets Manage Task Flow with IF() and a Checkbox Manage Data Inputs with IF() and ISBLANK() Create Quick Dashboard headers with: Transpose / Unique Create Pickers with Index / Match Email reports with Apps Script

Intermediate

COUNTIF() FILTER() IF() INDEX() ISBLANK() +3 more

How To Add Columns in Google Sheets

Do you know all the ways to add columns to your Google Sheets?

Beginner

Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!

Turning a drab sheet into a fab sheet. Transform your job search with this amazing job application tracker template! Get it now from the Land of Random newsletter and streamline your job hunt.

Troubleshooting Bitly in a Google Sheet Script

Exclusive video only for Better Sheets members. This is, uh, troubleshooting your click tracking web app or slash sheet.

Advanced

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.

Make a New Sheet - Best Practices

Create a new sheet and do it well.

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

Add a Word Count to Google Sheets

Count your words inside a sheet. Great for ad writing, novel writing, or if you need to meet minimums.

COUNTA() IF() ISBLANK() SPLIT()

Displaying items 61-80 of 345 in total

TAGS

FORMULAS

TOPICS

345 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

3 Ways to Count in Google Sheets

Google Sheet Basics - The Absolute Basics

Wordle in a Google Sheet | Work in Progress

Redirect a Domain to a Google Sheet

Most Common Errors and How To Handle Them in Google Sheets

Add Pics to Marketplace in a Google Sheet

How do I Insert Emojis into Google Sheets?

How To Create An AutoFill in Google Sheets

Twitter App Clone in a Google Sheet

Naughty or Nice? - Google Sheets' New Dropdown Chips

Learn Google Sheet Formulas The Hard Way

Better Google Ad Writing Tool Sheet Makeover

5 Ways To Use Google Sheets for Advanced Project Management

How To Add Columns in Google Sheets

Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!

Troubleshooting Bitly in a Google Sheet Script

Great Sheets! Corona Hiring Sheet

Make a New Sheet - Best Practices

Search for Photos in a Google Sheet

Add a Word Count to Google Sheets