Google Sheets Tutorials · Better Sheets

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

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

Make Your Lists Spicy Hot in Google Sheets

Create fun funky bullet points to get your point across better. Put emojis in your sheets to bring them to life.

Beginner

CONCAT() ROW()

Create a Trello Board with Transpose Formula in Google Sheets

Use Transpose() to create a web-based, Kanban style, list-making application inside your Google Sheet! Learn how to display tasks and to-do’s in vertical categories.

How to Create a CRM in google sheets w/ Dashboard

Build a Customer Relationship Manager right inside a Google Sheet. Track your customers, your sales progress, and your revenue in an easy to create dashboard.

Create a Vote Button from Google Sites to Google Sheets

Connect your published Google Site to Google Sheets with Apps Script and a Button. Great to use for Voting, upvoting, NPS, or anything you want feedback on, at the click of a button from your Google site to a Google Sheet.

Intermediate

Create a Tracking Number Fetcher with Google Sheets and Google Sites

Build a tracking number google site with Google Sheets as a backend.

Advanced

How To Create An AutoFill in Google Sheets

Autofill inside of google sheets is possible with Dropdowns.

Beginner

INDEX() MATCH() VLOOKUP()

Create a Stop Watch in a Google Sheet

We'll create a stop watch from scratch. Including Apps Script. What it will do is when you click a button (a checkbox) in a sheet, the script on every edit will add a start or a stop time, then add another time and calculate the duration.

Convert Your Bullet Journal To Google Sheets

Find out how you can make your spreadsheets like a Bullet Journal. It's like a super powered Bullet Journal.

Beginner

VLOOKUP()

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 a Course Outline in Google Sheets

Wanted to share with members this course outline I am using for my own course making process. I outlined the course then added a bunch of cool little stats to help see my progress and keep me on a certain pace of video creation.

Beginner

CONCAT() CONCATENATE() COUNTA() COUNTIF() IF() +4 more

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our Add-on we'll be publishing to the Google Workspace Marketplace.

Creating a Live Message in Google Sheets

Sit back and enjoy this comprehensive tutorial on how to create a live message in Google Sheets. In this video, we dive deep into the process of live message creation, providing step-by-step instructions and practical examples. Whether you're a beginner or an experienced user, this tutorial will empower you to unleash the full potential of Google Sheets.

Intermediate

DarkSide of Google Sheets - Creating Dark Mode and Making it Better!

Create dark mode with Conditional Formatting.

Conditional Formatting Beginner

Create an Internal Google Sheets Add-on

The entire process to create and publish a Google Sheets Add-on internally to your own domain.

Intermediate

How to Create AI Images From Google Sheets

Use the Open AI API and Dall-e-3 to create image in Sheets

Intermediate

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

Create a click Edit: Google changed how the redirect is handled. It no longer automatically goes forward, so you will need to add a link for a user to click on again to go to the forwarded link.

Advanced

HYPERLINK()

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

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.

Displaying items 1-20 of 353 in total

TAGS

FORMULAS

TOPICS

353 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Better Numbers and Bullet Points in Your Spreadsheets

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

Make Your Lists Spicy Hot in Google Sheets

Create a Trello Board with Transpose Formula in Google Sheets

How to Create a CRM in google sheets w/ Dashboard

Create a Vote Button from Google Sites to Google Sheets

Create a Tracking Number Fetcher with Google Sheets and Google Sites

How To Create An AutoFill in Google Sheets

Create a Stop Watch in a Google Sheet

Convert Your Bullet Journal To Google Sheets

Create Hundreds of Tweets in a Google Sheet

Create a Course Outline in Google Sheets

Write Apps Script to Create a New Google Sheets Formula

Creating a Live Message in Google Sheets

DarkSide of Google Sheets - Creating Dark Mode and Making it Better!

Create an Internal Google Sheets Add-on

How to Create AI Images From Google Sheets

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

How to Make Hangman Game In Google Sheets

Roast: Mortgage Calculator for Google Sheets