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

Do you have some boring data and want to build an impressive report? In this video, I'll take you through, step-by-step, on building a campaign marketing report from a bland set of data. You can download a starter file with sample data so you can follow along here: https://bit.ly/4jUdnyl Or you can download the finished template here: https://bit.ly/4k3yy1k
Step-By-Step Guide to an Impressive Campaign Marketing Report (Google Sheets)
If you're a freelancer, you may need to track and bill time to multiple clients, and this guide will help you to setup a simple and streamlined template. You can make a copy of the sample final template here: https://bit.ly/3Sz4WfQ
Step-By-Step Guide to Build Time Tracker & Invoice Template (Google Sheets)
If you need to add rows and/or columns in Google Sheets, look no further than this simple tutorial that also shows you how to deal with data validation or conditional formatting rules.
Easily Add Rows & Columns in Google Sheets!
Ever need to automatically generate IDs or any other sequential numbers in Google Sheets? In this tutorial, I walk you through, step-by-step, in creating a Google Apps Script that will accomplish just that.
Can Google Sheets Make IDs By Itself? Watch This!
Ever wished you could send custom email notifications from Google Form responses? In this video, I'll walk you through doing just that, step-by-step, so you can streamline your workflow.
Easily Send Custom Email Notifications From Google Forms Automatically
Have you started using multi-select dropdowns in Google Sheets but got stuck when it came time to make charts and graphs from your data? In this video, I walk you through multiple methods and strategies to equip you to handle multiple scenarios. If you're looking for a deeper dive into the "BYROW" method, check out this video: https://youtu.be/5JgUgKf_yww
Make Charts With Multi-Select Drop-Downs In Google Sheets!
Struggling to use sumifs or vlookup on multi-select dropdowns? In this video, I'll walk you through a pro-level method to quickly and efficiently get the correct totals or even to use vlookup to return other data.
SUMIFS Hack for Multi-Select Totals (Google Sheets)
Every wondered how you could or should add arrows in Google Sheets? Wonder no longer! In this video, I walk you through 5 methods and the advantages and drawbacks to each method. If you're looking for the up/down trend indicator video, check it out here: https://youtu.be/KOKr9zdM7M0 0:00 Intro 0:22 1. Emojis 1:50 1a. Custom Number Formats 2:37 2. Drawing 4:54 3. Images 7:19 4. HTML Symbols (Char Formula) 10:12 5. HTML Symbols
5 Easy Ways to Add Arrows in Google Sheets!
In this video, I'll show you how to create a pivot table in less than 30 seconds in Google Sheets along with some quick customizations. If you want to go more in depth with pivot tables, check out my full guide here: https://www.youtube.com/watch?v=1T-twsk2ZDI
Pivot Table in Under 30 Seconds! (Google Sheets)
Load More... Subscribe