Spreadsheet fundamentals

COUNT TEXT

Learn how to count occurrences of specific text in a column using the COUNTIF function in Google Sheets, including techniques for wildcard searches.

How to Reorder Tabs in Google Sheets

Learn how to easily reorder tabs in Google Sheets to keep your workspace organized. This video covers both dragging tabs and using the tab menu for efficient management.

How to Hide a Sheet in Google Sheets

Learn how to effectively hide and unhide sheet tabs in Google Sheets, making it easier to manage your workbook and archive past data without cluttering your view.

How to Restrict Edit Access to a Range

Learn how to restrict edit access to specific ranges in Google Sheets, ensuring that only designated columns can be edited while protecting the integrity of your data.

How To Share a link to a specific tab in google sheets

Learn how to share a specific tab in Google Sheets by using the tab's unique GID in the URL. This video provides step-by-step instructions for creating links to individual tabs and ensuring that viewers only see the intended content.

How to Restrict Edit Access to a Sheet to Only You

Learn how to restrict edit access to a specific sheet in Google Sheets, ensuring that only you can make changes while others are locked out.

How to Highlight Duplicates in Google Sheets

Learn how to easily highlight duplicates in Google Sheets using conditional formatting and the COUNTIF function. This tutorial provides step-by-step instructions to enhance your spreadsheet skills.

How to Create a Sequence in Google Sheets

Learn how to create sequences in Google Sheets using both manual methods and formulas. This video covers techniques like dragging to fill and using the SEQUENCE function for efficient data entry.

How to Create A Visually Appealing Chart

Learn how to create a visually appealing chart for your income and expenses using Google Sheets, including tips on using SUMIF, filter functions, and customizing chart styles.

How To Highlight Today's Date in Google Sheets

Learn how to highlight today's date in Google Sheets and apply the formatting to the entire row using conditional formatting techniques.

How to Publish Spreadsheet to Web

Learn how to publish your spreadsheet to the web, allowing you to share it via a link or embed it on a website without granting direct access to others.

How to Embed a Single Tab in a Website

Learn how to embed a single tab from a Google Sheet into your website, allowing you to share specific data without exposing the entire spreadsheet. This tutorial guides you through the process step-by-step, ensuring privacy and control over your shared information.

How to Embed a Spreadsheet in a Website

Learn how to embed a Google Sheet into your website instead of sharing it as a link, allowing for a seamless integration of your data. This video guides you through the steps of publishing your Google Sheet to the web and embedding it using an iframe.

Jump to Specific Cell Automatically

Learn how to automatically jump to a specific cell in your Google Sheets every time you open the document using a simple Apps Script function.

How to Convert Text to Lowercase Snake Case in Google Sheets

Learn how to convert text to lowercase snake case in Google Sheets using a simple formula that combines the LOWER and SUBSTITUTE functions.

How to Convert Text to Uppercase Snake Case in Google Sheets

Learn how to convert any text in Google Sheets to uppercase snake case by replacing spaces with underscores using the upper and substitute functions.

Don't Delete My Formulas

In this video, learn how to protect your formulas in Google Sheets from accidental deletion by using various techniques, including array formulas and Apps Script automation. Discover tips to ensure your formulas remain intact even when others attempt to modify them.

How to Add a CSV as a New Tab in Google Sheets

Learn how to easily add a CSV file as a new tab in Google Sheets, allowing for better organization of your data without creating a new spreadsheet.

How to Append a CSV in Google Sheets

Learn how to easily append a CSV file to an existing Google Sheets document, ensuring your data is seamlessly integrated without losing any existing information.

How to Import a CSV in Google Sheets

Learn how to easily import a CSV file into Google Sheets, whether it's from your Google Drive or your local storage. This video covers various import options to help you manage your data effectively.

How to Copy a URL to Share a Google Sheet

Learn how to easily copy a URL to share your Google Sheet with others, whether you've already shared it or are doing so for the first time.

How to Insert Dates #googlesheets

Learn how to easily insert dates in Google Sheets using the date picker feature and data validation rules. This video guides you through setting up a date picker for your spreadsheet.

How to Edit Spreadsheet Name in Google Sheets Android

Learn how to easily rename a Google Sheet on your Android device with this quick tutorial. Follow the simple steps to update your spreadsheet name and see the changes reflected in your Google Drive.

How to Rename a Tab in Google Sheets

Learn how to easily rename a tab in Google Sheets with multiple methods, including double-clicking the tab name and using the File menu. Be aware of the 100-character limit for tab names to avoid errors.