Google Sheets Tutorials · Better Sheets

Email Certain Department Based on Google Form Entries

Message a certain department when google form is submitted.

Advanced

SearchLord: One Sheet to Search Them All

I created a new product called SearchLord. It's free for now and really fun to search multiple sites with 1 key word, or 1 phrase. Free for everyone at bettersheets.co/sheetlord

In this video I add 1 more feature to SearchLord to show you how to use a FILTER() function. And we add a custom menu with a little quick apps script function.

Intermediate Beginner

ENCODEURL() FILTER() IFNA() SUBSTITUTE()

How To Format Sheets for Notes

Create sortable notes in Three ways.
1. By adding the original word over and over again
2. Adding notes all in one cell with CMD + ENTER for new lines
3. Use Apps Script to sort the A column even with groups of rows.

Spreadsheet Automation 101 Lesson 2: Arrays

Learn the basics of Arrays – how to create one, how to reference rows and columns of data in a different way, and how to get an entire column or row in Apps Script.

Spreadsheet Automation 101 Lesson 1: Spreadsheet Taxonomy

Learn about the strategy and concept of the SpreadsheetApp. Understand rows, columns, and cells better.

3 Ways to Count in Google Sheets

The video explains three ways to count cells or information in Google Sheets: using the Explorer, using the COUNT function, and using the COUNTALL function. The Explorer is a tool located at the bottom right of the screen that allows you to quickly understand your data and find the count of items in a column. The COUNT function allows you to count the number of cells that contain numbers in a range of cells, while the COUNTALL function counts all the cells in a range, including those that contain formulas or are blank. The video also mentions other functions such as SUM and UNIQUE

Beginner

COUNTA() COUNTIF()

Spreadsheet Automation 101 Lesson 2: onEdit() Trigger

One of the things to learn: We can only have one onEdit() in our entire spreadsheet file. I’ll also walk you through on how you can use Event and Logger to get cool information.

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.

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.

Search for Photos in a Google Sheet by Keyword

Add one more feature to our Photo search inside of Google Sheets.

Beginner

Building the Newsletter Geeks Virtual Mall

We're gonna create another virtual mall, and in this one we're gonna make it for newsletters

Advanced

CONCATENATE()

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

Build a Domain Grader

Create a way to grade the quality of a domain based on many different votes and inputs and qualities. Like measuring the length and ranking the results.

ARRAYFORMULA() CONCAT() COUNTA() COUNTIF() LEN() +1 more

Dark Mode / Better Font Color

While the desktop version of Google Sheets does not have a dark mode, doesn't mean we can't make it ourselves. Create dark mode in one click. You'll learn to make a dark mode toggle.

Intermediate

Search Every Function in Google Sheets

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

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/

Turn Data in Many Columns Into 1 Column

How to turn many columns into one column.

Beginner

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

Roast: Sales Tax Calculator

I would not think that I would enjoy sales tax calculators, no one enjoys sales tax calculators, but when it's in a Google sheet, it's really exciting.

Intermediate

Let's Make a Bookmarklet!

Curate a newsletter. Collect YouTube videos. Research competitors. All with this one line of javascript. Build your own web clipper. Use the Bookmarklet to clip web content to your Google Sheet. Clip text and links directly from the web to your Google Sheet with just a few clicks.

TAGS

FORMULAS

TOPICS

112 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Email Certain Department Based on Google Form Entries

SearchLord: One Sheet to Search Them All

How To Format Sheets for Notes

Spreadsheet Automation 101 Lesson 2: Arrays

Spreadsheet Automation 101 Lesson 1: Spreadsheet Taxonomy

3 Ways to Count in Google Sheets

Spreadsheet Automation 101 Lesson 2: onEdit() Trigger

Sheet Improvement: Electric Vehicle Stock Tracker by evuniverse.io

Roast: Mortgage Calculator for Google Sheets

Search for Photos in a Google Sheet by Keyword

Building the Newsletter Geeks Virtual Mall

Better Numbers and Bullet Points in Your Spreadsheets

Build a Domain Grader

Dark Mode / Better Font Color

Search Every Function in Google Sheets

Better Font Colors

Turn Data in Many Columns Into 1 Column

How To Export Your Beautiful Sheets to PDF

Roast: Sales Tax Calculator

Let's Make a Bookmarklet!