Spreadsheet fundamentals

th of the month and year

Learn how to effectively use the 'th' of the month and year in your formulas to get accurate date representations.

Votes for Approval

In this video, learn how to effectively use checkboxes and dropdowns in Google Sheets to manage group approvals, including techniques for counting votes and setting custom checkbox values.

Sheets Auto Sorts QUICKLY

In this quick tutorial, Andrew demonstrates how to automatically sort tasks and deadlines in Google Sheets using a simple script. Learn how to implement the 'on edit' function to keep your data organized effortlessly.

walk to mordor

In this playful tutorial, learn how to use COUNTIF and other functions in Google Sheets to manage your tasks as you metaphorically walk to Mordor.

Change This Setting Now! Google Sheets has More than 1 Timezone Setting

Learn how to manage multiple time zone settings in Google Sheets and Apps Script to ensure your automations run at the correct times. This video provides essential tips that can save you from potential headaches when working with time-sensitive data.

Countbox Checkbox

In this video, Andrew demonstrates how to use checkboxes in Google Sheets to accurately count guests and their selections by assigning custom values to each checkbox. Learn how to set up data validation and create a dynamic counting system with checkboxes.

Hide Sheet Custom Function

Learn how to create custom functions in Google Sheets to hide and show specific sheets using Apps Script. This tutorial walks you through the process of adding a custom menu for easy navigation.

How to Highlight Not Time

Learn how to highlight cells in Google Sheets that do not contain time values using conditional formatting. This tutorial walks you through the steps to create a custom formula for effective data visualization.

Make'em Click Best Button

Learn how to create eye-catching buttons in Google Sheets to encourage clicks on your links. This video guides you through the steps to transform standard links into visually appealing buttons.

EVERYTHING you need to know about Conditional Formatting

This comprehensive course on conditional formatting in Google Sheets teaches you how to effectively highlight and visualize data using various rules and styles, transforming your spreadsheets into powerful tools for analysis.

Google Sheets Sorts Itself

In this tutorial, Andrew demonstrates how to automate sorting in Google Sheets using a simple script that sorts the sheet by a specified column every time an edit is made. Learn how to set up this functionality to keep your tasks organized effortlessly.

Full Box Checkbox

In this video, Andrew demonstrates how to create a full box checkbox in Google Sheets, allowing you to check an entire box with a single click. Learn about customizing checkbox text color and applying conditional formatting for enhanced functionality.

How to Round Up in Cell in Google Sheets

Learn how to round up numbers directly in a Google Sheets cell using Apps Script, without needing to create additional columns. This tutorial demonstrates a simple onEdit function to achieve this functionality.

How to Automatically Uppercase a Column in Google Sheets

Learn how to automatically convert text in a specific column to uppercase in Google Sheets using Apps Script. This tutorial demonstrates a simple onEdit function that ensures any edits made to the first column are instantly transformed to uppercase.

Hidden Checkbox Until Checkbox Checked

Learn how to hide a checkbox in Google Sheets until another checkbox is checked using conditional formatting techniques. This tutorial provides step-by-step instructions to achieve a clean and organized spreadsheet.

Moon Phase in Google Sheets

Learn how to calculate the current moon phase in Google Sheets using a specific formula. This video also showcases how to visualize the entire lunar cycle for the year in a single glance.

HIGHLIGHT When it's NOT TIME

In this tutorial, Andrew demonstrates how to highlight cells in Google Sheets when the input is not a valid time, emphasizing the importance of managing time effectively without strict deadlines.

Year To Date Sum

Learn how to calculate the Year To Date sum in Google Sheets with this quick tutorial by Andrew. Discover the simple formula and tips to efficiently manage your data.

% to Divide by 100

Discover how to effectively use the percentage symbol in Google Sheets to divide numbers by 100 and 1,000, along with unique applications like generating sequences with percentages.

Create Specific Sized Sheet

In this video, learn how to create a Google Sheet with a specific number of rows and columns using Google Apps Script, without relying on any extensions. Discover how to automate the process and customize your sheets effectively.

How To Transpose In Google Sheets

Learn how to efficiently switch columns to rows in Google Sheets using the transpose function, and discover how to create dynamic matrices that automatically update when changes are made.

Your Spreadsheets Are Leaking Email Addresses (Fix It in 30 Seconds)

Learn how to quickly redact email addresses from your spreadsheets using regular expressions in Google Sheets. This video provides a step-by-step guide to ensure your data remains private while maintaining its context.

Stop Formatting Cells. Format Inside the Formula Instead

Learn how to format numbers as currency within a formula in Google Sheets, ensuring your totals display correctly with dollar signs and appropriate formatting.

Automate Two Sheets

In this video, learn how to automate sorting across multiple sheets in Google Sheets using Apps Script. Discover various methods to set up triggers for daily automation of your sorting functions.