Excel For SEO
8.7K views | +0 today
Follow
Your new post is loading...
Your new post is loading...
Scooped by Jacob Jarnvall
Scoop.it!

How To Use Macros You Find Online In 6 Easy Steps

How To Use Macros You Find Online In 6 Easy Steps | Excel For SEO | Scoop.it
Have you ever done a search to find out how to do something in Excel, just to find the search results littered with macro options?
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Turning SEO Link Building into SEO Audience Targeting with Twitter profiling | The Wall Blog

Turning SEO Link Building into SEO Audience Targeting with Twitter profiling | The Wall Blog | Excel For SEO | Scoop.it

oday, I want to share a combination of a few simple tools that actually help us identify our target audience, show us who might be influencing them and how to identify what content those influencers share. Why? We’re trying to reach people. What better way than to do it in a targeted, data driven way
.

more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

10 Tips To Make Your Excel Charts Sexier

10 Tips To Make Your Excel Charts Sexier | Excel For SEO | Scoop.it
Having covered all the basics of how to make tabular data tell a story using custom cell formatting and conditional formatting for both static tables and pivot tables, we’re now going to jump into the really fun stuff: charting data out in Excel.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

How to Use Excel to Estimate New PPC Account Performance | PPC Hero®

How to Use Excel to Estimate New PPC Account Performance | PPC Hero® | Excel For SEO | Scoop.it
The first post for September's series on using Excel for next level PPC account optimizations gives specific instructions for new account performance estimates.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Excel with Google Analytics filter list and regex guide

Excel with Google Analytics filter list and regex guide | Excel For SEO | Scoop.it

Excel with Google Analytics filter list and regex guide

more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

How to Leverage PPC to Discover High-Converting Keywords for SEO

How to Leverage PPC to Discover High-Converting Keywords for SEO | Excel For SEO | Scoop.it
When starting out with a new search effort or performing a keyword refresh for an existing website, the options for discovering new keywords are limited only by the SEO’s imagination.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

How To Go Picasso On Your Data With Conditional Formatting

How To Go Picasso On Your Data With Conditional Formatting | Excel For SEO | Scoop.it
Anyone who knows me knows I’m not a fan of tabular data (data in tables). If you want your data to be persuasive, it needs to be visual. However, when you’re dealing with large data sets that’s not always feasible.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Excel tools for PPC - Pivot Tables - Yell Marketing

Excel tools for PPC - Pivot Tables - Yell Marketing | Excel For SEO | Scoop.it

Excel is great for data analysis, especially Pivot Tables for PPC optimisation

more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

How to Automatically Track Your Google Positions in Microsoft Excel | Search Engine People | Toronto

How to Automatically Track Your Google Positions in Microsoft Excel | Search Engine People | Toronto | Excel For SEO | Scoop.it
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

SEOmoz Mozscape Add-In For Excel

SEOmoz Mozscape Add-In For Excel | Excel For SEO | Scoop.it
With the updates just added to the Mozscape API (previously Linkscape), I decided to update the Excel Macro and turn it into a full-fledged Excel Add-In. Features: Select any number of cells containing URL’s.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Array Formulas in Excel - Saving Time & Space in Spreadsheets - SEO Excel | Best Rank

Array Formulas in Excel - Saving Time & Space in Spreadsheets - SEO Excel | Best Rank | Excel For SEO | Scoop.it
At some point you might find yourself needing to use array formulas in Excel. Why not take a stab at some of these time saving, space saving array formulas today?
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

SES - Tools of the Trade - Richard Baxter 2012

An Excel tips session covering a range of skills, from checking your sitemap XML file for errors, to capturing SEOmoz API data straight into Excel!
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

SEOgadget - How to Make a Pivot Table and Chart in Excel

SEOgadget - How to Make a Pivot Table and Chart in Excel | Excel For SEO | Scoop.it

For SEOgadget clients, most of the SEO work they receive from me is delivered at the end of a heavily data driven process. If you’re feeling a shift towards data driven SEO too, then the chances are using pivot tables and charts in Excel is a near daily part of your SEO consulting activity.

more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

5 Awesome Simple Steps To Find Your SEO RankScore

5 Awesome Simple Steps To Find Your SEO RankScore | Excel For SEO | Scoop.it
Do you still search for your keywords on Google to find your rankings? Well, that's a thing of the past. Here's a more data-driven approach to analyzing your Google rankings.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

How To: Build Open Site Explorer in Excel

How To: Build Open Site Explorer in Excel | Excel For SEO | Scoop.it
How To: Build Open Site Explorer in Excel one of our latest blog posts on SEOgadget...
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

How I Wrote 500,000 Unique GoogleBase Descriptions in 2 Hours | SEER Interactive

How I Wrote 500,000 Unique GoogleBase Descriptions in 2 Hours | SEER Interactive | Excel For SEO | Scoop.it
The Problem Anyone who has worked on an eCommerce site with a new or non-optimized GoogleBase feed is probably familiar with this scenario: either there are...
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Advanced Excel For PPC: How To Work With Match Types Using VBA Code

Advanced Excel For PPC: How To Work With Match Types Using VBA Code | Excel For SEO | Scoop.it
When working with AdWords Keyword reports downloaded from the Web interface, you may come across Keywords with their Match Types signified by special punctuation, rather than a separate column indicating Match Type.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

The Super Duper Guide to Google Analytics Pivot Tables

The Super Duper Guide to Google Analytics Pivot Tables | Excel For SEO | Scoop.it
Pivot tables are hidden gems in Google Analytics reports. They are extremely powerful data summarization tools. You can quickly summarize data in desired format & detect data trends that you can’t determine otherwise.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

3 Time-Saving Techniques For PPC Managers Using Excel Filters | PPC Hero®

3 Time-Saving Techniques For PPC Managers Using Excel Filters | PPC Hero® | Excel For SEO | Scoop.it
Excel filters help PPC managers structure large keyword lists, eliminate costly search query themes and analyze account performance.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

How to Perform SEO Competitor Research with Excel | Search Engine People | Toronto

How to Perform SEO Competitor Research with Excel | Search Engine People | Toronto | Excel For SEO | Scoop.it
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

How to Check HTTP Redirects with Microsoft Excel | Search Engine People | Toronto

How to Check HTTP Redirects with Microsoft Excel | Search Engine People | Toronto | Excel For SEO | Scoop.it
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

How to Visualize Competitor Link Profiles in Excel - BuzzStream | Software for SEO link building, social media marketing and public relations | BuzzStream

How to Visualize Competitor Link Profiles in Excel - BuzzStream | Software for SEO link building, social media marketing and public relations | BuzzStream | Excel For SEO | Scoop.it
This posts explains how to visualize competitor link profiles in Excel to drive your link acquisition strategy.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Categorising Your Links with Excel and Open Site Explorer

Categorising Your Links with Excel and Open Site Explorer | Excel For SEO | Scoop.it
This post will help you determine the types of links in yours, or your clients link profiles using SEOmoz Open Site Explorer data and Excel...
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

301 redirects with Screaming Frog & SEOTools for Excel

301 redirects with Screaming Frog & SEOTools for Excel | Excel For SEO | Scoop.it
A guide to using Screaming Frog & SEOTools for Excel to help manage & monitor 301 redirects to a subfolder within a non-CMS driven website.
more...
No comment yet.