Spreadsheet fundamentals

How Many Days This Year? Google Sheets Formula

Learn how to calculate the number of days in a year using Google Sheets formulas, including how to identify leap years automatically.

How to Quickly Find Conditional Formatting

Learn how to quickly identify conditional formatting in your Google Sheets, including tips on checking text and fill colors.

Clear Task Row With One Click in Google Sheets

Learn how to clear a task row in Google Sheets with just one click using checkboxes and a simple Apps Script. This video also introduces Sheet Ops, a powerful task management tool with automation features.

How To Add Numbers Automatically in Google Sheets

Learn how to automatically add numbers in Google Sheets using the SUM function and create running totals for your sales data. This tutorial covers essential techniques to keep your data updated effortlessly.

IF Negative Then Zero

Learn how to use the IF function in Google Sheets to convert negative values to zero, ensuring your data remains valid and useful for analysis.

Fix VLOOKUP NA ERROR Quickly

Learn how to quickly fix the VLOOKUP NA error in Google Sheets by using the IFNA function and data validation techniques to enhance user experience.

Is This Conditional Formatting?

Learn how to identify and manage conditional formatting in Google Sheets, including how to check for existing rules and modify them.

How to Stop onEdit Automation in Google Sheets

Learn how to stop onEdit automation in Google Sheets by renaming triggers or commenting out lines of code. This video provides practical tips for managing your Google Sheets scripts effectively.

5 Google Sheet Templates You’ll Get as a Better Sheets Member

Discover five powerful Google Sheet templates available exclusively to Better Sheets lifetime members, designed to enhance productivity and streamline workflows.

How to Add Shortcut to Tab in Google Folder

Learn how to create shortcuts to specific tabs in Google Sheets using Google Drive and AppScript. This video covers two effective workarounds to link directly to tabs within your spreadsheets.

How to Protect Spreadsheet From Yourself

Learn how to protect your Google Sheets from accidental edits, including how to set permissions and use App Script to maintain important formulas.

Automate Based on Google Form Response

Learn how to automate actions based on Google Form responses using Google Apps Script, including sending customized emails based on the city selected in the form.

Password Protect Google Sheets

Learn how to password protect your Google Sheets to restrict access to sensitive data using Google Forms and Apps Script in this informative tutorial.

How to Ungroup Rows in Google Sheets

Learn how to easily ungroup rows in Google Sheets with this quick tutorial. Discover the steps to manage your row groups effectively and enhance your spreadsheet organization.

How to Group Cells in Google Sheets

Learn how to efficiently group cells and rows in Google Sheets to organize your data better. This tutorial covers the steps to group rows and the keyboard shortcuts to make the process quicker.

Automatically Timestamp New Tasks When Entered

Learn how to automatically timestamp new tasks in Google Sheets using the onEdit function in Apps Script. This video guides you through the process of setting up a timestamp for each new entry in your task list.

How to Write Email Subject Variations Fast! SIMPLE GOOGLE SHEETS AUTOMATION

Learn how to quickly generate email subject variations using a simple automation trick in Google Sheets that can significantly boost your productivity.

How to Fix No Sales in a Year on a Gumroad Sales Page

In this video, learn how to revamp your Gumroad sales page to attract buyers and increase sales, especially if you've struggled to make any sales in the past year. Discover key strategies for product presentation, targeting your audience, and optimizing your listings for better visibility.

How to Highlight Row Based on Cell Value in Google Sheets

Learn how to highlight an entire row in Google Sheets based on the value of a specific cell, using conditional formatting and custom formulas.

Bulk Keyword Search Across Many Sites

In this video, learn how to perform bulk keyword searches across multiple sites like Reddit, YouTube, and Udemy using Google Sheets. Discover how to set up a dynamic search system that allows you to explore various keywords and phrases efficiently.

Silent Auction in Google Sheets

Learn how to set up a silent auction using Google Sheets, including how to create a bidding form, track bids, and display the highest bid dynamically.

How To Randomize a Long Sequence in Google Sheets

Learn how to efficiently randomize a long sequence in Google Sheets, from creating a sequence of numbers to applying randomization techniques without manual dragging.

How To Use LEN to Count Characters

Learn how to use the LEN function in Google Sheets to count characters in a cell, ensuring your text meets specific length requirements for social media posts or domain names.

How to Download Protected or View Only Google Sheets

Learn how to download protected or view-only Google Sheets using a simple workaround that allows you to save the data as an HTML file. This video provides step-by-step instructions to help you access your data even when download options are disabled.