Better Sheets
Tools, Templates, & Tutorials

Explore ↓

Free Resources ↓

Member Login
Pricing
→ Random Tutorial

Tags

Formulas

538Google Sheet Tutorials

Discover the Power of Productivity with Our Exclusive Library of Google Sheet Tutorials!

Unleash your full potential with our comprehensive Library of Google Sheet Tutorials. Dive into the world of seamless data management and analysis with our tutorials, your gateway to mastering the art of Google Sheets.

Why Choose Our Google Sheet Tutorials?

🚀 Maximize Your Efficiency:

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.

🎯 Precision at Your Fingertips:

Master Google Sheets Match and Indirect functions, ensuring your data is always accurate and up-to-date. Say goodbye to errors and hello to precise, reliable results every time.

💡 Expert Tips and Tricks:

Explore the best-kept secrets of Google Sheets, including adding emojis to your spreadsheets and creating powerful combinations. Impress your colleagues and clients with visually appealing and informative sheets.

🔧 Google Script Magic:

Delve into the world of Google Script and learn how to generate PDFs with just a click. Elevate your document game and streamline your reporting processes effortlessly.

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.
Spreadsheet Automation 101 Lesson 3: Email Yourself For Loop
I’ll walk you through how you can receive an email about tasks that haven’t been done.
Spreadsheet Automation 101 Lesson 3: MailApp
Learn about the needed variables for the Mail App to work. In this lesson, I’ll walk you through how you can email yourself or other people the items in a to-do list that hasn’t been done yet.
Introduction to Spreadsheet Automation 101 Lesson 3
This lesson will teach you how to email yourself by sending some texts. Learn how to get some data from your sheet and send them into your inboxes or other people’s inboxes.
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.

Displaying items 261-280 of 538 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