Spreadsheet fundamentals

sheet.new

Discover a clever trick for creating new Google Sheets when signed into multiple accounts. Learn how to easily add a number after 'sheet' to generate a new spreadsheet.

Random Number Between 1 and 100

Learn how to generate a random number between 1 and 100 in Google Sheets using a formula and automate the process with Google Apps Script. This video covers creating a custom menu for easy access to your random number generator.

Who invented spreadsheets?

Explore the fascinating history of spreadsheets, from ancient accounting to modern tools like Google Sheets and Excel, and discover the influential figures who shaped their evolution.

What is a spreadsheet formula?

In this video, learn what a spreadsheet formula is and how it can transform your Google Sheets experience by enabling calculations, text manipulation, and more. Discover the power of combining formulas to unlock the full potential of your spreadsheets.

new dawn. new day. new sheet

Discover a simple yet powerful Google Sheets hack that allows you to create a new spreadsheet instantly from your browser's URL bar. This video reveals tips and tricks to enhance your Google Sheets experience.

Google Sheets Hacks You Don't Know Yet 001

Discover a clever Google Sheets hack that allows you to instantly download your sheets by modifying the URL. This quick tip can save you time and streamline your workflow.

Go To Random Row Custom Function

Learn how to create a custom function in Google Sheets that activates a random row, enhancing your spreadsheet experience with a simple automation. This tutorial also introduces a custom menu for easy access to the function.

All Sheets Update Status Change Date Automatically

Learn how to automatically update the last modified timestamp across all sheets in your Google Sheets document using Apps Script. This video demonstrates a simple function that ensures every sheet reflects the latest edit date in a specified column.

Alternate Row Color Automatically

Learn how to automatically add alternating row colors in Google Sheets using a simple Apps Script function. This quick tutorial shows you how to enhance your spreadsheet's visual appeal with minimal effort.

Create Brick Pattern in Google Sheets

Learn how to create a visually appealing brick pattern in Google Sheets by resizing cells, merging them, and applying colors and borders. This tutorial provides step-by-step instructions to enhance your spreadsheet design.

BEFORE YOUR SHEET GOES TO AI

In this video, learn essential tips for preparing your Google Sheets data before handing it off to AI, ensuring clarity and effectiveness for both machines and humans. Discover best practices for headers, formatting, and file types to enhance AI interactions.

Why is my SUMIF not working

In this video, learn why your SUMIF function may not be working in Google Sheets, including common pitfalls like spaces in criteria and mismatched ranges. Discover tips for using SUMIFS for better accuracy and troubleshooting techniques to ensure your formulas yield the correct results.

How to Highlight Top 3 Numbers in Row

Learn how to highlight the top three numbers in a row using conditional formatting in Google Sheets, making your data visually appealing and easier to analyze.

How to Highlight Top 3 Numbers in Column

Learn how to highlight the top three numbers in a column using conditional formatting in Google Sheets. This tutorial walks you through the steps to create a custom formula for effective data visualization.

Why Spreadsheets are Spreadsheets

Explore the fascinating history of spreadsheets, from their origins as ledgers to the modern-day tools we use, including insights from pioneers like Bill Gates and Steve Jobs. Discover how AI is shaping the future of spreadsheet technology.

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.