Academy ↓
Hey there stranger!
Sign up to get access.
Fabulous Filters
About this Tutorial
Video Transcript
0:18 great. And so what I would do is I'm going to show you the filter function in this video. Here we have only three alumni items, but it's okay.
0:27 We have them in a what would be called a form responses tab. What I would recommend is not using this.
0:34 Take this as sort of input and then uh manually uh curate this information. So what we're going to do is I'm actually going to just take the title and URL and copy that to a brand new spreadsheet.
0:46 Uh and now I'm going to put. Some context, some category, uhm in this case I'm just going to write state so this is going to be California, this is going to be Florida, and this is going to be Michigan.
0:59 Just for this example. And now what I want to do is as I add more and more of these I want to create.
1:05 I'm going to call this Universities, and I want to create lists of each of these based on their state. And so what I need to do is I'm going to just actually duplicate this and instead of University I'm going to call this Florida.
1:20 And we're going to, instead of taking all of that, we're going to delete everything there and do equals sign, let me move this a little bit, equals filter.
1:29 We're going to filter the range of universities, and we're going to filter it by C equals. We're going to say Florida.
1:41 Now, that's okay, right? And we can go in here and we can rewrite Florida, Michigan, whatever we want. But in order to like say we want 50 of these and we want to do this pretty quickly, what I'm going to do- do up here is insert a row.
1:53 I'm going to right click, I'm going to create a drop down from a range. This makes it so super easy.
1:59 Uh, the range is going to be this list of states, okay? Click done. And now- I'm going to click Florida.
2:10 And instead of writing Florida here, I'm going to delete that and put A1 so that whatever is in that A1 is going to show up in that filter.
2:20 So I can filter this for California and it will change. I will filter this for Michigan. And this makes it super easy to now create another duplicate.
2:29 Greename this California. And just change this to California. Easy peasy. What's cool too is you can create these views. You can create these tabs.
2:39 or you can duplicate this and call this search by state. And now you only have one tab, but now someone can filter by the state.
2:51 And now as you add more and more information to this university list, uh this search by state. The state just becomes less uhh much nicer to use than having to scroll down lists of hundreds of these lists.
3:06 So that's the tip here. Use filter. Create individual views if you want. Or create a search or drop down field kind of thing for someone to use.
3:16 And I think this is a really cool way to sell a curated sheet with curated views. And in the next video I'm going to show you how to imbue your spreadsheet with a little bit of magic without having to use app script.
3:29 So a little automation but without using app script and coding without, you don't need any coding information whatsoever to do the next thing we're gonna do.
3:37 Alright, see you soon.
Courses
Selling Spreadsheets Course Introduction
SECTION 1 - You Are The Sheet
Coupon Code Maker Updates February 2024 - New Dashboard
How to Make Good Looking Spreadsheets
Curate Google Sheets Easily - Automatic Bookmarklet Maker
Explore Your Spreadsheet Selling Options
What you know matters
Who you are matters
How you think matters
Why you think it matters, matters
Surprising Things about Selling Spreadsheets
SECTION 2 - Your Spreadsheet Blueprint
Easiest Sheet Ever to Sell
Problems Everywhere, and the Spreadsheets that Solve Them
The #1 Mistake Spreadsheet Sellers Make and how to Save People Time
Customer’s Context Is King
The Two T’s: Turn Templates into Tools
Create a Branded Lead Magnet from Qualitative Data
Tracker Tactics
SECTION 3 - How to Make a Spreadsheet
Ask Questions
Quality Curation
Fabulous Filters
Wield Wizardry
Automatic Calculations
Automate Emails
You Must Double Duplicate (If you're selling a sheet you use)
Different Kinds of Automation
How do I prevent people from sharing my spreadsheets by making a copy?
SECTION 4 - Spreadsheet Sales Mastery
Write The Sales Page
The Strangest Secret to Selling a Spreadsheet
The F Word
Reciprocity Rules
Pricing Strategies for Spreadsheets
Upselling and Cross-Selling Techniques
Avoid A Multi-Tier Approach
SECTION 5 - Marketing Mastery
Where to Sell Spreadsheets - Marketplace Marketing
Customer Service is Marketing
Six Figure Secrets
How to Sell Spreadsheets on AppSumo Marketplace
Protect Your Spreadsheet IP
Lock Your Sheets with OnlySheets
Weird Idea: Find a Great Sheet Domain Name
A Few New Spreadsheet Business Ideas
SECTION 6 - Spreadsheet Breakdowns
Maximize Spreadsheet Sales to Startups
A Spreadsheet CRM: Automation at work
How to Make Better Lead Magnets
How to Turn a Simple List into an Epic Lead Magnet
The Art of the Sell: Breaking down a Free Title Generator
How to Make an AI Integrated Freebie Spreadsheet