Spreadsheet fundamentals

Simple Weight Tracker Automatic Add Row

Learn how to create a simple weight tracker in Google Sheets that automatically adds a new row for daily entries, making it easier to track your progress over time.

Coffee Break ToDo List

In this video, learn how to create a dynamic ToDo list using spreadsheet formulas, making your task management more efficient and enjoyable during your coffee breaks.

How to Sort by Color in Google Sheets

Learn how to sort your data by color in Google Sheets, allowing you to prioritize specific colors in your dataset for better organization and visibility.

Google Sheet Side Quests

Explore various Google Sheet side quests that enhance your learning experience, from mastering basic and advanced formulas to automating tasks with App Script. Discover tips and tricks to make your spreadsheets more powerful and efficient.

Snorkel Trip

Join us on an exciting snorkel trip as we explore how to use spreadsheet functions like COUNTIF to navigate through waves and track our adventure.

How to Add a Series to a Google Sheet

Learn how to easily add a series of numbers to your Google Sheets using the SEQUENCE function, making data management more efficient and organized.

WRONG ROUNDDOWN

In this video, learn why using ROUNDOWN in Google Sheets can lead to incorrect results when dealing with negative numbers, and discover how the INT function can provide a more accurate rounding solution for debts.

McDo To Do

In this video, we explore a fun and engaging way to use checklists in Excel, drawing a playful analogy to McDonald's as we work through various functions and formulas.

Reusable Checklist Google Sheets

Learn how to create a reusable checklist in Google Sheets that automatically resets daily, making it perfect for multiple users or daily tasks. This video guides you through the process of using Google Apps Script to automate the unchecking of tasks.

Coffee Time Task List #spreadsheetmagic

Join us for a fun and productive session as we create an automated task list that brings us closer to our coffee time, utilizing spreadsheet magic to streamline our tasks.

Ski Trip To Do

In this video, we explore how to effectively plan a ski trip using spreadsheet formulas to manage tasks and logistics.

Sync Calendar to Sheets

Learn how to sync your Google Calendar events directly into Google Sheets using a simple Apps Script. This tutorial walks you through creating a custom function to automate the process and manage your calendar data efficiently.

Magic Formula Combinations #googlesheets

Discover the magic of combining formulas in Google Sheets to unlock powerful functionalities and streamline your spreadsheet tasks. Learn how simple formula combinations can transform your data management experience.

people chip email

Learn how to easily extract email addresses from people chips in Google Sheets with this simple method. This video demonstrates the straightforward process of referencing cells to access email information.

What is a Spreadsheet? Anatomy of a Spreadsheet

In this video, learn the anatomy of a spreadsheet, including the structure of sheets, cells, and ranges, along with essential tips and tricks for using Google Sheets effectively.

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.