Spreadsheet fundamentals

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.

How to Hide Text Until Checkbox Checked

Learn how to hide text in Google Sheets until a checkbox is checked using the IF formula. This tutorial provides a step-by-step guide to create dynamic messages based on checkbox states.

what you need to know to automate Google Sheets

what you need to know to automate Google Sheets

How To Highlight Timestamps This YEAR

Learn how to highlight timestamps in Google Sheets that correspond to the current year using conditional formatting. This quick tutorial will enhance your spreadsheet skills and help you manage your data more effectively.

How To Highlight Timestamps This Month

Learn how to highlight timestamps or dates that fall within the current month using conditional formatting in Google Sheets. This tutorial provides a step-by-step guide on applying a custom formula to achieve this.

How To Highlight Timestamps Last Month

Learn how to highlight timestamps from the previous month using Google Sheets formulas and conditional formatting techniques. This tutorial walks you through the necessary steps to effectively apply these formulas in your spreadsheets.

How To Highlight Timestamps Over 7 Days Ago

Learn how to highlight timestamps in Google Sheets that are over seven days old using conditional formatting and custom formulas.

How To Calculate Days Since Timestamp in Google Sheets

Learn how to calculate the number of days since a timestamp in Google Sheets using two different formulas, one for exact numbers and another for rounded results.

Automatically Add Formula When Editing Row

Learn how to automatically add formulas in Google Sheets when editing a row using Apps Script. This tutorial covers creating dynamic formulas that adjust based on user input.

How to Highlight Any Date In the Future in Google Sheets

Learn how to highlight any future date in Google Sheets using conditional formatting. This tutorial covers step-by-step instructions to highlight entire rows based on date criteria.