Google Sheets Tutorials · Better Sheets

635 Google Sheet Tutorials

💡

An exclusive library of Google Sheet Tutorials

🚀: Efficient: Automation techniques to supercharge your workflow and automate repetitive tasks.
🎯: Precise: Ensure your data is always accurate and your analysis is clear.
🌈: Creative: Discover new ways to use Google Sheets.
❌: Can't Find a Video?: Members can reach out and ask me anything!

How To Track Crypto Prices

Get crypto prices into a Google Sheet.

Intermediate

GOOGLEFINANCE()

How To Color Cell Blocks So Others Enter Data Easily

Use neon blue to show where someone needs to enter data.

Beginner

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

So you want to download a Google Sheet as a CSV. Let's do it!

Beginner

Magical Things You Can do with Checkboxes in Google Sheets

Turn your sheets into web apps with interactive checkboxes. Make your sheets' UI better with more interaction.

Data validation Beginner

10 Google Sheets I Wish Someone Would Make

if you're looking for ideas on what sheets to make I think this video is going to be super, super helpful to you because I'm going to explain not just the sheet I want and what it does, but over the course of all of these, I think you'll get a sense of some really interesting ideas on how to make sheets that sell.

Advanced

Generate Hundreds of Business Names

Create business names quickly with this Google Sheets trick.

Create a Guess The Number Game | Challenge!

Use random number generators to make a number guessing game.

Intermediate

ROUND() RAND()

Roast: 363 Questions VCs Ask Founders

we got a pretty darn simple and sweet sheet here with funding. A lead magnet that is 363 questions that PCs investors ask startup founders.

Better Font Colors

While this advice and all well and good, try out Sheet Styles, a free Google Sheets Add-on that enables you to do this less contrast style in one click. https://sheet-styles.bettersheets.co/

Sheet Improvement: Better Business Idea Selection Framework

Got this template directly from AppSumo and improved upon it.

IFERROR() ARRAYFORMULA()

Ian Asks: How to sort dates by year/month (can't do with filter)

In Excel you actually have these options of sorting by year, by month, by date. But let's do it in Google Sheets.

Search Every Function in Google Sheets

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

Make Your Headers Useful

Today we're gonna talk about headers. I'm gonna give you three really cool ways to use your headers.

Hide Completed Bars - Make Progress Bars with Sparkline: Part 2

Use the IF() formula to hide completed bars and display messages instead of bars depending on the situation.

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.

Roasting Google Sheets Intro

Reviewing sheets. We're going to get through this whole coffee and we're going to get through a bunch of Google sheets.

Headline Generator: Add Dropdowns

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

Capitalize Each Word

Every word can be capitalized with this formula.

UPPER() LOWER() PROPER()

Add Cool Responsive Graphs to Your Stock Tracking Sheets

Create little graphs with SPARKLINE() super easy!

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

Find "Entry Number" for Bookmarklet

Followup to the Bookmarklet video. To help you find the entry number for each form field.

Displaying items 581-600 of 635 in total