Spreadsheet fundamentals

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.

How to See Version History in Google Sheets

Learn how to view and manage version history in Google Sheets, including how to name versions for easy access and tracking changes over time.

How To Make Negative Numbers Red in Google Sheets

Learn how to easily highlight negative numbers in red using conditional formatting in Google Sheets, making your data analysis clearer and more efficient.

Checkbox or Dropdown?

In this video, we explore the differences between using checkboxes and dropdown menus for attendance tracking in Google Sheets, discussing their advantages and limitations based on situational needs.

Quickly CAPITALIZE Headers

Learn how to quickly capitalize headers in Google Sheets using simple functions and shortcuts. This video provides a step-by-step guide to ensure your headers are consistently formatted without manual typing.

How to Copy an Entire Spreadsheet

Learn how to easily copy an entire spreadsheet in Google Sheets, including tips on sharing and utilizing unique URL hacks for exporting and duplicating your files.

How to Move Row To Section in Google Sheets

Learn how to automatically move a row to a specific section in Google Sheets using Apps Script. This tutorial demonstrates how to set up a function that responds to edits in your sheet, making data organization easier.

How to Find Fuzzy Matches in Google Sheets

Learn how to find fuzzy matches in Google Sheets using simple formulas and conditional formatting to enhance your data cleaning process.

How to Convert Text to Numbers in Google Sheets

Learn how to convert text that appears as numbers into actual numbers in Google Sheets, ensuring your calculations work correctly. This video covers various formatting techniques to achieve accurate data representation.

Link Google Sheets to Google Slides

Learn how to efficiently link data from Google Sheets to Google Slides, allowing for dynamic updates and easy access to detailed information in your presentations.