Spreadsheet fundamentals

How to Filter View by Month for Dashboards in Google Sheets

Learn how to create a filter view by month in Google Sheets, allowing you to easily analyze data for specific months using VLOOKUP and dropdown menus.

How To Filter by Date in Google Sheets

Learn how to effectively filter data by date in Google Sheets, creating a dynamic dashboard that allows you to view specific date ranges with ease.

How to Clear Formatting Automatically in Google Sheets

Learn how to automatically clear formatting in Google Sheets every day, ensuring a fresh start with default settings. This tutorial guides you through creating a script and setting up triggers for seamless automation.

List Every File In Your Google Drive

Learn how to programmatically log every file in your Google Drive using Google Sheets and Apps Script. This tutorial walks you through creating a function that retrieves file names and IDs efficiently.

How to Create a Google Folder in Folder in a Google Drive in Apps Script

Learn how to create nested folders in Google Drive using Google Apps Script, directly from your Google Sheets. This tutorial walks you through the process of automating folder creation with dynamic names sourced from your spreadsheet.

How to Fill Right Text

Learn how to efficiently fill cells to the right in Google Sheets using the command R shortcut. This video tutorial provides tips and tricks to enhance your spreadsheet skills.

How To Fill Down Formulas

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

How To Fill Range with Top Left Text

Learn how to efficiently fill an entire range in Google Sheets using the command enter method, saving time and clicks compared to traditional methods.

How To Reference Another Spreadsheet in Google Sheets

Learn how to reference another spreadsheet in Google Sheets by using the IMPORT RANGE function to pull data from different workbooks into your dashboard.

How to Reference Another Sheet in Google Sheets

Learn how to reference another sheet in Google Sheets effectively, including how to handle spaces in sheet names and create a dashboard that summarizes data from multiple sheets.

Highlight Text In a Cell in Google Sheets

Learn how to highlight specific text within a cell in Google Sheets using text color and formatting options. This quick tutorial covers essential tips for making your data stand out.

Select a Word, Get a Number in Google Sheets with a VLOOKUP Table

Learn how to use a dropdown menu and VLOOKUP function in Google Sheets to select an exercise and automatically retrieve the corresponding calories burned per hour. This tutorial simplifies the process into three easy steps for efficient tracking of your daily activities.

Log Every Time a Google Sheet is Opened

Learn how to log every time a Google Sheet is opened using Google Apps Script. This tutorial covers creating a logging function that captures timestamps and user information.

Better CONCATENATE for Combining Strings

Discover a better way to combine strings in Google Sheets using the ampersand method instead of the traditional CONCATENATE function. This video explores the limitations of CONCATENATE and introduces simpler alternatives for effective text manipulation.

How to Check for Conditional Formatting in Google Sheets

Learn how to easily check for conditional formatting in Google Sheets by examining text and fill colors, and discover how to manage your conditional formatting rules effectively.

How to Change Checkbox Value in Google Sheets

Learn how to customize checkbox values in Google Sheets from true/false to any text you prefer, such as 'approved' or 'not yet approved'. This video guides you through the steps to set up custom values for checkboxes effectively.

Add Table to Google Sites

Learn how to effectively add a table from Google Sheets to your Google Site by embedding it with an iframe, ensuring accessibility while maintaining data protection.

Sort Column in Google Sheet AUTOMATICALLY!

Learn how to automatically sort columns in Google Sheets using various methods, including manual sorting, formulas, and Google Apps Script triggers.

Quickly Add Text In Front of Text with Apps Script

Learn how to automatically add text in front of existing text in Google Sheets using Apps Script, including creating a custom menu for easy access.

How to Automatically Number Rows in Google Sheets

Learn how to automatically number rows in Google Sheets using the ROW and SEQUENCE functions, making data management easier and more efficient.

Create Google Form Automatically

Learn how to automate the creation of Google Forms directly from Google Sheets with just a few clicks. This video guides you through building a custom menu using Google Apps Script, making it easy to share templates with others.

How To Randomize a Sequence in Google Sheets

Learn how to randomize a sequence in Google Sheets using the sequence function and the randomized range feature. This tutorial provides step-by-step instructions for creating a random number sequence efficiently.

Find Your Spreadsheet ID in Google Sheets

Learn how to find the unique ID of your Google Sheets document and its individual tabs, which is essential for various functionalities and integrations.

How to Share Without Letting Others Edit your Google Sheets

Learn how to share your Google Sheets without allowing others to edit by using viewer or commenter permissions, and discover how to create a view-only copy of your sheet using the import range function.