Google Sheets Tutorials · Better Sheets

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

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

Spreadsheet Automation 101 Lesson 4: UrlFetchApp

Use any URL to scrape the web or access an API and get that info into your Google Sheet.

Spreadsheet Automation 101 Lesson 4: OmdbAPI get ApiKey, get Data in URL

Capture data from OMDb in our Google Sheets with a free API Key. It’s easier than it sounds. Let’s do this!

Spreadsheet Automation 101 Lesson 4: JSON (beautifier) and OmdbAPI parameters

Learn how we get information out of a JSON response. I’ll even show you how you can bring in some cool images in Google Sheets!

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.

This Seems Like Automation

4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.

FILTER() FLATTEN() IF() IFERROR() TRANSPOSE() +1 more

Add Icons To Your Sheets With a Domain Name

Add visual flair to your Google Sheets when sharing company domain information. You’ll learn how to use an undocumented Google API. ( Easier than you think!)

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.

Frustrated With Sheets New Dropdown Pills?

3 options to show dropdowns. It looks actually much closer to Airtable, but some people don't want this some sheets sort of fanatics, enthusiasts, people who love Google Sheets and don't really want to look.

TAGS

FORMULAS

TOPICS

347 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

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

Take Screenshots from URLs in Google Sheets

Send a Button from Google Sheets in an Email

Spreadsheet Automation 101 Lesson 4: UrlFetchApp

Spreadsheet Automation 101 Lesson 4: OmdbAPI get ApiKey, get Data in URL

Spreadsheet Automation 101 Lesson 4: JSON (beautifier) and OmdbAPI parameters

Intro Video - Make Better Sheets

Great Sheets! Corona Hiring Sheet

How To Export Your Beautiful Sheets to PDF

Meet Asa: Ask Sheets Anything

This Seems Like Automation

Add Icons To Your Sheets With a Domain Name

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

Sheet Review of 50 ChatGPT Prompts

Frustrated With Sheets New Dropdown Pills?

How to Download a Sheet as a CSV with a URL only