Google Sheets Tutorials · Better Sheets

Create a Progress Bar - Make Progress Bars with Sparkline: Part 1

Let's make a progress bar in Google Sheets.

SPARKLINE()

Create a Self-Adding Dropdown Menu

Make a dropdown menu inside Google Sheets you can add to anything and it makes it available in the dropdown.

Create Hundreds of Tweets in a Google Sheet

Write tweets fast! Create hundreds of tweets in a Google sheet with ease and tweet each other's tweets! Learn how to do it with our step-by-step guide

Create Drop Shadows! This makes your dashboards pretty.

Add extra pizzazz. a little more snazz to your sheets. Make dashboards with very flexible drop shadows. A great google Sheet trick for any occasion.

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.

Create a Guess The Number Game | Challenge!

Use random number generators to make a number guessing game.

Intermediate

RAND() ROUND()

Create a Podcast Advertising Calculator

Build from scratch a calculator to figure out podcast advertising rates.

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

Create an Email Campaign Stats Calculator

Take your email marketing to the next level with our Google Sheet Campaign Stats Calculator. Analyze open rates, click-throughs, and conversions, and make data-driven decisions to improve your campaigns. Build a sheet from scratch. We're going to build a calculator, with some functions and some custom functions in apps script. We'll also design the sheet like a funky dashboard.

Advanced

CONCATENATE() ROUNDDOWN() UPPER()

Creating A Dark Mode Theme | Announcing Dark Habits

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.

New Syntax for WhatChanged Formula in Google Script

revisiting the "what changed" custom function I built in a past video. Showing you more apps script

Advanced

Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

Learn how to track every change in your Google Sheets with a simple custom function in this video on "What Changed." Discover how to compare sentences, paragraphs, and more with ease. Follow along as we create the function from scratch. Get ready to streamline your editing process!

We code a little apps script to figure out the difference between two cells.

Advanced

Create a Radio Button From Checkboxes Using Google Apps Script

Let's code a Radio button that turns off all checkboxes except the one clicked.

Data validation Advanced

IFS() NOT() OR()

Create a Summary Tab with Min and Max

Free tutorial for finding Minimum and Maximum data points.

Intermediate

INDEX() MAX() MIN()

How To Create An AutoFill in Google Sheets

Autofill inside of google sheets is possible with Dropdowns.

Beginner

INDEX() MATCH() VLOOKUP()

Insert Random New Quotes in Your Google Sheets (Every Edit/Open)

Discover the Secret Formula to Insert a Quote Randomizer in Your Sheet! | Learn how to use a simple one-formula combo to get a random assortment of quotes in your sheet. Change the quote every time you open the sheet. Watch now and amaze your friends!

How to insert a quote generator or a quote randomizer inside your sheet. Without using Apps Script.

Beginner

COUNTA() INDEX() RAND() ROUND()

Create a Public Sheet and Private Sheet: Using ImportRange()

Stick around after the 1st portion of the video for bonus content.

Intermediate

FILTER() IMPORTRANGE()

Create a PR Agency From Scratch

Go from nothing to a working PR agency. Capture sites, and Send email via script

Intermediate

ARRAYFORMULA() FILTER() JOIN() SPLIT()

Escape Spreadsheet Hell A Mini Game

Free min game to learn 3 keyboard shortcuts, get it at https://kampheyapproved.gumroad.com/l/escapespreadsheethell

Beginner

Spreadsheet Automation 101: Variables

Dive deeper into the world of variables. Learn what variables do. Learn how to assign information to variables.

Displaying items 41-60 of 199 in total

TAGS

FORMULAS

TOPICS

199 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Create a Progress Bar - Make Progress Bars with Sparkline: Part 1

Create a Self-Adding Dropdown Menu

Create Hundreds of Tweets in a Google Sheet

Create Drop Shadows! This makes your dashboards pretty.

Intro Video - Make Better Sheets

Create a Guess The Number Game | Challenge!

Create a Podcast Advertising Calculator

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

Create an Email Campaign Stats Calculator

Creating A Dark Mode Theme | Announcing Dark Habits

New Syntax for WhatChanged Formula in Google Script

Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

Create a Radio Button From Checkboxes Using Google Apps Script

Create a Summary Tab with Min and Max

How To Create An AutoFill in Google Sheets

Insert Random New Quotes in Your Google Sheets (Every Edit/Open)

Create a Public Sheet and Private Sheet: Using ImportRange()

Create a PR Agency From Scratch

Escape Spreadsheet Hell A Mini Game

Spreadsheet Automation 101: Variables