Spreadsheet fundamentals

Automatically Timestamp New Tasks When Entered

Learn how to automatically timestamp new tasks in Google Sheets using the onEdit function in Apps Script. This video guides you through the process of setting up a timestamp for each new entry in your task list.

How to Write Email Subject Variations Fast! SIMPLE GOOGLE SHEETS AUTOMATION

Learn how to quickly generate email subject variations using a simple automation trick in Google Sheets that can significantly boost your productivity.

How to Fix No Sales in a Year on a Gumroad Sales Page

In this video, learn how to revamp your Gumroad sales page to attract buyers and increase sales, especially if you've struggled to make any sales in the past year. Discover key strategies for product presentation, targeting your audience, and optimizing your listings for better visibility.

How to Highlight Row Based on Cell Value in Google Sheets

Learn how to highlight an entire row in Google Sheets based on the value of a specific cell, using conditional formatting and custom formulas.

Bulk Keyword Search Across Many Sites

In this video, learn how to perform bulk keyword searches across multiple sites like Reddit, YouTube, and Udemy using Google Sheets. Discover how to set up a dynamic search system that allows you to explore various keywords and phrases efficiently.

Silent Auction in Google Sheets

Learn how to set up a silent auction using Google Sheets, including how to create a bidding form, track bids, and display the highest bid dynamically.

How To Randomize a Long Sequence in Google Sheets

Learn how to efficiently randomize a long sequence in Google Sheets, from creating a sequence of numbers to applying randomization techniques without manual dragging.

How To Use LEN to Count Characters

Learn how to use the LEN function in Google Sheets to count characters in a cell, ensuring your text meets specific length requirements for social media posts or domain names.

How to Download Protected or View Only Google Sheets

Learn how to download protected or view-only Google Sheets using a simple workaround that allows you to save the data as an HTML file. This video provides step-by-step instructions to help you access your data even when download options are disabled.

Pull Data from Another Sheet based on Criteria in Google Sheets

Learn how to pull data from one Google Sheet to another based on specific criteria, using features like dropdown menus and filters to make your data dynamic and interactive.

Link to Another Sheet in Google Sheets

Learn how to link to another sheet in Google Sheets using various methods, including the IMPORT RANGE function and creating hyperlinks for easy navigation.

How To Use SUMIF In Google Sheets

Learn how to effectively use the SUMIF function in Google Sheets to sum sales data based on specific criteria, such as the month of January.

Create Calendar Event With Natural Language in Google Sheets

Learn how to create calendar events using natural language in Google Sheets and manage them efficiently with a custom menu. This tutorial covers both creating and deleting events seamlessly.

Do GIFs Work in Google Sheets?

Discover how to effectively use GIFs in Google Sheets, including tips on inserting them correctly to ensure they animate as intended.

How To Color Code Rows Based on Drop-down Value

Learn how to color code entire rows in Google Sheets based on dropdown values using conditional formatting. This tutorial provides step-by-step instructions to automate the process for better data visualization.

How To Change Gridlines For Entire Google Sheet

Learn how to easily change the gridlines for your entire Google Sheet, including adjusting thickness, color, and style for a more customized look.

Link In Image in Google Sheets

Learn how to create clickable images in Google Sheets using the hyperlink and image functions. This tutorial provides step-by-step instructions to enhance your spreadsheets with interactive visuals.

How To Use ARRAYFORMULA For Magic

Learn how to use ARRAYFORMULA in Google Sheets to efficiently calculate the revenue from sales without manually copying formulas. This video demonstrates the power of ARRAYFORMULA for handling multiple rows at once.

How To Add Numbers in Google Sheets

Learn various methods to add numbers in Google Sheets, including summing ranges, individual cells, and using the command key for quick calculations.

How to Set Print Area in Google Sheets

Learn how to set a print area in Google Sheets to download only the selected cells as a PDF, excluding unwanted columns like notes or salaries.

How to Auto Increment Numbers in Google Sheets

Learn how to automatically increment numbers in Google Sheets using various formulas, including IF and SEQUENCE, to streamline your data entry process.

How To Hide Rows in Google Sheets

Learn how to easily hide and unhide rows in Google Sheets with this quick tutorial. Master this essential skill to keep your spreadsheets organized and focused.

How to Hide Columns in Google Sheets

Learn how to easily hide and unhide columns in Google Sheets with this quick tutorial. Discover tips for selecting multiple columns to hide at once and streamline your spreadsheet management.

How to Highlight Duplicates in Google Sheets

Learn how to highlight duplicates in Google Sheets using conditional formatting and the COUNTIF function. This tutorial provides a step-by-step guide to easily identify duplicate entries in your data.