Spreadsheet fundamentals

Highlight EVEN or ODD Columns

Learn how to highlight every other column in Google Sheets using conditional formatting and custom formulas to easily differentiate between odd and even columns.

Get Word Count of Google Sheet

Learn how to create a custom word count function in Google Sheets using Apps Script. This tutorial guides you through setting up a menu to easily count words in the current sheet or the entire document.

Highlight Every Other Column

Learn how to automatically highlight every other column in Google Sheets using conditional formatting with a simple custom formula. This quick tutorial will enhance the visual appeal of your spreadsheets.

Auto Sort By Priority

Learn how to automatically sort your Google Sheets by priority using VLOOKUP and Google Apps Script. This video provides a step-by-step guide to set up priority sorting that updates with every edit.

Automation is not Magic

In this video, learn how to create quick automations in Google Sheets using formulas and App Script, making your spreadsheets feel like magic without the complexity. Discover practical examples like filtering data and tracking last edits with timestamps.

Auto Sort By Last Edited Date

Learn how to automatically sort your Google Sheets by the last edited date using a simple app script. This tutorial covers creating timestamps and sorting functions to enhance your spreadsheet automation.

Christmas Tree in Google Sheets

Learn how to create a minimalist Christmas tree design in Google Sheets with this step-by-step tutorial. Perfect for adding a festive touch to your spreadsheets!

Insert Row Daily Automatically

Learn how to automatically insert a new row daily in Google Sheets using Apps Script, ensuring your task list stays fresh and formatted correctly without manual effort.

Auto Sort By Date

Learn how to automatically sort tasks by date in Google Sheets using Google Apps Script. This tutorial covers setting up triggers to keep your tasks organized without manual intervention.

How to Create a Custom Automation Menu in Google Sheets

Learn how to create a custom automation menu in Google Sheets using App Script, allowing users to easily access functions and links directly from the spreadsheet interface.

3 Most Important Keyboard Shortcuts

Discover the three most essential keyboard shortcuts for Google Sheets that can significantly enhance your productivity. Learn how to navigate data efficiently, paste values without formulas, and create links seamlessly.

How to Retype Header Automatically

Learn how to automatically retype your header row in Google Sheets using a simple script, ensuring your data remains organized even if the header is accidentally deleted or altered.

Add New Task when Task Completed

Learn how to automate your Google Sheets task list by adding new tasks when a task is completed using Google Apps Script. This video guides you through the process step-by-step, ensuring you can manage your to-do list efficiently.

Enter Google Drive File Name Get URL in Google Sheets

Learn how to automate the process of retrieving a Google Drive file URL by entering its name in a Google Sheets cell using Google Apps Script. This video provides a step-by-step guide to streamline your workflow.

How to Prevent Delete Tab

Learn how to prevent users from accidentally deleting important tabs in Google Sheets by using protective measures and backup scripts. This video covers various methods to safeguard your data effectively.

How To Enable Excel Shortcuts in Google Sheets

Learn how to enable Excel keyboard shortcuts in Google Sheets to enhance your productivity and streamline your workflow. This quick tutorial will guide you through the simple steps to make your Google Sheets experience more familiar if you're coming from Excel.

How to Get Every Editor on Every Google File I Own

Learn how to find every Google Drive file you've shared with editors, including spreadsheets and documents, using Google Apps Script. This tutorial provides a step-by-step guide to retrieve and manage your shared files effectively.

How to Highlight Today Only in Conditional Formatting

Learn how to highlight only today's date in a Google Sheets calendar using conditional formatting, effectively blacking out all other dates for a focused view.

Automatic Email Report from Google Sheets

Learn how to automate weekly email reports from Google Sheets, summarizing key data like tasks completed and hours worked by department. This tutorial covers setting up a single tab for data entry and using Google Apps Script to send automated emails every Friday.

First 3 Letters of the Month in Google Sheets

Learn how to extract the first three letters of each month in Google Sheets using a simple formula. This video demonstrates a fun and efficient way to display month abbreviations for the entire year.

Daily Planner Template Automated

Learn how to create an automated daily planner in Google Sheets that consolidates your tasks into one tab, making it easier to manage your daily activities without the clutter of multiple tabs.

Make a Simple Calendar Template

Learn how to create a simple and customizable calendar template in Google Sheets that you can print and use for various purposes. This tutorial covers essential formulas and formatting techniques to make your calendar functional and visually appealing.

17 Minutes of Google Sheet Business Ideas

Explore innovative business ideas centered around Google Sheets and available domain names in this video. Discover how to leverage existing workflows and create valuable tools for various industries using Google Sheets.

How To Reference Another Sheet in Conditional Formatting

Learn how to reference another sheet in Google Sheets for conditional formatting using the INDIRECT formula, allowing for dynamic weekend adjustments in your calendar.