This course is not available for free users. Please purchase a subscription to enroll in this course and view its contents.

Data Management

56 Tutorials

4 hours and 41 minutes

You got messy data. It's keeping you up late at night trying to manage it. You copy. You paste, and repeating too many tasks. These videos help you manage that data without having to use automation.

56Tutorials

Discover Duplicates Misspelt

Search and find duplicates that are spelled differently.

Beginner

Creating Blank Cells For Good Reasons with IfError Formula and if(isBlank) Formula

There are surprisingly few times you want to have blank cells, or even create blank cells. In this video I'll show you the good reasons you want blank cells.

Turn Data in Many Columns Into 1 Column

How to turn many columns into one column.

Beginner

How Do I Make a CSV File? And give a link to someone instead of the csv.

Create a link to your sheet that immediately download the sheet as a CSV file. Great for sending exports as a link.

FREE

Learn Google Sheet Formulas The Hard Way

One weird way to learn more about what Google Sheets can do. https://bettersheets.co/formulas

Organize Anything! - Build a Kanban Board / Trello Board

Organize leads, life tasks, chores, assignments, anything into a kanban or trello board.

Advanced

How to Get Time from a Timestamp

Extract the time from a Google Sheets timestamp.

Beginner

How to Name Sheet Tabs

Organize tabs appropriately to decrease the friction that other users will have when reading or using your spreadsheets.

Beginner

FREE

Search Every Function in Google Sheets

Built a useful tool to filter Google Sheet formulas based on keywords.

FREE

Naughty or Nice? - Google Sheets' New Dropdown Chips

Google Sheets has a new way to do dropdowns. Is it naughty or nice?

Get Data With Comments

A great way to manage your data if you have a small group of people who want to add data, but you want control over that data in the sheet. Give them the ability to comment on your data.

Beginner

Quadrant to List and List to Quadrant

We're going to like take some data, twist it and turn it into a different type of like look and feel. And then we're going to do the same thing in reverse.

Intermediate

Sync Two Tabs Without ImportRange()

Get this epic script that automatically edits two tabs and keeps them in sync.

Advanced

Hide Completed Bars - Make Progress Bars with Sparkline: Part 2

Use the IF() formula to hide completed bars and display messages instead of bars depending on the situation.

Convert Your Bullet Journal To Google Sheets

Find out how you can make your spreadsheets like a Bullet Journal. It's like a super powered Bullet Journal.

Beginner

FREE

2 Ways to Hide Data

Hide data with these simple tricks. Just using the IF() formula.

Intermediate

FREE

Search for Photos in a Google Sheet

This feature is really handy for designers who want to create notes around designs and mockups to showcase to clients. As a photographer, I can also use this to create a searchable sheet with keywords for my photos. You can even use screenshots instead of Unsplash photos like I'm using here. Basically, all you have to do is insert the images into cells and use V lookup to search for them using the ID numbers. You can use this to mock up a newsletter, test out different thumbnails as a YouTuber, or create a landing page or workflow for your business. It's really easy to change the photos by just changing the ID number.

Tagging Titles, Create a Comma Separated List of Tags

The video tutorial is about tagging and creating comma-separated lists of tags for a list of titles. The tutorial demonstrates how to use data validation to create a drop-down menu of tags for each title and how to keep track of the number of videos or items in each tag category. The tutorial also shows how to create a comma-separated list of tags for each title using the JOIN function.

Intermediate

Get Twitter Handles Easily by changing URLS to @

Change Urls to @ using Substitute()

Beginner

Automatic Weekly Backup of Google Sheets

Discover how to Save Your Sheets Every Week Automatically

Intermediate

Find the Start date of the Current and End date of the Current Month

We want to know, based on today's date, what is the start of the month and what's the date at the end of the month.

Wallace Asks: How To Find New Names

Got a list of names, need to add new ones to main list.

5 Ways to Generate Random Numbers

generate random numbers using Google Sheets. Fun ways to figure out how to get random characters. Great to use for creating IDs or Coupon Codes. Nice easy intro to some simple apps script.

Intermediate

How Many Days Between Two Dates?

Figure out how many days between two days, or how many days until a certain date. Or figure out how many days has it been since an event. Great for automatic email notifications of due dates, deadlines, etc.

Intermediate

FREE

Combine 2 Columns into 1: First Names and Last Names Together

Add together two columns data.

Beginner

Add Team Members to the Quick CRM

Intermediate

Concat Because Concatenate is too hard to Remember!

One more function beyond Concatenate and Join that is useful in so many different ways. Concat can be used to quickly create unique columns of data. But watch out for dates!

FREE

Extract URLs from Google Sheets

When you can't get the url of a hyperlinked cell, do this instead.

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition, even if that condition is a date.

Take a list and make it Vertical, Using Split Join or RegexReplace

Create vertical lists in Google Sheets.

Beginner

How to Iterate Counting Blank Cells in Google Sheets

Count different types of blank cells. Cells with nothing in them.

Intermediate

FREE

How To Select an Image based on Text in a Dropdown Menu

Create a schedule inside of Google Sheets.

Create a Many to Many Database

We have a list of names and maybe we have sort of a lead categories. Maybe we're doing sort of reach out and we want to actually maybe combine like key words.

Create a Self-Adding Dropdown Menu

Create a Sheet of Sheets for Project Management and/or Data Management

Create an epic organization sheet of all your spreadsheets.

How to Add YouTube Thumbnails

Add the image of a youtube thumbnail with only a YouTube url into your Google Sheets. Great use case for Substitute() or Split() functions. Nice way to add a little visual flair to your sheets.

Create Instant QR Codes

Learn how to use a free Google API to create QR codes in sheet to any URL. And we'll learn how to make them magically appear as you enter domains.

FREE

6 Ways to Make Your Checkboxes Better

We're going to take a basic function of Google sheets, which is the checkbox, and we are going to take it to its nth degree.

Data validation Beginner

FREE

Manage Your Wedding Guest List in Google Sheets

Learn how to manage any event with RSVPs and multiple organizers. Use Google Forms pre-filled links, and interesting formulas to manage the catering automatically. And we write Apps Script to send email to non-rsvp'ed guests.

How Can I Compare Two Tabs for Differences?

So in this video we're going to compare two tabs and differences. Basically, someone asked actually on AppSumo, someone asked how do I compare two sheets to know what the differences are? This is the answer.

5 Ways to use IF() Formula to Create Magic in Your Sheets

We're going to create some magic here. Some if magic, sprinkle a little magic on your sheets, you can use these formulas in existing sheets.

Intermediate

How To Create An AutoFill in Google Sheets

Autofill inside of google sheets is possible with Dropdowns.

Beginner

5 Ways To Use Google Sheets for Advanced Project Management

Here are 5 advanced ways to manage projects inside of Google Sheets Manage Task Flow with IF() and a Checkbox Manage Data Inputs with IF() and ISBLANK() Create Quick Dashboard headers with: Transpose / Unique Create Pickers with Index / Match Email reports with Apps Script

Intermediate