Spreadsheet fundamentals

How to Checkbox if Date This Year in Google Sheets

Learn how to efficiently use checkboxes in Google Sheets to automatically mark dates that fall within the current year or the past year. This tutorial simplifies the process with formulas that dynamically update based on the current date.

Copy Date to Next Cell Automatically

Learn how to automatically copy a date from one cell to another in Google Sheets using Apps Script, streamlining your appointment tracking process.

Find Duplicates in Other Column

Learn how to easily find duplicates between two columns in Google Sheets using conditional formatting and the MATCH function. This tutorial simplifies the process of verifying attendance against registration lists.

Select Random From List in Google Sheets

Learn how to randomly select a name from a list in Google Sheets using formulas like RANDBETWEEN and INDEX. This tutorial walks you through the process step-by-step, ensuring you can automate your selection process effectively.

Sales Tracker

Learn how to effectively track sales for your team using Google Sheets with functions like SUMIFS and COUNTIF. This video provides a step-by-step guide to creating a sales tracker dashboard that highlights individual sales performance.

How To Use Index Match | An Alternative To Vlookup

Learn how to use the INDEX MATCH function as a powerful alternative to VLOOKUP in Google Sheets, allowing for more flexible data retrieval from your spreadsheets.

Turn On Screen Reader Support in Google Sheets

Learn how to enable screen reader support in Google Sheets, making it easier for users with visual impairments to navigate and utilize the platform effectively.

AI Formula in Google Sheets

Discover the powerful AI function in Google Sheets that allows you to generate text, summarize information, and categorize inputs effortlessly. This video showcases practical examples and tips to enhance your spreadsheet experience using AI.

How To Send Emails as PDF to Kindle, Automatically

Learn how to automatically send emails as PDFs to your Kindle using Google Sheets and Apps Script in this detailed tutorial. Follow along as we set up the necessary steps and code to streamline your reading experience.

Generate Short Random Codes or IDs

Learn how to generate short random codes or IDs using Google Sheets and Apps Script, ensuring uniqueness by checking for duplicates. This tutorial covers creating custom menus and functions to streamline the process.

URL Link to Last Row

Learn how to create a dynamic URL link to the last row of your Google Sheets document using App Script. This video provides a step-by-step guide to automate the process, ensuring that the link always directs users to the most recent data.

Enter Name Get Grades

Learn how to create a dropdown menu in Google Sheets that allows you to select a name and retrieve corresponding grades using the FILTER function. This video also covers handling multiple entries and using the INDEX function to manage duplicates effectively.

Think about MIDDLE vs CENTER Alignment!

Learn the crucial differences between middle and center alignment in spreadsheets to enhance their appearance and functionality. This video provides practical tips for aligning data effectively in Google Sheets.

Keyword Search Amazon in Google Sheets

Learn how to create a Google Sheets setup that allows you to search Amazon and other shopping sites directly from your spreadsheet, streamlining your product search process.

Share 1 Row to Another Tab, Forever

Learn how to consistently copy a row from one tab to another in Google Sheets without the hassle of manual copying and pasting. This video demonstrates using formulas like IMPORT RANGE and curly brackets to keep your data synchronized effortlessly.

How to Highlight 3rd Highest Number in Column

Learn how to highlight the third highest number in a column using conditional formatting in Google Sheets. This tutorial also covers how to highlight the top three scores effectively.

Share 1 Cell to API

Learn how to share a single cell value from Google Sheets to an API, allowing anyone with the URL to access the data without sharing the entire sheet. This tutorial covers the steps to set up a web app using Google Apps Script to achieve this functionality.

How to Highlight 2nd Highest Score on Leaderboard

Learn how to highlight the second highest score on a leaderboard in Google Sheets using conditional formatting and the LARGE function.

Find High Value Targets in Google Sheets

Learn how to identify high-value targets in Google Sheets using logical expressions and conditional formatting to highlight your best options as an intergalactic bounty hunter.

How to Add Alternating Row Colors

Learn how to easily add alternating row colors in Google Sheets to enhance readability and make your data stand out. This tutorial covers both traditional methods and the new streamlined approach using built-in formatting options.

SUM IF Fuzzy Search

In this video, learn how to use the SUMIF function with fuzzy search techniques to sum sales data based on specific criteria in Google Sheets. Discover how to effectively utilize wildcards and combine text for more dynamic calculations.

Change Country in Google Sheets

Learn how to change the country settings in Google Sheets and understand the implications on functions, date formats, and currency. This video also covers how to manage time zones for automations and language settings in Google Workspace.

Most Powerful Pokemon

Discover how to find the most powerful Pokemon in your list using Google Sheets functions like MAX and XLOOKUP. Learn the differences between VLOOKUP and XLOOKUP for efficient data retrieval.

How To Delete Version History

Learn how to effectively delete version history in Google Sheets to protect sensitive information and create clean templates for sharing. This method is essential for anyone looking to sell or distribute their spreadsheets without exposing previous edits.