Better Sheets
Tools, Templates, & Tutorials

Explore ↓

Free Resources ↓

Member Login
View Pricing Tiers
→ Random Tutorial

Tags

Formulas

535Google 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.

Open Spreadsheet to Motivational Quote Automatically
Create a simple script to open a particular tab. In this case we're opening to a random motivational quote each time.
Beginner
Automatically Check Past Stages
Create an automation that runs whenver we check off a checklist item the past stages also check.
Beginner
Automate Move Blank Rows
Intermediate
Move Blank Rows
Apps Script function to move all blank rows if a certain column is not filled in. Learn how to automate this script →Here
Intermediate
Build Your Own PROPER() Custom Apps Script Function to Capitalize Each Word
There's something wrong with PROPER() the google sheets function. Let's fix it by customizing our own TitleCase() function inside of Apps Script.
Intermediate
Embed Quote and Author to Daily Quote Website
Step by step tutorial to update random quote site to show both Quote and Author separately.  Example site: https://todayquote.carrd.co/

Quick tutorial to show you how to build a random quote site  →Here
Advanced
Automatically Align Top
Automate formatting cells to align top. Either by a time-based trigger or every time you edit cells.
Build Your Own Net Promoter Score (NPS) Survey on a Web Site
Create an embeddable NPS system on a web page.
Advanced
Build Your Own AI Writer in Google Sheets
Create your own AI writer with these google sheets tips and tricks and code.
Advanced
Timestamp When Done (With Code)
Automatically create a timestamp when a certain cell is marked as Done. I show you how to customize this scrip and where to get the script. I hope this is simple enough for beginners to start automating you sheets. If you want to see more automations and dive deeper into apps script enroll in Spreadsheet Automation 101
and see more examples of Apps Script at BetterSheets.co/snippets
Beginner
Automatically Backup a Spreadsheet
Make a copy and rename to BACKUP plus the Date of the backup. Execute this automatically via Triggers in your Apps Script. Two are shown here. to back up a tab or back up a spreadsheet file.
Intermediate
Count Unique Attendees For Each Event
Find out how many people attended each event even if they are double counted in attendee lists.
Beginner
Invoicing in Google Sheets for Freelancers
Introduction to creating a filter so that you can bill for a certain time period of hours. Great sheet for Freelancers or Gig Workers.
Beginner
Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas
Automatically copy a spreadsheet tab to a whole new spreadsheet file, get the url of that new sheet, and make sure the new file is values only. no formulas. A member asked this question and I'm happy to answer it, code it, and let you in on the answer in this short video.
Intermediate
Optimize SEO with Google Sheets and Google Search Console
Use Google Sheets to quickly find pages we can optimize. Using data directly from Google Search Console. Also check out the simple formula combination: AND() with IF()
Beginner
Email Myself a Daily Random Motivational Quote
Quickly make a daily email to myself with a motivational quote.
Beginner
Quickly Build a Daily Random Motivational Quote Website
Build a website from scratch using a little bit of Google Sheets as the backend. Using Carrd to build a html website from the data and display a random quote every time you refresh the page. All the code including the HTML embed is in the sheet below.
Intermediate
Move Cells to New Row with Formula
Move a range, or a set of cells, to a new area with a simple formula that's just "curly brackets". Very easy and simple to use once you know it.
Beginner
Saving OpenAI API Calls inside of Google Sheets
Copy text output and input into a google sheet from your OpenAI API calls. Great way to save AI text into a sheet or start to create your own AI writer, or even clone ChatGPT
Intermediate
Weird Idea: Find a Great Sheet Domain Name
Find a domain to get sheet ideas.
Intermediate

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