Spreadsheet fundamentals

Create New Tab For Each Google Form Submission

Learn how to create a new tab for each Google Form submission using Apps Script, perfect for organizing data like employee onboarding. This tutorial covers creating a form, writing the script, and setting up triggers to automate the process.

How to Zoom in and Out of Google Sheets

Learn how to easily zoom in and out of Google Sheets on both Mac and PC, as well as discover tips for maximizing your workspace by hiding menus and using full screen mode.

How to List Every Monday This Year

Learn how to list every Monday of the year using Google Sheets with simple formulas and formatting techniques. This tutorial provides a step-by-step guide to create a complete list of Mondays for any given year.

How to List Every Day This Year in Google Sheets

Learn how to automatically list every day of the year in Google Sheets using a simple formula. This tutorial demonstrates how to generate a complete list of dates from January 1st to December 31st, updating dynamically each year.

How to List Every Day This Month in Google Sheets

Learn how to automatically list every day of the current month in Google Sheets using formulas like EOMONTH and TODAY. This tutorial simplifies the process of generating a dynamic date list that updates each month.

Automatically Highlight Upcoming Deadlines in Google Sheets

Learn how to automatically highlight upcoming deadlines in Google Sheets using conditional formatting and custom formulas. This video covers various methods to track tasks due this week, month, or within the next few days.

How to Create a Timeline Quickly in Google Sheets

Learn how to quickly create a timeline in Google Sheets using its new feature, which allows you to visualize tasks and their due dates effectively. Discover how to group tasks by priority and customize your timeline for better project management.

How to Get Last Day of the Month in Google Sheets

Learn how to easily find the last day of the month in Google Sheets using the EOMONTH function. This quick tutorial will help you automate date calculations for any month.

How to Get First of the Month in Google Sheets

Learn how to easily find the first day of the month in Google Sheets using a simple formula that leverages the EOMONTH function. This video provides a quick and effective method to retrieve the first date of the current, previous, or next month.

Create a Tab for Every Month in Google Sheets with Apps Script

Learn how to create a tab for every month in Google Sheets using Apps Script, allowing for automated organization of your spreadsheets by month and year.

How to Get Kanban Board To Show Multiple Columns

Learn how to enhance your Kanban board in Google Sheets by displaying multiple columns, including assignee names, priorities, and due dates, using filters and array formulas.

How to Clear Cell Content in Google Sheets

Learn how to efficiently clear cell content in Google Sheets without affecting formatting, including options for deleting values, rows, and columns.

How to Search for Word in Multiple Selection Dropdown Cell in Apps Script

Learn how to search for a specific word within a multiple selection dropdown cell using Google Apps Script, enhancing your Google Sheets functionality.

How To Print Empty Gridlines In Google Sheets

Learn how to print empty gridlines in Google Sheets by removing existing gridlines and using custom borders for a cleaner presentation. This tutorial guides you through the steps to achieve a professional look for your printed documents.

Add Dropdown When Google Form Submitted to Google Sheets

Learn how to automatically add dropdown menus to Google Sheets when a Google Form is submitted, allowing for better categorization of responses.

How To Remove Grid Lines In Google Sheets

Learn how to remove gridlines in Google Sheets to enhance your spreadsheet's appearance and functionality. This video covers the steps to hide gridlines and add custom borders for a more polished look.

How To Color Code Data Validation In Google Sheets

Learn how to effectively color code data validation in Google Sheets by creating a dropdown menu with customizable color options for different statuses. This tutorial will help you enhance your spreadsheet's visual organization.

Who Can I Email From a Google Sheet

Learn how to send emails directly from Google Sheets using Apps Script, including how to email the sheet owner, active users, and form respondents.

Leap Year in Google Sheets

Learn how to determine if a year is a leap year in Google Sheets using clever formulas and Apps Script. This video covers practical methods to identify leap years, which can be essential for financial and HR applications.

How To Calculate Average in Google Sheets

Learn how to calculate the average in Google Sheets, including how to use the AVERAGEIF function to average only completed tasks. This video provides practical examples to enhance your Google Sheets skills.

How to Change Column Width in Google Sheets

Learn how to effectively change column widths in Google Sheets with practical tips and tricks to enhance your spreadsheet layout.

How To Color Code Google Sheets

Learn how to effectively color code your Google Sheets using conditional formatting based on dropdown menus or specific text within cells. This tutorial covers step-by-step methods to enhance your spreadsheet's visual organization.

How to Find Out Whose Birthday is This Month in Google Sheets

Learn how to easily highlight birthdays in Google Sheets that fall within the current month using conditional formatting and custom formulas.

MORE Simple Task Management Automations in Google Sheets

In this video, learn how to enhance your task management in Google Sheets with simple automations, including calculating days until due, auto-inserting timestamps for task statuses, and setting up automatic sorting by due date.