Spreadsheet fundamentals

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.

Hidden Checkbox Until Checkbox Checked

Learn how to hide a checkbox in Google Sheets until another checkbox is checked using conditional formatting techniques. This tutorial provides step-by-step instructions to achieve a clean and organized spreadsheet.

Moon Phase in Google Sheets

Learn how to calculate the current moon phase in Google Sheets using a specific formula. This video also showcases how to visualize the entire lunar cycle for the year in a single glance.

Create Specific Sized Sheet

In this video, learn how to create a Google Sheet with a specific number of rows and columns using Google Apps Script, without relying on any extensions. Discover how to automate the process and customize your sheets effectively.

How To Transpose In Google Sheets

Learn how to efficiently switch columns to rows in Google Sheets using the transpose function, and discover how to create dynamic matrices that automatically update when changes are made.

Stop Formatting Cells. Format Inside the Formula Instead

Learn how to format numbers as currency within a formula in Google Sheets, ensuring your totals display correctly with dollar signs and appropriate formatting.