Spreadsheet fundamentals

Two Outputs, Same Cell

Learn how to generate multiple outputs in the same cell using Google Sheets, specifically through the use of IF and SWITCH formulas to handle different payment plans.

How to Save Google Sheets

Learn how to effectively save and back up your Google Sheets with automatic saving, downloading options, and version history management in this comprehensive tutorial.

SHEET NEWS #googlesheets #excel

Stay updated with the latest in the spreadsheet world, including news about Google Sheets and Excel. Discover what Microsoft Excel can do that Google Sheets can't and contribute your own findings to the community.

Autofill Date on Edit in Multiple Columns

In this video, learn how to automatically fill dates in multiple columns using Google Sheets and Apps Script, ensuring that your task statuses are always up-to-date with the correct timestamps.

Add Pop Up Calendar Date To Cell

Learn how to create a pop-up calendar date picker in Google Sheets to enhance your data entry experience. This tutorial covers the steps to set up data validation for date inputs, making it easier to manage dates for your projects.

How to Clip Text Automatically Google Sheets

Learn how to automatically clip text in Google Sheets using a simple Apps Script function. This tutorial will guide you through the steps to ensure your text is always clipped in specified columns.

How To Combine Link and Text

Learn how to efficiently combine links and text in Google Sheets using the hyperlink formula, allowing you to create a clean and organized list of clickable titles.

MESSIEST SPREADSHEET MISTAKE

In this video, discover the messiest mistake commonly made in spreadsheets and learn how to fix it using data validation to keep your data organized and accurate.

How To Automatically Add Dates in Google Sheets

Learn how to automatically add timestamps and dates in Google Sheets using simple scripts and custom menus. This video covers both automatic and manual methods to enhance your spreadsheet functionality.

How to Email Editors and/or Viewers Google Sheets

Learn how to easily email collaborators directly from Google Sheets, allowing you to share your work efficiently with editors and viewers. This video provides a step-by-step guide on utilizing the email function for seamless collaboration.

Track Last Contact in Google sheets

Learn how to effectively track your last contact with clients in Google Sheets using dropdowns and formulas for better organization and efficiency.

How To Get Last Word in Cell

Learn how to extract the last word from a cell in Google Sheets using a simple formula that handles multiple names or words effectively.

Use VLOOKUP to Add Flag to Google Sheets

Learn how to use VLOOKUP in Google Sheets to add country flags by fetching ISO codes from an API. This tutorial provides step-by-step instructions for creating dynamic flag images in your spreadsheets.

How To Sum By Client

Learn how to efficiently sum hours worked and paid by client using the SUMIFS function in Google Sheets. This tutorial provides step-by-step instructions to create a summary table for your projects.

Remove Extra Spaces

Learn how to effectively remove extra spaces in your Google Sheets data using regular expressions and simple formulas. This video provides practical tips for cleaning up your data for better presentation and accuracy.

Capitalize First Letter

Learn how to capitalize the first letter of words in Google Sheets using the PROPER function and array formulas for efficient formatting of your data.

How To Insert Row Under Header Automatically

Learn how to automatically insert a row below the header in Google Sheets using App Script, ensuring the design of the header is preserved. This video guides you through creating a custom menu and setting up triggers for automation.

CLUTTERED CODE

In this video, learn how to declutter your code and improve readability using Apps Script and AI tools like ChatGPT. Discover practical tips for managing complex scripts and enhancing your coding efficiency.

Highlight If Larger than Other Column

Learn how to use conditional formatting in Google Sheets to highlight cells in one column based on their values compared to another column. This tutorial demonstrates a practical example of billing clients for overtime by highlighting hours worked that exceed hours paid.

RED if Negative, GREEN if Positive

Learn how to use conditional formatting in Google Sheets to visually differentiate between negative and positive hours worked. This tutorial shows you how to set up rules that change text color based on values.

Replace Numbers with Asterisks

Learn how to replace numbers with asterisks in Google Sheets using the REGEXREPLACE function, perfect for masking sensitive information like credit card details or order IDs.

Remove Non Numbers

In this video, learn how to remove non-numeric characters from your data using the REGEXREPLACE function in Google Sheets. This technique is essential for cleaning up IDs, usernames, and currency values to ensure your data is accurate and usable.

Google Sheets Count Cells with Text

Learn how to effectively count cells with text in Google Sheets using functions like COUNTA and COUNTIF. This video covers various scenarios, including counting specific text and handling blank cells.

How to Lock Multiple Tabs at Start of Sheets List in Google Sheets

Learn how to lock multiple tabs in Google Sheets using Apps Script, allowing for better organization and automation of your spreadsheets.