Google Sheets Tutorials · Better Sheets

Access Free API's with Google Sheets

Get Kanye Quotes, Hogwarts Houses, Public Holidays, and more fun with API's in this 1 hour dive into Free APis available online and accessible in Google Sheets.
API's here: freepublicapis.com

Intermediate

COUNTIF() IF() IMAGE() ISBLANK()

Study Better With Google Sheets

Made Ali Abdaal's study google sheet better.

Beginner

COUNTA() GOOGLETRANSLATE() INDEX() RANDBETWEEN() VLOOKUP()

Built a Cookie Clicker Clone in Google Sheets

I built a clone of Cookie Clicker, live on YouTube. Watch the full 1 hour live stream here.

In this video I update it a bit, and show off that it works!!

Learn how to build trigger builders and use user properties to store data you don't want a user to change (easily)

Advanced

How To Duplicate a Tab and Move it to the End in Google Sheets

Learn how to automate creating a template and moving the tab to the far right, or the end of the google sheets tabs.

Intermediate

Embed Email Form and Name Form into Website to Google Sheets

Add names to the Email2Sheet apps script and code.

Advanced

How to Create AI Images From Google Sheets

Use the Open AI API and Dall-e-3 to create image in Sheets

Intermediate

Write Email Subject Variations Fast! A Simple Google Sheets Automation

Create a simple automation for adding text to a cell of text. Really easy example is to create a lot of email subject lines from one single cell of text.

Beginner

IF()

Take Screenshots from URLs in Google Sheets

Use Screenshot One api to quickly get cached images of Screenshots and then go and download them. Check this out and let me know how you'd use it.

Intermediate

IMAGE()

Send a Button from Google Sheets in an Email

quick fun video to show you how to add a button to emails when you send emails from Google Sheets.

Intermediate

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

Headline Generator: Add Dropdowns

Create a headline generator inside Google Sheets. Add dropdown menus to make the generator easy to us.

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

2 New Ways To Add Emoji Reactions

Revolutionize the way you react with emojis! Discover two new methods to add emoji reactions and take your spreadsheets to the next level. Learn how to create a reaction clicker and a reaction picker to personalize your sheets with emojis. Don't miss out on this game-changing method in Google Sheets.

We're adding some emoji reactions to Google Sheets.

Figuring out the 80/20 Rule with a Running Sum Total

I figured out that 20% of my videos are getting 80% of the watch time on my YouTube channel, and I actually used a Google sheet to figure this out.

Beginner

SUM()

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.

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.

How To Export Your Beautiful Sheets to PDF

Want to create sleek, stunning PDFs from your Google Sheets? Look no further! Learn how to easily export your sheets to PDF format and impress your audience. Create a PDF from your Google Sheet.

Beginner

Meet Asa: Ask Sheets Anything

GPT3 Powered Answers to your spreadsheet questions. Ask sheets anything, literally any question about Google Sheets! This might put me out of a job as a Google Sheets Expert.

Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?

ow do I show the date and time for the last time something was changed in a sheet? So what's interesting is that this This shows you Google Sheets shows an version history up here and shows you the last edit, but sometimes we want to have that data available to us inside of the sheet.

NOW()

Sheet Review of 50 ChatGPT Prompts

Tips to help improve the look, feel, branding of Better Sheets Member’s Free Lead Magnet. A free Google Sheet of ChatGPT Templates that just gets better by the end of the video.

Displaying items 141-160 of 334 in total

TAGS

FORMULAS

TOPICS

334 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Access Free API's with Google Sheets

Study Better With Google Sheets

Built a Cookie Clicker Clone in Google Sheets

How To Duplicate a Tab and Move it to the End in Google Sheets

Embed Email Form and Name Form into Website to Google Sheets

How to Create AI Images From Google Sheets

Write Email Subject Variations Fast! A Simple Google Sheets Automation

Take Screenshots from URLs in Google Sheets

Send a Button from Google Sheets in an Email

Add a Checkbox to Turn on Dark Mode

Headline Generator: Add Dropdowns

Ken Asks: Can We Add Star Ratings?

2 New Ways To Add Emoji Reactions

Figuring out the 80/20 Rule with a Running Sum Total

Intro Video - Make Better Sheets

Great Sheets! Corona Hiring Sheet

How To Export Your Beautiful Sheets to PDF

Meet Asa: Ask Sheets Anything

Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?

Sheet Review of 50 ChatGPT Prompts