Better Sheets on YouTube

Random Number Between 1 and 100

Learn how to generate a random number between 1 and 100 in Google Sheets using formulas and Google Apps Script. This video also covers creating a custom menu for easy access to the random number generation function.

OnlySheets.bettersheets.co

Discover Only Sheets, a unique solution designed to protect your Google Sheets from unauthorized access, originally conceived as a joke but now a functional tool.

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, including Dan Bicklin and Steve Jobs.

What is a spreadsheet formula?

In this video, learn what a spreadsheet formula is and how to use it effectively in Google Sheets to perform calculations, combine text, and automate tasks. Discover the power of over 500 formulas available at your fingertips.

this guy Google sheets #spreadsheetmagic

Discover the magic of Google Sheets as this enthusiast shares insights and tips to enhance your spreadsheet skills.

new dawn. new day. new sheet

Discover a simple Google Sheets hack that allows you to quickly create a new spreadsheet directly from your browser's URL bar.

Google Sheets Hacks You Don't Know Yet 001

Discover lesser-known Google Sheets hacks that can enhance your productivity and streamline your workflow. Learn how to easily download your Google Sheets with a simple URL modification.

Go To Random Row Custom Function

Learn how to create a custom function in Google Sheets that activates a random row, enhancing your spreadsheet functionality with a simple script.

All Sheets Update Status Change Date Automatically

Learn how to automatically update the last modified timestamp across all sheets in Google Sheets using Apps Script. This tutorial demonstrates how to implement a function that ensures every sheet reflects the latest edit date.

Alternate Row Color Automatically

Learn how to automatically add alternating row colors in Google Sheets using a simple Apps Script function. This quick tutorial will enhance the visual appeal of your spreadsheets with minimal effort.

Ask Me Questions #googlesheets

In this video, the host discusses their passion for answering Google Sheets questions and introduces a new platform, answer.com, designed to facilitate this interaction. They emphasize the importance of context for beginners and the innovative role of AI in the question-answering process.

Create Brick Pattern in Google Sheets

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

BEFORE YOUR SHEET GOES TO AI

Learn essential tips for preparing your Google Sheets data before handing it off to AI, ensuring clarity and effectiveness in communication with both machines and humans.

Why is my SUMIF not working

In this video, learn why your SUMIF function may not be working correctly in Google Sheets and discover common pitfalls, such as spaces in criteria and mismatched ranges. The video also introduces the SUMIFS function as a more reliable alternative.

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. This tutorial walks you through the steps to apply custom formulas for effective data visualization.

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 to the impact of AI on modern spreadsheet software. Discover how pioneers like Bill Gates and Steve Jobs shaped the tools we use today.

Two Outputs, Same Cell

Learn how to use formulas in Google Sheets to generate multiple outputs from the same cell based on different payment plans. This video covers the use of IF and SWITCH functions to handle various scenarios effectively.

Open Excel File in Google Sheets

Learn how to easily open and convert Excel files into Google Sheets, ensuring you can utilize all the features of Google Sheets without frustration.

How to Save Google Sheets

Learn how to effectively save and back up your Google Sheets with automatic saving, manual downloads, and version history features in this comprehensive tutorial.

SHEET NEWS #googlesheets #excel

Stay updated with the latest news in the spreadsheet world, covering both Google Sheets and Excel, including unique features and community contributions.

Autofill Date on Edit in Multiple Columns

In this video, learn how to automatically fill dates in multiple columns using Google Sheets' Apps Script on edit events. Discover how to set up your script to update dates based on changes in task status efficiently.

Add Pop Up Calendar Date To Cell

Learn how to create a popup calendar date picker in Google Sheets to enhance your data entry experience. This tutorial covers setting up data validation for date inputs, making it easier to manage dates for your clients.

How to Clip Text Automatically Google Sheets

Learn how to automatically clip text in Google Sheets using a simple app script function. This tutorial will guide you through the steps to ensure your text remains clipped in specified columns.