Our mission is to help make Google Sheets feel more magical. One of the ways we’re doing this is through releasing various videos on YouTube regularly. Check out our most recent videos below:

Ever wanted to add website-style navigation to your Google Sheet? Check out an easy method to add a top navigation bar to your Google Sheets in this quick tutorial.
Adding a Top Navigation Bar in Google Sheets
Ever wanted to download pictures from Google Sheets to your computer, but not sure how? I go through each method for the different ways images can be incorporated into Google Sheets.
Download Images or Pictures from Google Sheets
Ever wished you could check or uncheck more than one checkbox at a time? Learn how to check or uncheck a row, a column, a selection, or an entire tab with a single click.
Stop Ticking Checkboxes One at a Time in Google Sheets
In this video, I'm going to show you how to set up an appointment or event registration or booking system when you have limited slots available for each time slot. We use Google Forms to show the available slots and allow guests or users to select and sign up, and then Google Sheets & Google Apps Script to manage the events and update what options are available on the Google Form, and then finally, I show you how to add events to Google Calendar in case you want to create a Google Calendar event for each registration (maybe where you want to send them a video meeting link or something like that). You can create a copy of the final demo copy here: https://bit.ly/41BkOUO 0:00 - Intro 0:45 - Google Sheets Initial Setup 8:59 - Google Form Setup 10:30 - Create Apps Script & Finish Google Sheet Setup to Automatically Update Appointment Options on Form 19:49 - Demo of Initial System 21:24 - Adding/Updating New Events 24:06 - Adding Events to Google Calendar
Let's Create an Automatic Appointment Slot Booking System in Forms, Sheets, and Calendar
Let's walk through how to quickly hide or show all rows matching a particular criteria in Google Sheets just by clicking a checkbox. You can make a copy of the Google Sheet / Script here: https://bit.ly/3Z5nOWU
Toggle Show / Hiding All Rows Meeting Condition
Ever need to generate reports from data in Google Sheets with totals, but you're tired of doing it manually? In this video, I walk you through how to quickly and easily set up a dynamic report template and incorporate a totals calculation right into the formula. You can make a copy of the sample file here: https://bit.ly/3Bm2CUA
Easily Generate Dynamic Report with Totals in Google Sheets
Every need to automatically delete a row in Google Sheets based on a checkbox or a particular selection in a dropdown? In this video, I show you how to accomplish this with a simple script.
Automatically Delete Row from a Checkbox or Dropdown in Google Sheets
Do you need to auto-populate a value in a cell based on a selection in the same row, but can't use a formula because that value changes and you don't want prior data overwritten? I walk you through creating a quick & easy script that will solve that exact problem, and bonus is this script doesn't even have to be authorized! You can make a copy of the final Google Sheet & script here: https://bit.ly/4fFlMUs
Auto-populate Cell Based on Dropdown Selection in Google Sheets
If you're ready for a full, detailed walkthrough on how to build a dynamic sales dashboard, then check out this video that takes you from a simple data tab all the way to a fully-functioning dynamic dashboard. If you want to skip the video and just get the Google Sheet, you can buy the template here for only $1.99: https://sheets-ninja-shop.fourthwall.com/products/dynamic-sales-dashboard-in-google-sheets
Creating a Sales Dashboard in The Office - Full Tutorial Walkthrough
Load More... Subscribe