Better Sheets

Academy ↓

Free ↓

Login
Get Instant Access
Luethi Barrett
+ 25
→ Random Tutorial

Tags

Formulas

611Google Sheet Tutorials

Discover the Power of Productivity

An Exclusive Library of Google Sheet Tutorials!

Why Choose Our Google Sheet Tutorials?

🚀 Efficient:

Learn the best Google Sheets formulas and spreadsheet automation techniques to supercharge your workflow. Discover how to automate repetitive tasks effortlessly, saving you valuable time and effort.

🎯 Precise:

Master Google Sheets formulas to ensure your data is always accurate and up-to-date.

🔧 Automate Your Sheets

Delve into the world of Google Apps Script. Automate reporting. Automate your data. Automate your business

Build a License Key Generator and API in 20 Minutes
How to leverage Apps Script to create an API in less than 20 minutes. Create a license key for use in your own apps or as a cloud based API service. We'll create the API using Apps Script and the front end system using a basic Carrd page. Also I'll show you how to test your API in Postman, a free api checker web app.
Advanced
You Must Double Duplicate (If you're selling a sheet you use)
How to turn a spreadsheet in your Google Drive into a sellable product. Step-by-step, I will show you exactly how I do it. If you're selling a sheet you use, then you must do this!
Beginner
Automate Emails
Set up automated email notifications based on Google Sheets data. Super simple apps script to start this. Learn how to automate this for users very easily with a custom menu and programmable Triggers.
Beginner
Different Kinds of Automation
A brief description of types of automation. I go way more in depth in “Master Spreadsheet Automation” on Udemy and “Spreadsheet Automation 101” on Better Sheets
- Built-in Formulas that seem like automation IF()
- Custom Functions in Apps Script
- Time Driven Triggers
- Event Driven Triggers
Beginner
Automatic Calculations
Create custom scripts to make your spreadsheets more like tools.
Beginner
Wield Wizardry
How to imbue your sheets with a little bit of magic to delight your customers without learning Apps Script. Using the IF/ISBLANK formula combination.
Beginner
Fabulous Filters
How to let your end users find what they want. Use the FILTER() function to create views.
Beginner
Quality Curation
How to curate data easily and quickly into a sheet (Bookmarklet)
Beginner
Ask Questions
Process qualitative data into a sellable sheet (Google Forms)
SECTION 3 - How to Make a Spreadsheet
Crafting High-Demand Sheets from Scratch. Turn templates into tools to make sellable spreadsheets.
Intermediate
How do I prevent people from sharing my spreadsheets by making a copy?
A video I did summarizing the 3 things you can do to help people who share your sheet, not do it, or at least get some value from it.

More info on the course: sellingspreadsheets.com

→ Get OnlySheets

Beginner
Every Possible Permutation - Solved with Spintax
Someone asked about how to find all the permutations of text and I thought it was a perfect example to show you how to use Spintax add-on. Free for everyone.

→ Get Spintax
Intermediate
Turn Headlines up to 11! - Update to Spintax Tool
Updated the Spintax tool to allow you to generate Spintax. Instead of having to come up with it all yourself, you can let AI generate the Spintax for you. Create variations on headlines, or phrases, or emails.
Intermediate
Use Random Quote API in Google Sheets
Learn how to add random movie quotes and famous quotes to a Google Sheet. We'll use RapidAPI to get the code and just have a little bit of editing to the code to be able to use it in Google Sheets.
Intermediate
Curate Google Sheets Easily - Automatic Bookmarklet Maker
Curated sites, articles, and more web resources super easily into a Google Sheet. Create a bookmarklet automatically with this apps script tool.
Beginner
Build Your Own Free Domain Availability Checker
Built a Domain Availability Checker in Google Sheets. You can build your own with the code provided. Use RapidAPI and Domainr.com to get an APIEKY for your own free checker.

Learn how to integrate sheets with a TLD Availability API.
Advanced
Create a Branded Lead Magnet from Qualitative Data
Find out how to turn some data you can copy/paste from the web into a branded lead magnet for yourself.

Check out Josh's Tweet about the sheet.
and check out his Podia.
 
The video shows the importance of adding personal touches to a Google Sheet to connect better with users. It explains how to analyze the sheet's data to find trends and best practices for website content. Lastly, it discusses ways to share the sheet widely while still giving credit to its creator.
Intermediate
Duplicate Everything For Each Unique Value
Intermediate
How to Make Good Looking Spreadsheets
Create nice colorful sheets (contrasting colors) that look and feel like an extension of your site. Add some padding around text. Decrease text and make your sheets awesome.
Intermediate
How to Make an AI Integrated Freebie Spreadsheet
Intermediate

Displaying items 121-140 of 611 in total

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons