Spreadsheet fundamentals

Disney Trip Planning

Learn how to effectively plan your Disney trip with practical tips and spreadsheet techniques to keep track of your itinerary and tasks.

How to Insert Emojis in Google Sheets

Learn how to easily insert emojis into Google Sheets on both PC and Mac, adding a fun and personal touch to your spreadsheets.

How to Swap Cells in Google Sheets

Learn how to efficiently swap cells in Google Sheets using various methods, including keyboard shortcuts and mouse actions, without disrupting other data.

VLOOKUP not working #googlesheets

Learn how to fix the common VLOOKUP error in Google Sheets that results in an NA response by using absolute references to fortify your range.

VLOOKUP NOT WORKING, Getting #N A

In this video, learn how to fix the common issue of VLOOKUP returning #N/A in Google Sheets by using absolute references to keep your range constant while copying formulas. This quick tutorial will help you ensure accurate results in your VLOOKUP tables.

Auto Capitalize in Google Sheets

Learn how to automatically capitalize names in Google Sheets using a simple Apps Script function. This video covers both formula-based and script-based methods for achieving proper capitalization as you type.

Coffee Tracker

Learn how to create a Coffee Tracker in Google Sheets that automatically logs the date when you check off a checkbox, helping you keep track of your daily coffee consumption.

go beyond Z

Discover how Google Sheets can extend beyond the traditional column limit of Z, allowing you to insert additional columns and enhance your spreadsheet experience.

Multiple Random Numbers An Array of Random Numbers

Learn how to generate multiple random numbers in Google Sheets using the RANDARRAY function, allowing you to create arrays of random integers across various ranges effortlessly.

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.