Google Sheets Tutorials · Better Sheets

Search for Photos in a Google Sheet by Keyword

Add one more feature to our Photo search inside of Google Sheets.

Beginner

Optimize SEO with Google Sheets and Google Search Console

Use Google Sheets to quickly find pages we can optimize. Using data directly from Google Search Console. Also check out the simple formula combination: AND() with IF()

Beginner

AND() FILTER() IF() SORT()

Search Every Function in Google Sheets

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

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

Make Unsplash in a Google Sheet w/ BuyMeACoffee - Part 1

Create a photo search site inside with Google Sheets. Using this template you can empower users to: Enter a search term and get an image without leaving the sheet! And learn how to monetize this Google Sheet.

How to Make Hangman Game In Google Sheets

Learn to create a fun game called Hangman in Google Sheets with Better Sheets. Watch the video to challenge yourself and see how it works. What other games can you make inside of Google Sheets? Create a game of hangman inside Google Sheets. Showcases a few Google Sheet formulas like SEARCH()

COUNTA() IF() IFERROR() JOIN() LEN() +1 more

User Filter a Google Sheet Database based on Dates, Checkboxes, Dropdown!

Search through and filter data to get what you want, when you want it. Tired of sifting through endless rows and columns? Learn how to filter your Google Sheet database with dates, checkboxes, and dropdowns. Simplify your workflow today!

Beginner

FILTER() IF()

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

There was a stories craze. Every app/platform/business was adding 24 hour lasting videos to their users accounts. Now you can do that with Google sheets.

CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more

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

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

Create a click Edit: Google changed how the redirect is handled. It no longer automatically goes forward, so you will need to add a link for a user to click on again to go to the forwarded link.

Advanced

HYPERLINK()

Make Unsplash in Google Sheets - Part 2

Fix the case sensitive search with lower(). Add quick links to prefilled results. Create another sheet with ImportRange().Protect the sheet from unnecessary edits.

Create A Video Course in a Google Sheet | LMS in a Google Sheet

Set up a list of video links, and a checklist for others to use.

Conditional Formatting Data validation Intermediate

COUNTA() COUNTIF() IF() SPARKLINE()

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Learn about triggers, hourly, daily, weekly, etc.

Intermediate

Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5

Now that we have a script that we wanna run every day, how do we run this? This is a key part of programming. It's like Cron Jobs in Apps Script

Advanced

Sheet Styles A Free Google Sheet Add-on by Better Sheets

Install Sheet Styles now: https://sheet-styles.bettersheets.co/

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

Ali Abdaal's Google Sheet | Year at a Glance

Ali gave away a free Google Sheet Template. In this tutorial I step through making it better, with better fonts, and colors. As well as making it more branded to share Ali's brand message better as the sheet gets copied and used, and shared. Great tutorial for those wondering how to brand your own sheets. Make your own lead magnets, and share your brand's message via Google Sheets.

Beginner

From Sheet to Script And Back Again - Learn to Code In Google Sheets Part 3

In this video, I'm going to share with you how to go basically from sheet to script and then back to the sheet again.

Beginner

Copy That, From One Sheet to Another - Learn to Code in Google Sheets Part 4

Learn to code in sheets. Automate Your Daily Sales Report with Google Sheets: Learn how to create a script that copies data from one sheet to another, including timestamps. Boost your productivity with this easy guide!

Advanced

NOW()

Wrap Your Mind Around This - Learn to Code in Google Sheets Part 6

this completes learn to code in Google Sheets and I wanted to finish off by giving you a few more quick concepts that expands your mind of what Google Sheets can do.

Advanced

Displaying items 1-20 of 319 in total

TAGS

FORMULAS

TOPICS

319 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Search for Photos in a Google Sheet by Keyword

Optimize SEO with Google Sheets and Google Search Console

Search Every Function in Google Sheets

Search for Photos in a Google Sheet

Make Unsplash in a Google Sheet w/ BuyMeACoffee - Part 1

How to Make Hangman Game In Google Sheets

User Filter a Google Sheet Database based on Dates, Checkboxes, Dropdown!

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

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

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

Make Unsplash in Google Sheets - Part 2

Create A Video Course in a Google Sheet | LMS in a Google Sheet

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5

Sheet Styles A Free Google Sheet Add-on by Better Sheets

Learn to Code in Google Sheets, For Programmers

Ali Abdaal's Google Sheet | Year at a Glance

From Sheet to Script And Back Again - Learn to Code In Google Sheets Part 3

Copy That, From One Sheet to Another - Learn to Code in Google Sheets Part 4

Wrap Your Mind Around This - Learn to Code in Google Sheets Part 6