Google Sheets Tutorials · Better Sheets

How to Get Time from a Timestamp

Extract the time from a Google Sheets timestamp.

Beginner

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.

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

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

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

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

Spreadsheet Automation 101 Lesson 4: Access APIs Introduction

We’re getting data on movies and getting it into Google Sheets. Let’s create some magic inside Google Sheets!

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.

How to Use Sheets For Network Building

Using People Chips and Date Chips to make a quick network building list even faster. Great to integrate Sheets with Gmail like this. Makes building the list and doing follow up so much faster.

Beginner

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

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

Deep Inside Dark Habits Google Script

Go inside this apps script and sheet. See how it's designed and created.

ARRAYFORMULA() CONCATENATE() COUNTIF() FILTER() IFNA() +3 more

5 Ways to Create Coupon Codes | Create UUIDs

Generate Coupon Codes with 5 Levels of Difficulty - From Copy-Pasting to Advanced Google Sheets Formulas. Get up to thousands of unique codes easily! Watch now for coupon mastery inside of Google Sheets.

CHAR() DEC2HEX() MID() RANDBETWEEN()

Find the Start date of the Current and End date of the Current Month

We want to know, based on today's date, what is the start of the month and what's the date at the end of the month.

EOMONTH() TODAY()

Create a Sheet of Sheets for Project Management and/or Data Management

Create an epic organization sheet of all your spreadsheets. Unlock the secret to compiling all your scattered information into one easy-to-use sheet. Learn how to merge data from multiple tabs with this one-sheet solution. Perfect for creating summaries and dashboards. Get started now and streamline your workflow!

COUNT() INDIRECT() REPT() SPLIT() TRANSPOSE()

Displaying items 161-180 of 350 in total

TAGS

FORMULAS

TOPICS

350 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

How to Get Time from a Timestamp

Intro Video - Make Better Sheets

Great Sheets! Corona Hiring Sheet

How To Export Your Beautiful Sheets to PDF

Meet Asa: Ask Sheets Anything

Add Icons To Your Sheets With a Domain Name

Frustrated With Sheets New Dropdown Pills?

Better Sheets Videos Checklist

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

Pabbly Connect Countdown - "Sheet Improvement!"

Learn to Love Your Sheets

Spreadsheet Automation 101 Lesson 4: Access APIs Introduction

Sheet Review! 150 Active VCs by LemonIO

How to Use Sheets For Network Building

Better Numbers and Bullet Points in Your Spreadsheets

Get Data With Comments

Deep Inside Dark Habits Google Script

5 Ways to Create Coupon Codes | Create UUIDs

Find the Start date of the Current and End date of the Current Month

Create a Sheet of Sheets for Project Management and/or Data Management