Tools, Templates, & Tutorials

View Pricing Tiers

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

Automatically Check Past Stages

Create an automation that runs whenver we check off a checklist item the past stages also check.

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

Count Unique Attendees For Each Event

Find out how many people attended each event even if they are double counted in attendee lists.

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.

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()

Email Myself a Daily Random Motivational Quote

Quickly make a daily email to myself with a motivational quote.

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.

A Spreadsheet CRM: Automation at work

Check out a CRM built inside of Google Sheets called SheetifyCRM.com

How to Merge Cells in Google Sheets

A master class on merging cells. How to merge two cells. How to merge multiple cells. How to merge horizontally, vertically, and why. Create groups. Create headers. And how to merge automatically. Members get the sheet and the apps script down below.

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!

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.

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

Automatic Calculations

Create custom scripts to make your spreadsheets more like tools.

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.

Fabulous Filters

How to let your end users find what they want. Use the FILTER() function to create views.

Quality Curation

How to curate data easily and quickly into a sheet (Bookmarklet)

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

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.

How to Count Numbers in a Row

Got this question in the Facebook Group: How to count the number of numbers in a row. I saw two possible solutions mentioned in the comments and wanted to go through why those are okay but there is a much more flexible and better solution.

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