Spreadsheet fundamentals

Download Google Sheets

Learn how to easily download Google Sheets in various formats, including PDF and CSV, and discover some hidden tricks to share and copy sheets effortlessly.

Auto Count Length

Learn how to automate character counting in Google Sheets using both a formula and Google Apps Script in this informative video. Discover how to streamline your workflow and eliminate the need for visible formulas.

Automate Upper Case

Learn how to automate upper casing in Google Sheets using Google Apps Script, allowing text in one column to automatically appear in uppercase in another column.

Highlight Unique Values

Learn how to highlight unique values in your data using conditional formatting in Google Sheets, specifically focusing on identifying customers who have made only one purchase.

Highlight Below Average

Learn how to highlight numbers below average in Google Sheets using conditional formatting and custom formulas.

UnMerge Automatically Google Sheets

Learn how to automatically unmerge cells in Google Sheets using a simple Apps Script function that runs on a timer, ensuring your sheet stays organized without manual intervention.

Automate Adding Prefix in Cell

Learn how to automate adding a prefix to cells in Google Sheets using formulas and Google Apps Script, making it easier to create unique identifiers for your projects.

Quickly Highlight Long Text

Learn how to quickly highlight long text in Google Sheets using conditional formatting based on character length. This tutorial guides you through the steps to set up custom formulas for effective text management.

Highlight Above Average

Learn how to highlight cells in Google Sheets that are above average using conditional formatting. This quick tutorial guides you through the steps to apply custom formulas for effective data visualization.

Create Dropdown Menu

Learn how to create a dropdown menu in Google Sheets with this quick tutorial. Discover tips for adding options and color coding your selections.

Timestamp Column in Google Sheets

Learn how to create a timestamp column in Google Sheets that automatically updates whenever you edit a cell in that column using Google Apps Script.

Start Sheeting Better in 2026

In this video, learn how to enhance your Google Sheets for better readability and data visualization in 2026, with tips on formatting, alignment, and conditional formatting.

Click Checkbox to Copy to Tab in Google Sheets

Learn how to use Google Sheets and Apps Script to copy data from one tab to another when a checkbox is checked. This tutorial covers the necessary code and logic to automate the process seamlessly.

One Click New Sheet

Learn how to quickly create a new Google Sheet using the 'sheet new' command and streamline your workflow with bookmarks for easy access.

Cumulative Subtraction in Google Sheets

Learn how to perform cumulative subtraction in Google Sheets to effectively track your salary against monthly expenses. This tutorial provides step-by-step guidance on setting up your spreadsheet for accurate financial management.

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.