141 Google Sheet Tutorials

💡

An exclusive library of Google Sheet Tutorials

🚀
Efficient: Automation techniques to supercharge your workflow and automate repetitive tasks.
🎯
Precise: Ensure your data is always accurate and your analysis is clear.
🌈
Creative: Discover new ways to use Google Sheets.
Can't Find a Video?: Members can reach out and ask me anything!

Spreadsheet Automation 101 Lesson 2: onEdit() Trigger

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.
Make a Better Template - Ambassador Nomination Template

Make a Better Template - Ambassador Nomination Template

Create a nomination or voting template. Looking to build better Google Sheets? Andrew from Better Sheets is here to help! Join his membership to access exclusive videos and email support. In this video, Andrew takes a closer look at a Google Sheet template by Tableau ambassador Adam Miko, offering tips and tricks for a better user experience. Save time and effort with Andrew's easy copy-and-paste method. Want more? Join his membership today and start building better Sheets! 
How Do I Make a CSV File? And give a link to someone instead of the csv.

How Do I Make a CSV File? And give a link to someone instead of the csv.

Create a link to your sheet that immediately download the sheet as a CSV file. Great for sending exports as a link.
Intro Video - Make Better Sheets

Intro Video - Make Better Sheets

Transform your Google Sheets game with Better Sheets tutorials! Learn how to create dynamic databases, design-friendly sheets, and more. Discover hidden formulas and tools, and even build your own. Don't miss out on leveling up your productivity. Create dynamic tools, revamp your skillset, and ultimately master Google Sheets like never before. Better Sheets platform offers more than just tutorials. There is a deep directory of every Google Sheets formula with links to step-by-step tutorials as well as blog posts and youtube videos. It's the ultimate resources to learn how to use formulas in Google Sheets. Every tutorial has listed categories and courses it's a part of. In addition to that any formula featured is listed. And you can click on any formula to see that formula in action in other tutorials on the Better Sheets platform. Watch this walkthrough of the Better Sheets platform.
Hide Completed Bars - Make Progress Bars with Sparkline: Part 2

Hide Completed Bars - Make Progress Bars with Sparkline: Part 2

Use the IF() formula to hide completed bars and display messages instead of bars depending on the situation.
Make Your Headers Useful

Make Your Headers Useful

Today we're gonna talk about headers. I'm gonna give you three really cool ways to use your headers.
Make Unsplash in a Google Sheet w/ BuyMeACoffee - Part 1

Make Unsplash in a Google Sheet w/ BuyMeACoffee - Part 1

Create a photo search site inside with Google Sheets. Using this template you can empower users to: Enter a search term and get an image without leaving the sheet! And learn how to monetize this Google Sheet.
How to Make An Easter Egg Hunt in a Google Sheet - by BetterSheets.co

How to Make An Easter Egg Hunt in a Google Sheet - by BetterSheets.co

Create a pastel colored hunting game, just in time for Easter.
Let's Make a Bookmarklet!

Let's Make a Bookmarklet!

Curate a newsletter. Collect YouTube videos. Research competitors. All with this one line of javascript. Build your own web clipper. Use the Bookmarklet to clip web content to your Google Sheet. Clip text and links directly from the web to your Google Sheet with just a few clicks.
Make Unsplash in Google Sheets - Part 2

Make Unsplash in Google Sheets - Part 2

Fix the case sensitive search with lower(). Add quick links to prefilled results. Create another sheet with ImportRange().Protect the sheet from unnecessary edits.
Create a new Spreadsheet from just a Name in a Sheet.

Create a new Spreadsheet from just a Name in a Sheet.

Create the Apps Script to create a new sheet from some data inside your sheet. Script included in the sheet below.
Make a New Sheet - Best Practices

Make a New Sheet - Best Practices

Create a new sheet and do it well.
Make Your Lists Spicy Hot in Google Sheets

Make Your Lists Spicy Hot in Google Sheets

Create fun funky bullet points to get your point across better. Put emojis in your sheets to bring them to life.
Make your Custom Functions Like Native Functions | Custom Function Autocomplete

Make your Custom Functions Like Native Functions | Custom Function Autocomplete

Enable your apps script functions be auto completed while you're using Google Sheets.
Take a list and make it Vertical, Using Split Join or RegexReplace

Take a list and make it Vertical, Using Split Join or RegexReplace

Create vertical lists in Google Sheets.
Make a Quick Pipeline (For Sales and More)

Make a Quick Pipeline (For Sales and More)

Create a sales pipeline quickly in Google Sheets.
6 Ways to Make Your Checkboxes Better

6 Ways to Make Your Checkboxes Better

Learn How to Take Your Google Sheets Checkbox to the Next Level and Get More Organized! Click Now to Discover Creative Ways to Use Checkboxes and Boost Your Productivity!

We're going to take a basic function of Google sheets, which is the checkbox, and we are going to take it to its nth degree.
Escape Spreadsheet Hell A Mini Game

Escape Spreadsheet Hell A Mini Game

Spreadsheet Automation 101: Functions

Spreadsheet Automation 101: Functions

Get introduced to Apps Script functions and functions syntax. Learn how to write new functions, how to name functions and call functions from your sheet.
Spreadsheet Automation 101: Variables

Spreadsheet Automation 101: Variables

Dive deeper into the world of variables. Learn what variables do. Learn how to assign information to variables.

Displaying items 21-40 of 141 in total