Spreadsheet fundamentals

Pull Data from Another Sheet based on Criteria in Google Sheets

Learn how to pull data from one Google Sheet to another based on specific criteria, using features like dropdown menus and filters to make your data dynamic and interactive.

Link to Another Sheet in Google Sheets

Learn how to link to another sheet in Google Sheets using various methods, including the IMPORT RANGE function and creating hyperlinks for easy navigation.

How To Use SUMIF In Google Sheets

Learn how to effectively use the SUMIF function in Google Sheets to sum sales data based on specific criteria, such as the month of January.

Create Calendar Event With Natural Language in Google Sheets

Learn how to create calendar events using natural language in Google Sheets and manage them efficiently with a custom menu. This tutorial covers both creating and deleting events seamlessly.

Do GIFs Work in Google Sheets?

Discover how to effectively use GIFs in Google Sheets, including tips on inserting them correctly to ensure they animate as intended.

How To Color Code Rows Based on Drop-down Value

Learn how to color code entire rows in Google Sheets based on dropdown values using conditional formatting. This tutorial provides step-by-step instructions to automate the process for better data visualization.

How To Change Gridlines For Entire Google Sheet

Learn how to easily change the gridlines for your entire Google Sheet, including adjusting thickness, color, and style for a more customized look.

Link In Image in Google Sheets

Learn how to create clickable images in Google Sheets using the hyperlink and image functions. This tutorial provides step-by-step instructions to enhance your spreadsheets with interactive visuals.

How To Use ARRAYFORMULA For Magic

Learn how to use ARRAYFORMULA in Google Sheets to efficiently calculate the revenue from sales without manually copying formulas. This video demonstrates the power of ARRAYFORMULA for handling multiple rows at once.

How To Add Numbers in Google Sheets

Learn various methods to add numbers in Google Sheets, including summing ranges, individual cells, and using the command key for quick calculations.

How to Set Print Area in Google Sheets

Learn how to set a print area in Google Sheets to download only the selected cells as a PDF, excluding unwanted columns like notes or salaries.

How to Auto Increment Numbers in Google Sheets

Learn how to automatically increment numbers in Google Sheets using various formulas, including IF and SEQUENCE, to streamline your data entry process.

How To Hide Rows in Google Sheets

Learn how to easily hide and unhide rows in Google Sheets with this quick tutorial. Master this essential skill to keep your spreadsheets organized and focused.

How to Hide Columns in Google Sheets

Learn how to easily hide and unhide columns in Google Sheets with this quick tutorial. Discover tips for selecting multiple columns to hide at once and streamline your spreadsheet management.

How to Highlight Duplicates in Google Sheets

Learn how to highlight duplicates in Google Sheets using conditional formatting and the COUNTIF function. This tutorial provides a step-by-step guide to easily identify duplicate entries in your data.

How to Use IF Function in Google Sheets

Learn how to effectively use the IF function in Google Sheets to automate commission calculations based on sales amounts. This tutorial guides you through creating logical expressions to determine commission rates.

How to Round Numbers in Google Sheets

Learn how to round numbers in Google Sheets using various methods, including the ROUND, ROUNDUP, and ROUNDDOWN functions, as well as adjusting decimal places directly in the interface.

QR Attendance for Teachers in Google Sheets and Google Forms

Learn how to create a QR attendance sheet for teachers using Google Sheets and Google Forms, enabling easy check-ins with personalized QR codes for each student.

How to Add Multiple Columns with Apps Script

Learn how to add multiple columns in Google Sheets using Apps Script in this informative tutorial. Discover the simple adjustments needed to automate the process and enhance your spreadsheet functionality.

Get Background Hex Code FILL COLOR

Learn how to easily retrieve the background color of a cell in hex code format using a simple custom function in Google Sheets. This tutorial demonstrates the process step-by-step, making it accessible for all users.

How To Email Reminders Before a Deadline in Google Sheets

Learn how to set up email reminders in Google Sheets to notify yourself before deadlines using Google Apps Script. This tutorial covers creating a function to send emails based on due dates and setting up triggers for daily reminders.

Make an INTERACTIVE Pie Chart for PRIORITIES

Learn how to create an interactive pie chart in Google Sheets to visualize your priorities effectively. This tutorial covers the steps to set up your data and customize your chart for real-time updates.

How To Automatically Hide Tabs If Not Owner of Sheet

Learn how to automatically hide tabs in Google Sheets for users who are not the sheet owner, while displaying a welcome message for the owner. This video provides a step-by-step guide using Google Apps Script.

How to Send an Email With a Click in Google Sheets

Learn how to send an email directly from Google Sheets with just a click using Google Apps Script. This tutorial walks you through creating a simple email function that utilizes your spreadsheet data.