Google Sheets Tutorials · Better Sheets

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

ChatGPT Clone in Google Sheets Part 2

We fix the problem of OpenAI's API not remembering our last questions. And we label the text as Human and AI. I also add an archive Chat and new Chat function to create a new chat fresh.

Advanced

That Viral Growing Plant Progress Chart

Create a growing flower pot from checkboxes with this bountiful formula combination. Members get free access to the sheet in the video.

Data validation Beginner

COUNTIF() IMAGE() SWITCH()

Better Sheets Videos Checklist

How to create a video checklist. Create a sheet with check boxes that you check off to mark the videos as seen. Great for those creating lead magnets or checklist digital products. Enables you to create a video course without having to download/upload any videos. Your users can keep track of their progress and get all the benefit of your knowledge.

Data validation Beginner

COUNTA() COUNTIF() FILTER() IFNA() SORT() +1 more

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

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a more elegant solution in Apps Script using JsDoc syntax to create an autocomplete native function. We use the formula combination of Concatenate / Round to create the ratio, but in Apps Script we do it a whole lot better.

Intermediate

CONCATENATE() ROUND()

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.

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

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

Announcing AtomicSheets.com

AtomicSheets.com for 10 Free Elements Members get it free at: https://bettersheets.co/products

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.

1 Simple Formula to Make Writing Tweets Easier or Make $1,000

Create a hook writing sheet with SUBSTITUTE(). Create an engine to write tweet upon tweet upon tweet. Bundle up 100 hooks/formats and sell it. Go ahead, make sweet tweets in a sweet sheet.

SUBSTITUTE()

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

Make a Better Template - Ambassador Nomination Template

Create a nomination or voting template. Looking to build better Google Sheets? Andrew from Better Sheets is here to help! Join his membership to access exclusive videos and email support. In this video, Andrew takes a closer look at a Google Sheet template by Tableau ambassador Adam Miko, offering tips and tricks for a better user experience. Save time and effort with Andrew's easy copy-and-paste method. Want more? Join his membership today and start building better Sheets!

Roast: Mortgage Calculator for Google Sheets

Reviewing an existing sheet called "mortgage calculator for Google sheets" I point out the really nice "back to dashboard" button. This seems like a minor point but ends up improving the user interface, and user experience. Users tend to get lost in sheets with tabs, and providing another path to a sheet you know your users will want to go to, is great. At the end of the video I point out that you probably want to provide more outputs than inputs. Meaning that if someone puts in a few numbers, they get out of it a few years of statistics, or calculations in this case. Calculators are cool, but generators are even better. Calculators have a tendency to have more inputs than outputs. You're trying to get to one magical result. But a spreadsheet can be so much more powerful and show many more outputs if you do those calculations,. Especially here for a mortgage, you can show a range of calculations in addition to a single calculation.

Building the Newsletter Geeks Virtual Mall

We're gonna create another virtual mall, and in this one we're gonna make it for newsletters

Advanced

CONCATENATE()

Build a Domain Grader

Create a way to grade the quality of a domain based on many different votes and inputs and qualities. Like measuring the length and ranking the results.

ARRAYFORMULA() CONCAT() COUNTA() COUNTIF() LEN() +1 more

Dark Mode / Better Font Color

While the desktop version of Google Sheets does not have a dark mode, doesn't mean we can't make it ourselves. Create dark mode in one click. You'll learn to make a dark mode toggle.

Intermediate

How Do I Make a CSV File? And give a link to someone instead of the csv.

Create a link to your sheet that immediately download the sheet as a CSV file. Great for sending exports as a link.

Add Cool Responsive Graphs to Your Stock Tracking Sheets

Create little graphs with SPARKLINE() super easy!

GOOGLEFINANCE() INDEX() SPARKLINE() TODAY()

Displaying items 141-160 of 205 in total

TAGS

FORMULAS

TOPICS

205 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Ken Asks: Can We Add Star Ratings?

ChatGPT Clone in Google Sheets Part 2

That Viral Growing Plant Progress Chart

Better Sheets Videos Checklist

Search for Photos in a Google Sheet

Calculate ROAS in Google Sheets

Intro Video - Make Better Sheets

How To Export Your Beautiful Sheets to PDF

How to Make Hangman Game In Google Sheets

Announcing AtomicSheets.com

Sheet Review of 50 ChatGPT Prompts

1 Simple Formula to Make Writing Tweets Easier or Make $1,000

5 Ways To Use Google Sheets for Advanced Project Management

Make a Better Template - Ambassador Nomination Template

Roast: Mortgage Calculator for Google Sheets

Building the Newsletter Geeks Virtual Mall

Build a Domain Grader

Dark Mode / Better Font Color

How Do I Make a CSV File? And give a link to someone instead of the csv.

Add Cool Responsive Graphs to Your Stock Tracking Sheets