Spreadsheet fundamentals

QR codes in Google Sheets

Learn how to easily generate QR codes in Google Sheets using the image formula. This quick tutorial shows you how to create QR codes for URLs and text with just a few simple steps.

How to Highlight Row based on Text in Cell

Learn how to highlight an entire row in Google Sheets based on the text in a specific cell, using conditional formatting and custom formulas.

How To Get Domain from Emails

Learn how to efficiently extract domains from a list of email addresses using Google Sheets, including advanced techniques with REGEX and array formulas for automatic updates.

What's your favorite keyboard shortcut?

Discover the power of keyboard shortcuts, specifically Command + Arrow, to enhance your productivity in Google Sheets. This video demonstrates how to navigate efficiently through your data using simple key combinations.

TIKTOK EDITS MY GOOGLE SHEET

In this video, discover an experiment with a Google Sheet containing one million checkboxes, allowing anyone to edit it and showcasing the performance challenges that arise. Join the fun as viewers interact with the sheet and explore its unique features.

A Student Taught ME This Google Sheets Trick

Discover an unintuitive yet powerful Google Sheets trick that allows you to combine first and last names seamlessly while keeping your formulas intact, even when sorting data.

Caleb Hammer Audits Google Sheets

In this video, Caleb Hammer audits Google Sheets, highlighting common errors like VLOOKUP reference issues and offering tips on formatting and using formulas effectively.

I Built a Product Nobody Wanted

In this video, Andrew Kamphey shares the story of launching SheetOps, a product designed to streamline operations in Google Sheets, which ultimately flopped due to poor marketing and a lack of user feedback. He reflects on the lessons learned and emphasizes the importance of understanding customer needs and effective product naming.

How To Use Importrange In Google Sheets

Learn how to effectively use the IMPORTRANGE function in Google Sheets to pull data from one spreadsheet to another, ensuring your data stays updated without manual copying.

Learned This Google Sheets Trick from a Student

In this video, discover a unique Google Sheets trick for combining first and last names using ARRAYFORMULA in a way that keeps your headers intact and allows for easy manipulation of your data. This unintuitive method will enhance your spreadsheet skills and streamline your workflow.

Why I Left Microsoft Excel

In this video, the creator shares their journey from Microsoft Excel to Google Sheets, highlighting the frustrations and advantages of each platform. They discuss their experiences in automating tasks with Excel and how they transitioned to using Google Sheets for better collaboration and cloud-based functionality.

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.