Spreadsheet fundamentals

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

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.

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.

Harada Method Template

Learn how to create the Harada Method template in Google Sheets, a fun and effective way to visualize your goals and track progress. This tutorial walks you through the steps to set up a customizable and user-friendly template.

MonoSpace Font

Learn how to enhance your spreadsheet's readability by using monospace fonts, making larger numbers stand out more clearly. This simple change can significantly improve your spreadsheet experience.

Mordor To Do

In this video, we explore how to create a 'Mordor To Do' list using spreadsheet functions like COUNTIF and cell formatting techniques to visualize progress.

Weight Tracker Reverse Chronological

Learn how to create a reverse chronological weight tracker in Google Sheets that allows you to easily enter your weight at the top of the sheet without scrolling. This tutorial covers the use of Google Apps Script to automate daily entries.

Symbols, Emojis,Arrows, Shapes, Braille & Fun in Google Sheets

Discover the fun and creative ways to use symbols, emojis, and shapes in Google Sheets with the CHAR formula. Learn how to enhance your spreadsheets with unique characters and playful designs.

Cruise Trip #spreadsheetmagic

Join us as we explore the magic of spreadsheets while planning a cruise trip, utilizing formulas to manage tasks and checklists effectively.

Year on a Cell

Learn how to extract just the year from a date in Google Sheets using specific formulas and combinations. This video guides you through the process step-by-step.

Email When Cell Changes

Learn how to set up email notifications in Google Sheets when a specific cell changes, making it easier for managers to stay updated without constantly checking the sheet.

Gardening To Do List #googlesheets

Learn how to create a gardening to-do list in Google Sheets, utilizing functions to track plant progress and manage tasks effectively.

Simple Weight Tracker Automatic Add Row

Learn how to create a simple weight tracker in Google Sheets that automatically adds a new row for daily entries, making it easier to track your progress over time.