Spreadsheet fundamentals

How to Create 64 Team Bracket in Google Sheets

Learn how to create a 64 team tournament bracket in Google Sheets, similar to the NCAA basketball tournament format. This tutorial covers merging cells, adding borders, and customizing your bracket layout.

Create Rolling Dice in Google Sheets

Learn how to create a rolling dice feature in Google Sheets using randomization techniques and App Script. This tutorial covers everything from basic random number generation to creating interactive buttons for rolling multiple dice.

Download Sheet by Clicking Image in Google Sheets

Learn how to create a clickable image in Google Sheets that allows users to easily download the sheet as a CSV file. This tutorial simplifies the process of sharing data through a visually appealing button.

SearchLord One Sheet to Search Them All

In this video, discover how to use the SearchLord app within Google Sheets to efficiently search across multiple websites using customizable keywords. Learn how to enhance your Google Sheets experience with features like checkboxes and custom menus for streamlined searches.

Move Row Based on Dropdown

Learn how to effectively manage tasks in Google Sheets by moving entire rows based on dropdown selections, creating a simple CRM or task list with different priority tabs.

Take Attendance in Google Sheets

Learn how to take attendance in Google Sheets using a custom script that simplifies the process with alerts and checkboxes. This tutorial covers automating daily attendance tracking and creating a user-friendly interface.

How To Get Random Number Every Minute in Google Sheets

Learn how to set Google Sheets to generate a random number every minute without any coding. This simple adjustment can add dynamic updates to your spreadsheets effortlessly.

How To Refresh Google Sheets Every Minute or Hour

Learn how to refresh Google Sheets every minute or hour to keep your data up-to-date with this quick tutorial. Discover tips on using Google Finance for real-time stock prices and currency exchange rates.

How to Get Link to a Range in Google Sheets

Learn how to create links to specific ranges in Google Sheets, making it easier to share precise locations within your spreadsheets with others.

How to Move a Cell in Google Sheets

Learn how to easily move cells in Google Sheets using drag-and-drop or keyboard shortcuts. This video provides practical tips to enhance your Google Sheets experience.

Automatic Weekly Calendar View

Learn how to create an automatic weekly calendar view in Google Sheets that updates with your events, making it easy to visualize your schedule for the week ahead.

Create Reminders Daily to Check Sheet EMAIL CALENDAR TASK

Learn how to set up daily reminders to check your Google Sheets through email, Google Calendar, and Google Tasks using Google Apps Script. This tutorial walks you through creating automated notifications to ensure you never miss an important update.

How To Insert Image Inside a Cell in Google Sheets

Learn how to insert images directly into cells in Google Sheets, including methods for uploading images and using URLs. This video provides step-by-step instructions to enhance your spreadsheet with visual elements.

How To Insert Image Over Cells in Google Sheets

Learn how to insert an image over cells in Google Sheets, allowing for creative designs like banners or drawings while maintaining data visibility. This tutorial also covers how to assign scripts to images for automation.

How To Set Print Page Breaks In Google Sheets

Learn how to set print page breaks in Google Sheets to effectively manage your print layout and ensure your data is organized across multiple pages.

How To Print Selected Cells In Google Sheets

Learn how to print selected cells in Google Sheets and export them as a PDF with this quick tutorial. Get tips on customizing your print settings for a more tailored output.

How To Print Google Sheets On One Page

Learn how to print your entire Google Sheets workbook on one page, including all tabs, by exporting it as a PDF with customized headers.

How To Change Margins In Google Sheets

Learn how to adjust margins in Google Sheets for printing, including options for normal, narrow, and wide margins, as well as custom settings for your specific needs.

How to Delete Bottom Rows of a Google Sheet, SO ANNOYING

Learn a quick and efficient method to delete unwanted bottom rows in Google Sheets, making your spreadsheets cleaner and easier to navigate.

Daily Countdown Email from Google Sheets

Learn how to set up a daily countdown email reminder using Google Sheets and Apps Script, ensuring you never miss an important date again.

Add Formula When Form Submitted

Learn how to automatically add formulas to your Google Sheets when a form is submitted using Google Apps Script. This tutorial covers creating a function and setting up triggers to streamline your data processing.

How To Change Cell Size In Google Sheets

Learn how to easily change the cell size in Google Sheets by adjusting row and column dimensions to create the perfect layout for your data.

How To Separate First And Last Name In Google Sheets

Learn how to easily separate first and last names in Google Sheets using the SPLIT function and other methods. This video provides quick tips and tricks to streamline your data management.

How To Underline In Google Sheets

Learn how to underline text in Google Sheets using simple keyboard shortcuts and creative border techniques to enhance your spreadsheet's appearance.