Spreadsheet fundamentals

Harada Method Template

Learn how to create the Harada Method template in Google Sheets, a fun and effective way to visualize your goals and track progress. This tutorial walks you through the steps to set up a customizable and user-friendly template.

MonoSpace Font

Learn how to enhance your spreadsheet's readability by using monospace fonts, making larger numbers stand out more clearly. This simple change can significantly improve your spreadsheet experience.

Mordor To Do

In this video, we explore how to create a 'Mordor To Do' list using spreadsheet functions like COUNTIF and cell formatting techniques to visualize progress.

Weight Tracker Reverse Chronological

Learn how to create a reverse chronological weight tracker in Google Sheets that allows you to easily enter your weight at the top of the sheet without scrolling. This tutorial covers the use of Google Apps Script to automate daily entries.

Symbols, Emojis,Arrows, Shapes, Braille & Fun in Google Sheets

Discover the fun and creative ways to use symbols, emojis, and shapes in Google Sheets with the CHAR formula. Learn how to enhance your spreadsheets with unique characters and playful designs.

Cruise Trip #spreadsheetmagic

Join us as we explore the magic of spreadsheets while planning a cruise trip, utilizing formulas to manage tasks and checklists effectively.

Year on a Cell

Learn how to extract just the year from a date in Google Sheets using specific formulas and combinations. This video guides you through the process step-by-step.

Email When Cell Changes

Learn how to set up email notifications in Google Sheets when a specific cell changes, making it easier for managers to stay updated without constantly checking the sheet.

Gardening To Do List #googlesheets

Learn how to create a gardening to-do list in Google Sheets, utilizing functions to track plant progress and manage tasks effectively.

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.