Spreadsheet fundamentals

How to Highlight Not Time in Google Sheets

Learn how to highlight non-time entries in Google Sheets using conditional formatting. This tutorial walks you through the steps to create a custom formula that effectively identifies and highlights cells that do not contain valid time values.

Sheet I Refuse To Make

In this video, the creator discusses the limitations of Google Sheets when it comes to building multi-relational databases and emphasizes the importance of understanding data direction in spreadsheet design.

Vacation Vote

In this video, learn how to use Google Sheets to facilitate group vacation planning with advanced formulas and checkboxes, allowing for easy decision-making based on votes and approvals.

Rename Form Tab Automation in Google Sheets

Learn how to automate the creation and renaming of Google Forms directly from Google Sheets using Apps Script. This tutorial walks you through the process of setting up a custom menu and managing form responses efficiently.

How to Get Multiple Lines in a Cell

Learn how to create multiple lines within a single cell in Google Sheets using both merging and formatting techniques. This video provides practical tips for enhancing your spreadsheet layout.

Fonts in Google Sheets

Discover the best monospace fonts for numbers and headers in Google Sheets to enhance your spreadsheet's appearance and readability.

I Built a Flashcard System in Google Sheets

In this video, learn how to create a simple flashcard system in Google Sheets that allows you to study efficiently by revealing answers with checkboxes. This system is perfect for students in various fields, making study sessions more interactive and organized.

Make'em Click

Learn how to create eye-catching buttons in Google Sheets that encourage users to click on links. This video provides a fun and easy tutorial on enhancing your sheets with colorful buttons.

How Many Days Old Am I?

Learn how to calculate your age in days using the DATEDIF formula in Google Sheets. This tutorial demonstrates how to set up your birth date and find out how many days old you are.

Epic ChatGPT Prompt Library in Google Sheets

In this video, learn how to efficiently integrate hundreds of prompts into ChatGPT using Google Sheets, leveraging URL encoding and hyperlinks for seamless access. Discover how to create a dynamic prompt library that allows for easy editing and iteration.

EZ Grader in Google Sheets

In this video, learn how to create an enhanced Easy Grader in Google Sheets, perfect for teachers to quickly calculate grades based on the number of problems wrong. Discover useful formulas and conditional formatting techniques to make grading easier and more visually appealing.

Weekday Name in Google Sheets

Learn how to display the weekday name from a date in Google Sheets using formulas and formatting options. This video covers multiple methods to achieve this, making it easy to customize your date displays.

How to Freeze The Top Row in Google Sheets

Learn how to easily freeze the top row and columns in Google Sheets with this simple trick, ensuring your headers stay visible while you scroll through your data.

Highlight More than 1 Duplicate

Learn how to highlight duplicates in Google Sheets when there are three or more occurrences, making it easier to identify frequent entries in your data.

FullBox Checklist

Learn how to create a full box checklist in Google Sheets using checkboxes and custom formatting techniques to enhance your productivity.

Votes for Approval

In this video, learn how to effectively use checkboxes and dropdowns in Google Sheets to manage group approvals, including techniques for counting votes and setting custom checkbox values.

Change This Setting Now! Google Sheets has More than 1 Timezone Setting

Learn how to manage multiple time zone settings in Google Sheets and Apps Script to ensure your automations run at the correct times. This video provides essential tips that can save you from potential headaches when working with time-sensitive data.

Countbox Checkbox

In this video, Andrew demonstrates how to use checkboxes in Google Sheets to accurately count guests and their selections by assigning custom values to each checkbox. Learn how to set up data validation and create a dynamic counting system with checkboxes.

Hide Sheet Custom Function

Learn how to create custom functions in Google Sheets to hide and show specific sheets using Apps Script. This tutorial walks you through the process of adding a custom menu for easy navigation.

How to Highlight Not Time

Learn how to highlight cells in Google Sheets that do not contain time values using conditional formatting. This tutorial walks you through the steps to create a custom formula for effective data visualization.

Conditional Formatting Full Course

This comprehensive course on conditional formatting in Google Sheets teaches you how to effectively highlight and visualize data using various rules and styles, transforming your spreadsheets into powerful tools for analysis.

Full Box Checkbox

In this video, Andrew demonstrates how to create a full box checkbox in Google Sheets, allowing you to check an entire box with a single click. Learn about customizing checkbox text color and applying conditional formatting for enhanced functionality.

How to Round Up in Cell in Google Sheets

Learn how to round up numbers directly in a Google Sheets cell using Apps Script, without needing to create additional columns. This tutorial demonstrates a simple onEdit function to achieve this functionality.

How to Automatically Uppercase a Column in Google Sheets

Learn how to automatically convert text in a specific column to uppercase in Google Sheets using Apps Script. This tutorial demonstrates a simple onEdit function that ensures any edits made to the first column are instantly transformed to uppercase.