Spreadsheet fundamentals

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.

How To Highlight Any Date One Week In Future

Learn how to highlight dates in Google Sheets that fall between 7 and 14 days in the future using conditional formatting. This tutorial provides step-by-step instructions to customize your date highlighting effectively.

How to Track Days Since Task Started in Google Sheets

Learn how to track the days since a task started in Google Sheets by automating date entries and calculating the difference using formulas and Google Apps Script.

How to Find and Replace Only Two Letters in Google Sheets

Learn how to effectively find and replace specific letters in Google Sheets, ensuring accuracy by matching entire cell contents. This tutorial covers the steps to replace initials like 'QA' with their full form, 'quality assurance'.

How To Find and Replace Text in Google Sheets

Learn how to efficiently find and replace text in Google Sheets, ensuring consistent formatting across your data. This tutorial covers the use of the find and replace menu, case matching, and searching within specific ranges.

How to do Exponents in Google Sheets

Learn how to perform exponentiation in Google Sheets using simple multiplication, the caret symbol, and the POWER function for more flexibility and ease. This video provides practical examples to enhance your spreadsheet skills.

How to Search Tab Names in Google Sheets

Learn how to efficiently search for tab names in Google Sheets using a simple app script, making it easier to navigate through numerous tabs in your spreadsheet.

How to Hide Cell Values Based on Checkbox or Dropdown

Learn how to hide cell values in Google Sheets using checkboxes or dropdowns based on specific criteria, enhancing your spreadsheet's functionality and user experience.

How to Enter New Line in Google Sheets

Learn how to easily insert new lines within a cell in Google Sheets, enhancing your note-taking and text organization without relying solely on text wrapping.

How to Insert Timestamp in Google Sheets

Learn how to insert timestamps in Google Sheets to track when tasks are completed, using both simple date entries and more complex timestamp functions with Google Apps Script.

Make Your Google Sheet A Template For Others To Copy

Learn how to turn your Google Sheet into a template that others can easily copy by adjusting the sharing settings and modifying the link. This video provides a step-by-step guide to streamline the process for users.

How To Download All Tabs as CSV in a Zip File

Learn how to download all tabs from a Google Sheet as CSV files in a zip file using Google Apps Script. This tutorial provides a simple solution to streamline the process and save time.

How To Divide in Google Sheets

Learn how to divide numbers in Google Sheets using various methods, including the divide formula and referencing cells for dynamic calculations.

How do I add multiple links in a Google sheet cell?

Learn how to add multiple hyperlinks within a single cell in Google Sheets, making your data more interactive and organized. This tutorial covers the steps to insert and remove links efficiently.

How To Fill Down Formulas

Learn how to efficiently fill down formulas in Google Sheets using quick methods like double-clicking the fill handle or using the Command D shortcut. This video provides practical tips to save time when working with large datasets.

YOU CAN DO BETTER

Learn how to enhance your spreadsheets with simple design tips, including font selection and custom colors, to make them visually appealing and more effective.