Better Sheets

Academy ↓

Free ↓

Login
Pricing
+ 10
→ Random Tutorial

Tags

Formulas

602Google 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

Automatically Delete All Sheets If Not Listed Name
A raw, 1 shot take of figuring out how to automatically delete all sheets not named on a whitelist of sheet names. Using the on Change Installable trigger. This video was tough to make!
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.
How Can I Compare Two Tabs for Differences?
So in this video we're going to compare two tabs and differences. Basically, someone asked actually on AppSumo, someone asked how do I compare two sheets to know what the differences are? This is the answer.
BetterSheets.co Tour for Lifetime Members
Find out all that Better Sheets has to offer you. Learn where to learn. Find out the features available to lifetime members at BetterSheets.co
Concat Because Concatenate is too hard to Remember!
One more function beyond Concatenate and Join that is useful in so many different ways. Concat can be used to quickly create unique columns of data. But watch out for dates!
Magical Numbering
Create a sequence of numbers that magically appears as you type in each row. Put this in A1 and start typing in column B: =SEQUENCE(COUNTA(B:B),1,1,1)
Beginner
Seek Errors When Coding Apps Script
It's healthy programming. I'll show you some common errors you will encounter when you first start programming in Apps Script
Advanced
Sheet Styles A Free Google Sheet Add-on by Better Sheets
Install Sheet Styles now: https://sheet-styles.bettersheets.co/
Learn Google Sheet Formulas The Hard Way
One weird way to learn more about what Google Sheets can do. https://bettersheets.co/formulas
Create a Many to Many Database
We have a list of names and maybe we have sort of a lead categories. Maybe we're doing sort of reach out and we want to actually maybe combine like key words.
Think Like a Programmer: Develop The Mindset of an Apps Script Coder
Learn how to think like a programmer and develop a coding mindset with these expert tips from a seasoned Google Sheets programmer. Don't fall for the common, ineffective advice, and instead follow this practical advice, including learning the process, figuring out how to search, and avoiding memorization. With these habits, you'll be on the path to successful coding. 

It's hard to code. It's even harder to learn to code. This is my thought process to help you become resilient enough to learn, and continue to learn to code.
This Seems Like Automation
4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.
Spreadsheet Automation 101 Lesson 4: OmdbAPI Parameter Picker
Get more things than just the poster and movie title by changing our script a bit. By creating different functions, we can get other data such as movie posters or directors.
Spreadsheet Automation 101 Lesson 4: JSON (beautifier) and OmdbAPI parameters
Learn how we get information out of a JSON response. I’ll even show you how you can bring in some cool images in Google Sheets!
Spreadsheet Automation 101 Lesson 4: OmdbAPI get data in Apps Script
Use getData and UrlFetchApp functions, as well as Logger to get OMDb API data in our Google Sheet. Learn how to access an API outside of Google Sheets.
Spreadsheet Automation 101 Lesson 4: OmdbAPI get ApiKey, get Data in URL
Capture data from OMDb in our Google Sheets with a free API Key. It’s easier than it sounds. Let’s do this!
Spreadsheet Automation 101 Lesson 4: UrlFetchApp
Use any URL to scrape the web or access an API and get that info into your Google Sheet.
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!
Spreadsheet Automation 101 Lesson 3: Email Other People For Loop
Send the same email to different people by using the same Four Loop to figure out which ones we’re sending. Do cool things with this Mail App and email system.
Spreadsheet Automation 101 Lesson 3: Send Email Every Week Trigger
Learn about how to add and delete Triggers very quickly. I’ll teach you how you can send out an email regularly using Triggers.

Displaying items 321-340 of 602 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