Spreadsheet fundamentals

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.

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.