Spreadsheet fundamentals

How to Get Name of Last Month in Google Sheets

Learn how to easily retrieve the name of the last month in Google Sheets using a simple formula. This step-by-step guide will help you automate the process for any month.

How To Get Last Name with Middle Names in Google Sheets

Learn how to extract the last name from a full name in Google Sheets, even when middle names are present, using a combination of the INDEX and SPLIT functions. This video provides a programmatic solution to automate the process.

How To Alphabetize Google Sheets

Learn how to alphabetize your data in Google Sheets with simple sorting techniques, including how to freeze headers to maintain their position during sorting.

Combine Filters In One Column in Google Sheets

Learn how to combine multiple filters into a single column in Google Sheets, allowing for dynamic updates based on selected criteria. This tutorial demonstrates the use of array formulas and concatenation techniques to create a clear summary of sales data.

How to Change Checkbox to Yes or No

Learn how to customize checkboxes in Google Sheets to display 'Yes' or 'No' instead of the default 'True' or 'False' values with this quick tutorial.

How to Quickly Add Status Dropdown Chip

Learn how to quickly add a status dropdown chip in Google Sheets to keep your data organized and validated. This tutorial covers creating dropdowns for project statuses like 'not started', 'in progress', and 'completed'.

How to Quickly Add Yes/No Dropdown Chip

Learn how to quickly create a Yes/No dropdown menu in Google Sheets for efficient status tracking and approvals. This tutorial covers the steps to implement dropdown chips and customize their appearance.

How to Add US to US Dollars Currency

Learn how to add 'U.S.' in front of U.S. dollar amounts in your spreadsheet, ensuring clarity when dealing with multiple currencies.

Highlight Entire Row with Conditional Formatting

Learn how to highlight an entire row in Google Sheets using conditional formatting based on specific criteria. This video provides a step-by-step guide to applying custom formulas for effective data visualization.

Build a Startup Pitch Generator in Google Sheets

In this video, learn how to create a Startup Pitch Generator using Google Sheets and AI, allowing you to tailor your pitch for various startup accelerators like Y Combinator and Techstars.

How to Get Alerts When Someone Has Edited My Google Sheet

Learn how to set up alerts in Google Sheets to notify you when someone has made edits to your document. This video covers the steps to configure notification settings for immediate or daily updates.

How To Delete a Spreadsheet

Learn how to delete a spreadsheet in Google Sheets, including how to restore it from trash and permanently delete it after 30 days.

How to Copy a Tab in Google Sheets

Learn how to easily duplicate a tab in Google Sheets, allowing you to create new sheets for different years while retaining formatting and data. This tutorial also covers how to copy a tab to a new spreadsheet.

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.