Spreadsheet fundamentals

How To Add Emojis to Google Sheets

Learn how to easily add emojis to your Google Sheets using keyboard shortcuts and other methods to enhance your spreadsheets.

SUM From Date to Date in Google Sheets

Learn how to sum values between specific dates in Google Sheets using the SUMIFS function. This video provides a step-by-step guide to correctly setting up your criteria for date ranges.

Count Color by Row

In this video, learn how to count rows in Google Sheets by their background color using Google Apps Script. Discover how to create custom functions to automate this process and visualize your data effectively.

Get Full Year API with Google Sheets

Learn how to turn a Google Sheet into a full-year API that automatically updates, allowing you to share specific data with others securely. This tutorial covers the steps to create and deploy a web app using Google Apps Script.

Automatically Replace Words in Google Sheets

Learn how to automatically replace words in Google Sheets using both the SUBSTITUTE formula and Google Apps Script for real-time editing. This video provides step-by-step instructions to enhance your spreadsheet skills.

Change Font on Every Sheet Tab

Learn how to automatically change the font on every sheet tab in Google Sheets using a few lines of Apps Script. This simple tutorial guides you through the process step-by-step.

Quick Follow Up Email

Learn how to automate sending follow-up emails directly from Google Sheets using Google Apps Script. This tutorial walks you through setting up the script to send personalized emails based on task assignments.

How to Hide Rows Marked Complete in Google Sheets

Learn how to automatically hide rows marked as 'Complete' in Google Sheets using Google Apps Script. This tutorial walks you through the process step-by-step, ensuring your task list stays organized.

Scrape Google Maps in Google Sheets

Learn how to scrape Google Maps data directly into Google Sheets using Google Apps Script. This tutorial covers setting up the API key, writing the script, and customizing your queries for effective data retrieval.

Download Google Sheets

Learn how to easily download Google Sheets in various formats, including PDF and CSV, and discover some hidden tricks to share and copy sheets effortlessly.

Auto Count Length

Learn how to automate character counting in Google Sheets using both a formula and Google Apps Script in this informative video. Discover how to streamline your workflow and eliminate the need for visible formulas.

Automate Upper Case

Learn how to automate upper casing in Google Sheets using Google Apps Script, allowing text in one column to automatically appear in uppercase in another column.

Highlight Unique Values

Learn how to highlight unique values in your data using conditional formatting in Google Sheets, specifically focusing on identifying customers who have made only one purchase.

Highlight Below Average

Learn how to highlight numbers below average in Google Sheets using conditional formatting and custom formulas.

UnMerge Automatically Google Sheets

Learn how to automatically unmerge cells in Google Sheets using a simple Apps Script function that runs on a timer, ensuring your sheet stays organized without manual intervention.

Automate Adding Prefix in Cell

Learn how to automate adding a prefix to cells in Google Sheets using formulas and Google Apps Script, making it easier to create unique identifiers for your projects.

Quickly Highlight Long Text

Learn how to quickly highlight long text in Google Sheets using conditional formatting based on character length. This tutorial guides you through the steps to set up custom formulas for effective text management.

Highlight Above Average

Learn how to highlight cells in Google Sheets that are above average using conditional formatting. This quick tutorial guides you through the steps to apply custom formulas for effective data visualization.

Create Dropdown Menu

Learn how to create a dropdown menu in Google Sheets with this quick tutorial. Discover tips for adding options and color coding your selections.

Timestamp Column in Google Sheets

Learn how to create a timestamp column in Google Sheets that automatically updates whenever you edit a cell in that column using Google Apps Script.

Start Sheeting Better in 2026

In this video, learn how to enhance your Google Sheets for better readability and data visualization in 2026, with tips on formatting, alignment, and conditional formatting.

Click Checkbox to Copy to Tab in Google Sheets

Learn how to use Google Sheets and Apps Script to copy data from one tab to another when a checkbox is checked. This tutorial covers the necessary code and logic to automate the process seamlessly.

One Click New Sheet

Learn how to quickly create a new Google Sheet using the 'sheet new' command and streamline your workflow with bookmarks for easy access.

Cumulative Subtraction in Google Sheets

Learn how to perform cumulative subtraction in Google Sheets to effectively track your salary against monthly expenses. This tutorial provides step-by-step guidance on setting up your spreadsheet for accurate financial management.