Spreadsheet fundamentals

How Many Days Until Christmas

Learn how to automatically calculate the number of days until Christmas using Google Sheets formulas, including the DATE_DIFF function and error handling techniques.

Simplify Data Organization with the IFS Function in Google Sheets

Learn how to simplify data organization in Google Sheets using the IFS function to manage class choices effectively. This video demonstrates how to implement the IFS function for multiple conditions and handle errors gracefully.

How to Know the Day of the Week of Any Date

Learn how to determine the day of the week for any date using Google Sheets with two simple methods: utilizing the WEEKDAY formula and custom date formatting.

How to Send Bulk Emails from Google Sheets with Apps Script

Learn how to send bulk emails directly from Google Sheets using Apps Script in this informative tutorial. This video guides you through the process of coding a function to automate email sending to a list of recipients.

How to Get Middle Name from Splitting Full Name in Google Sheets

Learn how to extract middle names from full names in Google Sheets by using the SPLIT function and INDEX to handle names with varying lengths.

How To Plan An Event's Day Based on Individual Schedules

Learn how to effectively plan an event by analyzing individual schedules using a heat map in Google Sheets. This video guides you through creating a structured rubric to determine the best days for your event based on participant availability.

How to Allow only PDF File Type Upload to a Google Form

Learn how to restrict file uploads in Google Forms to only allow PDF files, ensuring that users submit the correct file type for your needs.

How to Edit a Google Form Question

Learn how to easily edit questions in your Google Form connected to Google Sheets, including changing response types and data validation settings.

How to Re Order Google Form Responses

Learn how to reorder Google Form responses in your linked Google Sheets, ensuring your data is organized as needed. This tutorial provides a step-by-step workaround to adjust the order of columns in your responses.

How to Create a Google Form With Yes or No

Learn how to create a Google Form with simple Yes or No questions, perfect for gathering responses from attendees. This video covers various question types and how to link responses to a spreadsheet.

How to Fix Broken Checkboxes (Getting Invalid?)

Learn how to fix broken checkboxes in Google Sheets that show as invalid due to formatting issues. This quick guide will help you ensure your checkboxes function correctly by adjusting their format settings.

Help! I deleted my spreadsheet!

Learn how to recover a deleted spreadsheet from the trash in this quick tutorial. Follow these simple steps to retrieve your lost files effortlessly.

How to Insert Multiple Rows in Google Sheets

Learn how to easily insert multiple rows in Google Sheets, whether manually or by recording a macro for repetitive tasks. This tutorial covers selecting rows and automating the process for efficiency.

How to Multiply in Google Sheets

Learn how to effectively multiply numbers in Google Sheets using both the asterisk operator and the multiply function. This tutorial covers essential techniques for estimating sales and formatting results.

How to Make a Bar Chart in Google Sheets

Learn how to create a bar chart in Google Sheets with this step-by-step tutorial, including tips on customizing your chart for better visualization.

How to Split Cells in Google Sheets

Learn how to efficiently split cells in Google Sheets using the SPLIT formula, allowing you to separate data based on specified delimiters like commas or semicolons.

How to UnFreeze Columns in Google Sheets

Learn how to easily unfreeze columns in Google Sheets with simple steps, ensuring your data remains accessible and organized.

How to Freeze Columns in Google Sheets

Learn how to freeze columns in Google Sheets to keep important data visible while scrolling. This quick tutorial covers multiple methods to achieve this functionality.

How to UnFreeze a Row in Google Sheets

Learn how to easily unfreeze a row in Google Sheets with simple steps, including using the cursor and the View menu options.

How to Freeze a Row in Google Sheets

Learn how to freeze rows in Google Sheets to keep your header visible while scrolling. This video covers multiple methods to freeze rows effectively.

How To Sum A Column In Google Sheets

Learn how to effectively sum a column in Google Sheets with tips on avoiding common errors and utilizing different referencing techniques.

How To Make Pie Chart In Google Sheets

Learn how to create a visually appealing pie chart in Google Sheets using lunch choice data, including steps for customizing colors and labels.

How to Send Feedback to Google Sheets

Learn how to effectively send feedback to Google Sheets, including reporting issues and suggesting new features directly from your spreadsheet. This video provides step-by-step instructions to enhance your experience with Google Sheets.

How to Make Headers Great with Big Name, Little Data

Learn how to effectively adjust header sizes in Google Sheets using rotation techniques to enhance readability and presentation.