Google Sheets Tutorials · Better 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.

Create an Auto-Update Sales Chart: Trailing 12 Months

how to create an auto-updating sales chart that displays the trailing 12 months of data in Google Sheets. The tutorial uses a sample dataset to demonstrate how to build a dynamic chart that updates automatically as new data is added.

Intermediate

COUNTA() IF() INDEX() ISBLANK() SUM()

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.

Better Numbers and Bullet Points in Your Spreadsheets

Improve Google Sheets Readability
Improve the readability of your spreadsheets and supercharge your productivity with our top tips for better numbering and bullet points in Google Sheets.

Create Visually Appealing Sheets
Discover how to create clear, concise, and visually appealing spreadsheets that engage your audience and get results! Make your lists spicy hot with numbering and bullet points. Learn how to execute this to make your sheets look better.

Understanding the Importance of Readability in Spreadsheets Readability is crucial when it comes to spreadsheets. It refers to how easy it is for your audience to read and understand the data you are presenting. If your spreadsheet is cluttered, confusing, and hard to read, your audience will quickly lose interest and may not be able to make informed decisions based on the data you are presenting.

The Benefits of Using Bullet Points and Numbering in Spreadsheets
Using bullet points and numbering in spreadsheets can help to improve readability by breaking down complex information into more manageable pieces. Here are some of the benefits of using these features:

Bullet points and numbering help to organize information in a logical and easy-to-follow way
They make it easier to scan and find important information quickly
They can help to emphasize key points and make them stand out from the rest of the data
They make your spreadsheet look more visually appealing and professional

Beginner

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

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

Get Data With Comments

A great way to manage your data if you have a small group of people who want to add data, but you want control over that data in the sheet. Give them the ability to comment on your data.

Beginner

Create a new Spreadsheet from just a Name in a Sheet.

Create the Apps Script to create a new sheet from some data inside your sheet. Script included in the sheet below.

Advanced

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.

Show Sheet Tabs Based on Edit

Show a sheet or tab based on a code being entered in one sheet.

Intermediate

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.

Intermediate

Sheet Improvement: Electric Vehicle Stock Tracker by evuniverse.io

An epic sheet improved in under one hour. Watch this video to see me revamp a Google Sheet and Take it to the Next Level! Discover the Secrets to Improving this EV Universe Sheet, Including Customized Colors, Easy Navigation and Valuable Updates.

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

Pabbly Connect Countdown - "Sheet Improvement!"

Create a countdown timer inside of a google sheet. Unlock the secret to a lifetime deal... TIMEI! Discover their amazing live Google sheet and join the countdown to their exclusive offer. Watch as we recreate and enhance their sheet with stunning colors. Don't miss out on this epic journey. Click now!

Learn to Love Your Sheets

Quick intro to a better experience of using Google Sheets

Beginner

ARRAYFORMULA() IMPORTRANGE()

Sheet Review! 150 Active VCs by LemonIO

This lead magnet by the folks at Lemon.io is incredibly useful. 150 active VCs. I checked out their page and was like WHOA, what a site! In this video I turned their google sheet into an extension of their branding.

Data Validation with Formulas

The issues you might run into validating data and 4 formulas you can use to create workflows or processes in sheets. Covering: ISBLANK, ISFORMULA, ISURL, ISTEXT formulas.

Intermediate

IF() ISBLANK() ISFORMULA() ISTEXT() ISURL()

Turn Data in Many Columns Into 1 Column

How to turn many columns into one column.

Beginner

Transform Information Into an Info Product

Transform your information into a money-making machine! Learn how to turn your data into an info product using Google Sheets. Easy steps to follow. Boost your business now! We are selling a Google sheet here. We're selling information, we're selling curation, we're selling the time and the effort and the energy and the focus around, uh, this kind of information that of course information is free online. But we'll make it better.

Intermediate

Displaying items 161-180 of 367 in total

TAGS

FORMULAS

TOPICS

367 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Intro Video - Make Better Sheets

Create an Auto-Update Sales Chart: Trailing 12 Months

How To Export Your Beautiful Sheets to PDF

Meet Asa: Ask Sheets Anything

Better Numbers and Bullet Points in Your Spreadsheets

Ken Asks: Can We Add Star Ratings?

Add Icons To Your Sheets With a Domain Name

Get Data With Comments

Create a new Spreadsheet from just a Name in a Sheet.

Sheet Review of 50 ChatGPT Prompts

Show Sheet Tabs Based on Edit

Frustrated With Sheets New Dropdown Pills?

Sheet Improvement: Electric Vehicle Stock Tracker by evuniverse.io

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

Pabbly Connect Countdown - "Sheet Improvement!"

Learn to Love Your Sheets

Sheet Review! 150 Active VCs by LemonIO

Data Validation with Formulas

Turn Data in Many Columns Into 1 Column

Transform Information Into an Info Product