Better Sheets

Academy ↓

Free ↓

Login
Pricing
+ 19
→ Random Tutorial

Tags

Formulas

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

Reformat Pasted Cells Automatically
Create uniform formatting even if you're copy and pasting data that is differently formatted.
Intermediate
Americano Tournament Template With Four Automations
Created a tournament template with 4 automations. So tabs can be copied by a laptop, ipad, or mobile.
Intermediate
Build a Startup Pitch Generator in 20 minutes
Build a fully functioning AI powered startup pitch generator in 20 minutes. I saw a tweet listing startup accelerators and thought it would be cool to build a tool that edits my own startup idea into a personalized pitch to each startup accelerator fund. Get it for your google drive down below
https://docs.google.com/spreadsheets/d/1KevSvdwpONP89eBOe-8fDfp2fGlBafE7BAtI5wgGe2U


Get the AI script here: https://bettersheets.co/snippets/updated-open-ai-model-to-omni
Intermediate
Every Google Drive File Created in Last 24 Hours
Create a simple report in a Google Sheet that documents every file in your Google Drive that was created in the last 24 hours.
Intermediate
Recreate a Starbucks Order Status Sign
Create a status flow chart, like a kanban board but for displaying coffee orders.
Beginner
Breaking Through Errors In Apps Script
See where to find errors in your apps script and how to fix them. You will either get syntax errors ( the way the code is written) or runtime errors (when you actually run the code).
Intermediate
How To Update Your Add-on
How to update your add-on when you update your code for fixes or add functionality. 
Advanced
Send Better Email When Google Form Filled Out
Find out how to email all the form entries each time your form is filled out.
Intermediate
Perfect Use of AI in Google Sheets (Categorize Tasks)
Explore how to use AI for task categorization in Google Sheets, from setting up the environment to using a pre-made code template. Watch as we walk through the process, from generating an API key to fine-tuning the prompt for effective categorization of work and home tasks.

Final code is available in the sheet below. And the original template code is available here:
https://bettersheets.co/snippets/updated-open-ai-model-to-omni
Intermediate
Scoping Functions in Apps Script
Create multiple functions that run with the result of other functions.
Advanced
Advanced Coding in Google Sheets for Programmers
Add a Custom Menu
Create Native-like Functions
Get URL and Sheet ID's via Apps Script
A Few things to know about Developing Google Sheet Add-ons
AdvancedIntermediate
Automated Project Management in Google Sheets
Create automatic notifications when a project is assigned, a project needs review. And move a project from one tab to another tab.
Intermediate
Google Sheets Easter Eggs Beyond PRIDE
Going beyond PRIDE, to show you some undocumented google sheets hacks that you might call "Easter Eggs"
AdvancedBeginnerIntermediate
Vertically Stack and Sort Data
It's a common problem: combining two lists of scores to identify top performers using Google Sheets. We demonstrate how to sort data from two different ranges using the VSTACK function and also using curly brackets. Learn the step-by-step process to create a single, vertically stacked dataset that can be sorted effectively.
Beginner
How to Insert Multiple Rows in Google Sheets (Easy to Hard)
Learn how to add multiple rows to your google sheets by hand, and automatically. 
AdvancedBeginnerIntermediate
One Million Checkboxes
Check out this fun onEdit() counting you can do with checkboxes in a fun sheet with 1 Million Checkboxes.
Anyone can log into google sheets and go here: https://bettersheets.co/checkboxes
Beginner
3 Free Tools to Make Your Google Sheets Better
3 add-ons you can install right now and your Google Sheets life is better!
Tiny Sheets makes it simple to delete excess blank rows and columns.
Sheet Styles makes for less headaches and better text colors.
Button Styles makes awesome buttons for your users to click.
Can I get alerted when a tab name is changed?
Find out in this quick experiment if a tab name can be alerted to the owner of the spreadsheet. Great for owners and operators who want to know if someone is changing the sheet.
Turn Bland Sheets Into Glam Sheets!
A few tips to make your Google Sheets look better.
Beginner
How do I reference a different spreadsheet in Apps Script?
I'll show you how to get text from one spreadsheet file to another with Apps Script. Yes you can do this by Importrange() but you might want another way to do it.
Intermediate

Displaying items 1-20 of 559 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