Spreadsheet fundamentals

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.

Simple Task Management Automations

Learn how to automate task management in Google Sheets with dropdown menus, conditional formatting, and email reminders to streamline your workflow and enhance productivity.

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

Learn how to quickly identify and highlight birthdays occurring this month in Google Sheets using conditional formatting and custom formulas.

How To Print Google Sheets

Learn how to print Google Sheets effectively by exporting them as PDFs with customizable settings for optimal formatting. This video covers essential options like scaling, margins, and headers to enhance your printed documents.

How To Create A Drop Down List In Google Sheets

Learn how to create a drop down list in Google Sheets, including how to color code the months and use a range for dynamic updates. This tutorial covers both manual entry and using a settings sheet for easier management.

HR Automations Employee Tracker in Google Sheets

Learn how to create an automated employee tracker in Google Sheets, featuring formulas for tenure calculation, conditional formatting for highlighting, and generating review dates for HR management.

How To Rename Columns In Google Sheets

Learn how to effectively rename columns in Google Sheets, including tips on freezing header rows and enhancing visibility for better data management.

How To Add Bullet Points In Google Sheets Quickly

Learn how to quickly add bullet points in Google Sheets to enhance your checklists and text formatting. This video covers the simple keyboard shortcut to insert bullets directly into your cells.

How to Highlight Last Week's Dates in Google Sheets

Learn how to highlight last week's dates in Google Sheets using conditional formatting and custom formulas to enhance your project management.

How to Highlight This Week's Date in Google Sheets with Conditional Formatting

Learn how to highlight dates for the current week in Google Sheets using conditional formatting. This tutorial covers applying custom formulas and adjusting formatting for entire rows.

Spending Tracker Automations in Google Sheets

Learn how to automate your spending tracker in Google Sheets with four powerful automations, including auto date entries, conditional formatting for incomplete rows, monthly totals, and budget alerts via email.

How to Find and Replace a Name in Entire Workbook in Google Sheets

Learn how to efficiently find and replace names or any text across an entire workbook in Google Sheets, ensuring all instances are updated seamlessly.

How to Set Date 30 Days from Now in Google Sheets

Learn how to easily calculate a date 30 days from now in Google Sheets using simple formulas that update automatically every day.

FIX Garbage In, Garbage Out of Google Sheets

In this video, learn how to tackle the 'garbage in, garbage out' problem in Google Sheets by implementing effective data validation techniques to improve the accuracy and reliability of your data.

How to Turn Percentages Into a Progress Bar in Google Sheets

Learn how to create a visually appealing progress bar in Google Sheets using percentages and Sparklines. This tutorial covers step-by-step instructions for enhancing your data representation.

How to Calculate How Many Days in a Year in Google Sheets

Learn how to accurately calculate the number of days in a year using Google Sheets, including handling leap years and creating dynamic formulas that update automatically each year.