Hey there! In this video, I'll show you how to create awesome buttons in Google Sheets using a three by three set of cells. We'll merge cells, adjust alignment, resize rows and columns, add colors and shadows, change fonts, and even make the buttons look like hyperlinks. And the best part? I'll also show you how to do it all in just one click using the Button Styles add-on. So get ready to make your Google Sheets look super cool with these stylish buttons! 🚀

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.

Some helpful tips on how to get someone to look at a particular cell in your sheet.

quick fun video to show you how to add a button to emails when you send emails from Google Sheets.

Create dark mode with Conditional Formatting.

These are simple spreadsheet hacks you might not know about. Simple interface tricks that knowing about will make your spreadsheet life better.

Create a simple checklist checker that shows us the first unchecked item in a task list.

You're joining a company and they have some Google Sheets already created, and there's a sheet that has a cell in A1, this number, and you want to iterate it to 3, and B1 is connected to a lot of other stuff, so you don't want to mess with it. All you want to do is iterate a one, one at a time. I think the answer here is an Apps Script. 

This tutorial showcases a practical solution to convert visual cues into actionable data in Google Sheets. It's a step-by-step guide on using Google Apps Script to automate the process of reading background colors and converting them into text. The focus is on simplifying data processing tasks and enhancing the utility of spreadsheets for data analysis.

Learn how to use URL forwarding to Redirect Domains to Google Sheets and Google Docs. Also included is a new feature I like to in Google which is Publish To the Web. In a previous video about this topic I might not have mentioned that.

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.

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.

Let me tell about some cool hacks you can do with checkboxes. Like making a checkbox have alternative values, or making a checkbox look like a button, not a check mark.

Sit back and enjoy this comprehensive tutorial on how to create a live message in Google Sheets. In this video, we dive deep into the process of live message creation, providing step-by-step instructions and practical examples. Whether you're a beginner or an experienced user, this tutorial will empower you to unleash the full potential of Google Sheets.

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.

Get your spreadsheet to check off your checklist for you.

Dive into spreadsheet automation with this easy to follow script, or copy the sheet and use the script as you wish.

Discover the Ultimate Google Sheets Hack! Transform Text with Title Case Formula. Say Goodbye to 'Proper' and Hello to Easy Capitalization. Find Out How! 

In this video, I will show you how to clean up a list of names that may have extra white spaces using a formula. I will demonstrate how to identify and remove the extra spaces programmatically, making the list of names unique. By using the TRIM formula, we can easily clean up the names and create a new list with only the unique names. No action is required from you, just watch and learn!

Learn the Quick Fix! Replace Text with Blank Cell in Google Sheets Hassle-Free. Say Goodbye to Data Glitches. Super helpful when you need to find and replace in google sheets any text.

Build a simple function that deletes undone items in our checklist.

Little tricks to make Currency Exchange in Google Sheets better for you, and easier to read for others. Great for beginners, as well as Advanced Users.

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

Create uniform formatting even if you're copy and pasting data that is differently formatted.

Learn how to harness Google Sheets' new multi-select dropdown feature in this tutorial. We'll guide you through setting up dropdowns that allow multiple selections, using search and filter formulas to analyze and display data efficiently. By the end, you'll be able to create dynamic reports and dashboards, streamlining your workflow and enhancing data management. Perfect for those looking to get the most out of Google Sheets' latest functionality!

Without having to create two functions and two triggers you can combine two email sends into one function.

Create a simple automation for adding text to a cell of text. Really easy example is to create a lot of email subject lines from one single cell of text.

Introduction to creating a filter so that you can bill for a certain time period of hours. Great sheet for Freelancers or Gig Workers.

'll show you a game-changing Google Sheet formula that will make your day, especially if you're into bulk publishing and chat GPT. With this formula, you'll be able to insert lists of keywords into prompts effortlessly. I'll guide you step-by-step on how to set it up and use it effectively. Get ready to become faster, better, and more efficient in your publishing tasks. Let's dive in!

Going beyond PRIDE, to show you some undocumented google sheets hacks that you might call "Easter Eggs"

Learn a cool trick you can do with the ArrayFormula. If you don't know what the ArrayFormula does, I show you how to use it in the first few minutes of this video.  Then show you how to use it better.

I will show you how to create a hack to retrieve Instagram follower accounts from any Instagram page using import XML. I will explain the step-by-step process, including how to identify the XML, split it, and extract the follower account. Follow along and try it out yourself.

Create a slug maker inside your sheet. We'll take any title with any case, even if it's wrong. Our sheet template will lower case the whole line, and replace any spaces with hyphens. This way we can enter any kind of title we want and get a hyperlink slug out for use in blogs or cataloging.

Create a better checklist for project based task management.

Make your VLOOKUP formulas flexible and your data move-able with this trick.

I'll show you how to create a visual clock in your Google Sheet using conditional formatting. 

By following a few simple steps, you'll be able to see the progress of each hour throughout the day. 

No manual updates required! I'll guide you through setting up the custom formula, applying it to the desired range, and making it work for multiple columns if needed. 

Plus, I'll share a tip on how to reverse the colors if you prefer to track the remaining time instead. 

Let's get started and make your Google Sheet even more efficient! 

Analyze sales with COUNTUNIQUEIFS Formula. 

I'll show you how to create a motivational quote checklist that generates a random quote every time you check off a task. We'll start from scratch and create a formula that displays motivational quotes from a list of 100 quotes. The quotes can be easily expanded, and the checklist will update accordingly. This tool will add a touch of motivation and productivity to your day. Enjoy!

Find out the results of YouTube Thumbnail A/B Tests with this YouTube Thumbnail Image hack we can do in Google Sheets.

10 Things I Hate About Your Spreadsheets and how to fix them. Here is a list of 10 things you can do today to make your sheets more lovable.

The 10 Things I Hate about your Sheets

Create a simple script to open a particular tab. In this case we're opening to a random motivational quote each time.

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.

Learn how to use apps script to add emoji animations when you complete a checklist in Google Sheets.

Improve Google Sheets Readability
Improve the readability of your spreadsheets and supercharge your productivity with our top tips for better numbering and bullet points in Google Sheets.

Create Visually Appealing Sheets
Discover how to create clear, concise, and visually appealing spreadsheets that engage your audience and get results! Make your lists spicy hot with numbering and bullet points. Learn how to execute this to make your sheets look better.

Understanding the Importance of Readability in Spreadsheets Readability is crucial when it comes to spreadsheets. It refers to how easy it is for your audience to read and understand the data you are presenting. If your spreadsheet is cluttered, confusing, and hard to read, your audience will quickly lose interest and may not be able to make informed decisions based on the data you are presenting.

The Benefits of Using Bullet Points and Numbering in Spreadsheets
Using bullet points and numbering in spreadsheets can help to improve readability by breaking down complex information into more manageable pieces. Here are some of the benefits of using these features:

you might actually find something new and interesting about it. We're just changing the column width.

Let's figure out how a sheet is structured.

I walk you through everything you may encounter along the way of coding in Google Apps Script. Discover the challenges and pitfalls before you fail. If you’ve never coded before, I’m right there with you all the way.

Combine Databases and Backup Your Information Effortlessly - Learn how to merge two databases and compare backups with ease. Get all the information you need from past years and multiple sheets. Follow our step-by-step guide and simplify your data management today! 

How to add a timestamp to done tasks. Learn how to easily add timestamps to your done tasks! Say goodbye to manual formatting and hello to this simple code. Click now to save time! 

Write an apps script to delete lines easily.