Spreadsheet fundamentals

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.

How to Get People to Fill in Google Forms Faster

Learn a powerful Google Sheets trick to create pre-filled Google Forms that make it easier and faster for respondents to fill them out by automatically including their email addresses.

How to Highlight Edited Cells

Learn how to highlight edited cells in Google Sheets using Apps Script, allowing you to visually track changes with a simple function.

How To Wrap Text in Google Sheets

Learn how to easily wrap text in Google Sheets using menu options and shortcuts to enhance your spreadsheet formatting.

How To Subtract in Google Sheets

Learn how to effectively subtract numbers in Google Sheets using various methods, including the basic subtraction formula and the use of absolute values to find differences.

How to Create URL to SMS a Phone Number in Messages from Google Sheets

Learn how to create a URL that allows you to send SMS messages directly from Google Sheets by formatting phone numbers correctly. This tutorial covers the use of the HYPERLINK function and how to handle common formatting issues.