Excel Spreadsheet Tricks

Hey Reconalists! The majority of the questions we are getting from clients are how to use the Excel Spreadsheet.

Of course you can Google any questions you have. However, if you don’t mind my poor quality videos and bad acting skills you can a few time saving techniques here.

Heads up… this is spreadsheet 101. So if you already know how to search in an active filter then you can skip this entire page. {high fives}

If not, here is some quick insight on what you need to know to make the spreadsheet easy and fun to use.

1. Most Asked Questions

Part 1. Since we want you to feel super comfortable using your Content Audit, here are some concepts that we discuss in Using The Spreadsheet.

Month to Amplify: Numbers correspond with months.

  • 1 = January
  • 2 = February
  • 3 = March

…and so on. You will find videos on how the “month to amplify” column works in your To Do List. {cuz we love a list. HA!}

When you say “sort by month” in the video what do you mean? We mean to sort the spreadsheet by “month to amplify” the third column in your spreadsheet, column C.

Why are some keywords missing? 

Not every URL will have a keyword because the indexed data is not displaying a rank.  We added the URL because of its social results or backlinks.  

We used multiple sources to get indexed data on your site so you can see what the search engines are seeing.  If the URL has a keyword, then it will also have a rank number.  Listed is the keyword with the highest search volume.  

Tip:  You can see all the keywords for the URL in your “all data” tab in your spreadsheet.  Simply, sort by URL, a-z.

Next, lets learn how to filter.

2. How To Filter

How to filter your content audit using the Excel filter function.

Part 2.  My favorite function is the FILTER!  It rocks my world.  In an age of decision fatigue and so much noise, I love the idea of filtering out everything I don’t need to see so I can focus only on what I do.  {nerdy giggle}

3. Filter a Search

Part 3. Now that we know how to filter and the basic concept of what it does. It’s time to cover my second favorite feature… how to search inside of an active filter. {squeal in delight}

  • How to search a topic or keyword inside the filter feature.
  • How to find all ranked keywords for 1 url using using filter feature.

Watch the video to see how. I use this ALL the time.

This is how we start keyword research for our own sites. We want to see what we already have on the topic, how it performed organically, reader engagement. What we covered and what we neglected to write about so we can fill in the gaps. {if needed}

It’s a great way to clean up your categories and sub-categories. I could go on and on. You’ll find so many ways to use this feature. It’s fast!

4. Add Filter and Sort

How to manually sort inside an active filter.

Part 4. We already talked about the basics of filtering {part 1}. We know how to filter a search term or keyword {part 2}.

Next we’re taking it a few steps deeper…

  • How to add a new filter.
  • How to manually sort specific data.
  • How to find blank fields to add missing data.
  • Internal link strategy by category or keyword.

Clarification: As I’m giving you tips and tricks, we’re focusing on the function of the spreadsheet. Sadly, we can’t give you everything in every video that would be hours.

However, I did want to mention that when creating your internal link strategy you do want to link to posts which takes the reader on a journey. So they need to be completely relevant. You would not link to a beach centerpiece from a modern table place setting. Most likely your reader who’s into modern decor would not be interested in beach theme. {you get it, right?}