Spreadsheet fundamentals

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.

Mini Calendar

Learn how to create a mini calendar in Google Sheets that displays the current month's dates in a compact format. This tutorial covers the necessary formulas and formatting techniques to make your calendar functional and visually appealing.

2 Forms 1 Sheet

Learn how to use two forms in one Google Sheet and automate email notifications for form submissions using Google Apps Script.

How To Go To Next Line In Google Sheets

Learn how to efficiently navigate and edit data in Google Sheets using keyboard shortcuts, including how to jump to the last filled cell in a column.

Free 2026 Yearly Calendar Template

Discover how to create a free yearly calendar template in Google Sheets with the Big Year template, designed for easy planning and visibility of the entire year in one tab.

Download Cell as a PDF Quickly in Google Sheets

Learn how to quickly download a specific cell from Google Sheets as a PDF using a specially formatted URL, streamlining the process without navigating through multiple menus.

How to Get Top 3 Maximum Numbers in Google Sheets

Learn how to find the top three maximum numbers in Google Sheets using the LARGE function, along with VLOOKUP and INDEX MATCH for better data management.

How to Automatically Add Numbers When There is Data, Not Zeros, in Google Sheets

Learn how to automatically sum numbers in Google Sheets while ignoring zeros, keeping your inventory data clean and concise.

Copy Paste Data Validation to Other Spreadsheet File in Google Sheets

Learn how to effectively copy and paste data validation rules from one Google Sheets file to another, overcoming common errors and ensuring your dropdowns work seamlessly across spreadsheets.

How To Count Checkboxes In Google Sheets

Learn how to effectively count checkboxes in Google Sheets using the COUNTIF and SUM functions, and discover a fun way to customize checkbox values.