Spreadsheet fundamentals

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.

Why Download Google Sheet as CSV

In this video, learn how to easily download a Google Sheet as a CSV file using a special URL tool, and discover the benefits of sharing data in this format without needing to send the actual file.

Click, New Sheet

Learn how to create a new sheet in Google Sheets with a fun and interactive method using App Script. This video guides you through the process of duplicating sheets with a click of a button.

How to Remove Your Own Access to a Google Sheet

Learn how to easily remove your own access to a Google Sheet in this quick tutorial. Follow the steps to manage your permissions and ensure you no longer have access to unwanted documents.

How To Create Google Calendar Events in Google Sheets

Learn how to automate the creation of Google Calendar events directly from Google Sheets using a simple Google Apps Script. This tutorial simplifies the process of managing multiple events by allowing you to send selected rows to your calendar effortlessly.

How to Easily Copy Format in Google Sheets

Learn how to efficiently copy formatting in Google Sheets using the paint format feature, allowing you to quickly apply styles without altering the data.

How to Delete Rows in Google Sheets

Learn how to efficiently delete rows in Google Sheets using various methods, including right-click options, keyboard shortcuts, and Apps Script functions.

How to Indent Google Sheets

Learn how to effectively indent tasks in Google Sheets to create a clear hierarchy and improve organization. This video covers multiple methods, including using custom number formats and helper columns.

How To Sum Random Cells in Google Sheets

Learn how to sum random cells in Google Sheets using various methods, including the SUM formula and INDEX function, to create dynamic calculations for your data analysis.

Find Untitled Spreadsheets With Data In Your Google Drive

Learn how to locate untitled spreadsheets in your Google Drive that contain valuable data, ensuring you never lose track of important information again.

Change Row Color When Payment Received

Learn how to change the row color in Google Sheets when a payment is received using conditional formatting. This quick tutorial will guide you through creating a dropdown menu and applying the formatting rule effectively.

Auto Increment Invoice Numbers So The Sheet Remembers!

Learn how to automatically increment invoice numbers in Google Sheets using Apps Script, ensuring your sheet remembers the last used number even after changes.

How to Write Personalized DM Messages in Google Sheets

Learn how to create personalized direct message templates in Google Sheets using simple functions and formulas to streamline your outreach on LinkedIn.

How to Capitalize Names Automatically in Google Sheets

Learn how to automatically capitalize names in Google Sheets using Google Apps Script. This tutorial walks you through creating a function that formats names correctly as you edit them.

How to Automatically Cross Off Completed Tasks

Learn how to automatically cross off completed tasks in Google Sheets using conditional formatting for a cleaner and more organized look.

Autofill Today's Date When Cell Edited

Learn how to automatically fill in today's date in Google Sheets when a cell is edited, using Google Apps Script. This tutorial simplifies the process of tracking status changes without manual entry.