Spreadsheet fundamentals

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.

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.

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.

ROUND Tens, Hundreds, Thousands

Learn how to round numbers to the nearest tens, hundreds, or thousands in Google Sheets with this quick and effective tutorial. Discover practical applications for rounding in inventory management, budgeting, and property valuation.

Gemini in Apps Script

Searchable Dropdown

Learn how to create a searchable dropdown list in Google Sheets to easily find and select items from large datasets, enhancing your productivity and efficiency.

Average Only Checked in Google Sheets

Learn how to calculate the average of only checked items in Google Sheets using checkboxes and the FILTER function. This tutorial also covers how to handle errors when no checkboxes are selected.

Join Text Together with Concatenate, Concat and Ampersand!

Learn how to effectively join text in Google Sheets using the CONCATENATE function, CONCAT, and the ampersand method for seamless text combination.

How To Center Text Across Rows and Columns

Learn how to center text across rows and columns in Google Sheets by merging cells and adjusting alignment for a cleaner, more organized table layout.

Maximum Emoji in Google Sheets

Learn how to visually highlight the maximum value in Google Sheets using emojis and custom formulas. This video demonstrates a fun way to enhance your CRM data representation.

SUM a ROW

Learn how to sum a row in Google Sheets using various methods, including summing consecutive and non-consecutive cells. This video provides practical examples to help you master summing techniques for your data.

IF All Above Are Filled Conditional Formatting

Learn how to use conditional formatting in Google Sheets to visually indicate project status based on feedback from team members. This tutorial covers setting up rules to turn a cell green if all required inputs are filled and red if any are missing.

Email When Over 10 Days Since Last Update

Learn how to automate email notifications for clients that haven't been contacted in over 10 days using Google Sheets and Apps Script. This tutorial walks you through creating a helper column and setting up a function to send alerts based on your CRM data.

Add Zero in Front of Phone Number

Learn how to add a zero in front of phone numbers in Google Sheets without complicated formatting. This quick tip ensures your numbers display correctly while maintaining flexibility in input.

The Ultimate Weight Tracker Template

Discover the ultimate weight tracker template that combines powerful features to help you achieve your weight loss goals effortlessly. With automated reminders, goal setting, and integration with Google services, this template ensures you stay accountable and motivated.

Highlight Duplicates of Two Columns

Learn how to highlight duplicates across two columns in Google Sheets using the COUNTIFS function and conditional formatting. This tutorial provides step-by-step instructions to ensure accurate duplicate detection.

How to Count Views of Google Sheets

Learn how to count the number of views on your Google Sheets using a simple Apps Script. This tutorial walks you through the steps to set up a viewer count that updates every time the sheet is opened.

Mood, Food, Tude Weight Loss Tracker

In this video, learn how to enhance a simple weight tracker by incorporating food, mood, and attitude tracking features using Google Sheets and Apps Script. Discover how to automate daily entries and create a visually appealing heat map to analyze your data effectively.

Messy Sales Pipeline CLEANED UP

In this video, learn how to transform a messy sales pipeline spreadsheet into a visually appealing and functional dashboard using checkboxes and conditional formatting, making it easier for sales reps to track their progress.

Count First Digit of Cell

In this video, learn how to count the first digit of numbers in Google Sheets using Benford's Law, which reveals interesting patterns in large datasets. Discover how to apply functions like LEFT and COUNTIF to analyze data effectively.

Week Progress Bar

Learn how to create a weekly progress bar in Google Sheets using the WEEKDAY function and checkboxes to visually represent the days of the week.