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

PPC Hints for Excel 2: The Array Formula and Negative Keyword Checking | SEOptimise

PPC Hints for Excel 2: The Array Formula and Negative Keyword Checking | SEOptimise | Excel For SEO | Scoop.it
Last February I gave you some handy Excel tips – here’s some more! Today I’m talking about array formulae. What’s an Array Formula?
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

The dangers of using Excel for SEO

The dangers of using Excel for SEO | Excel For SEO | Scoop.it
Excel is the staple data processing tool for any technical SEOer, and has been for a long time.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

SEO Excel Functions

SEO and Excel are like chocolate and peanut butter - great together. Here are 18 Excel functions (and two formulas) that can make SEO just a little bit easier.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

NielsBosma.se | Home of SeoTools for Excel

NielsBosma.se | Home of SeoTools for Excel | Excel For SEO | Scoop.it
Home of SeoTools - a xls plugin for working with Excel SEO. Create SEO spreedsheets, Excel SEO reports. Download Excel Seo Tools by Niels Bosma today.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Find, and Outreach to Your Competitor’s Best Links

Find, and Outreach to Your Competitor’s Best Links | Excel For SEO | Scoop.it

You’ll need:

 

- The SEOgadget Links API Extension for Mozscape
- Our Free Link Cleanup and Contact tool

 

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

Announcing: The Links API Extension for Excel for Mozscape

Announcing: The Links API Extension for Excel for Mozscape | Excel For SEO | Scoop.it

Today, I’m absolutely delighted to announce we’re releasing the SEOgadget Links API Extension for Excel. With it, you can build reports and cobble together quick applications to fetch valuable link data from all 4 Mozscape API flavours.

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

Making Data Sexy — Excel Formatting 101

Making Data Sexy — Excel Formatting 101 | Excel For SEO | Scoop.it
Learn how to make your data sexy and actionable with these quick Excel formatting tips!
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

7 Excel Charts You Should Be Using Daily [Video Tutorial]

7 Excel Charts You Should Be Using Daily [Video Tutorial] | Excel For SEO | Scoop.it
If you do SEO or Internet marketing - or anything to do with data - here is a tutorial on how to do the eight best charts in Excel, with lesser known tips and tricks.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Excel For SEOs: Manipulating URL Strings with Functions

Excel For SEOs: Manipulating URL Strings with Functions | Excel For SEO | Scoop.it
Over the past few months, I've been preparing a guide with the tentative title, Excel for SEOs: Lessons for Aspiring Ninjas.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Excel and Google Docs: Tools for the Ultimate SEO Dashboard

Excel and Google Docs: Tools for the Ultimate SEO Dashboard | Excel For SEO | Scoop.it
I love SEO tools. I’m sort of a pack-rat when it comes to Google Docs tools and Excel add-ins. I went absolutely nuts when Tom Critchlow posted his Google Docs SEO tutorial on distilled.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

A Marketer's Guide To Table Formatting In Excel

A Marketer's Guide To Table Formatting In Excel | Excel For SEO | Scoop.it
If there’s one task most marketers share — whether their focus is SEO, paid search, or social media — it’s collecting and interpreting data. Being able to slice and dice the data to find actionable insights is key to effective analysis.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Excel Dashboard Examples - 66 Dashboards to Visualize Excel salaries around world | Chandoo.org - Learn Microsoft Excel Online

Excel Dashboard Examples - 66 Dashboards to Visualize Excel salaries around world | Chandoo.org - Learn Microsoft Excel Online | Excel For SEO | Scoop.it
Ladies & gentleman, put on your helmets. This is going to be mind-blowingly awesome. See how many different ways are there to analyze Excel salary data.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

SEO Pivot Tables

Pivot tables are a valuable SEO tool. Follow this step-by-step guide on how to create a pivot table using the new Google Webmaster Top Queries report.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Excel for SEO – The Poor Man’s Alternative to Paid Software? Niels Bosma got the answer!

Excel for SEO – The Poor Man’s Alternative to Paid Software? Niels Bosma got the answer! | Excel For SEO | Scoop.it
Choosing which SEO-tools to use can be hard, both for beginners and professional SEO’s. If you rely on the wrong ones, you might lose money and be forced to redo much of your SEO-work. So how should you know which tools to pick?
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Amazing SEO Tools for Excel: SEOtools By Neils Bosma

Amazing SEO Tools for Excel: SEOtools By Neils Bosma | Excel For SEO | Scoop.it

While I was checking out the web site for ExcelDNA I came across an incredible tool called SEOtools created by Neils Bosma.

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

Check Your XML Sitemap For Errors with this Excel Tip

Check Your XML Sitemap For Errors with this Excel Tip | Excel For SEO | Scoop.it
How to use Microsoft Excel to check your sitemap XML file for errors. SEO tips courtesy of Richard from SEOgadget...
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

SEOgadget Links API Extension for Excel - Mozcon 2012

My presentation and technical documentation for the SEOgadget Links API Extension for Excel for Mozscape, SEOmoz's API service.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

How To Manage Big Data With Pivot Tables

How To Manage Big Data With Pivot Tables | Excel For SEO | Scoop.it
Big data is all the rage right now. If you search Google News for the term, there are 53,500 thousand results. And that’s just the news. Most of us in Internet marketing aren’t truly working with big data, in the truest sense of the word.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

How to Build an Advanced Keyword Analysis Report in Excel

How to Build an Advanced Keyword Analysis Report in Excel | Excel For SEO | Scoop.it

With Microsoft Excel, we can create a report with all the keyword data you will need, all in one place, and fairly easy to update on a weekly or monthly basis. Then with all this data we can easily categorize segments of it to more quickly determine the better performing sets of keywords.

 

What we will need to do is push Google Analytics, Webmaster Tools, Adwords, Ranking data, and Revenue data all into one excel spreadsheet. Then we will put it all together into one master report and one categorized pivot table report.

 

 

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

Awesome Examples of How to Use SeoTools for Excel | distilled

Awesome Examples of How to Use SeoTools for Excel | distilled | Excel For SEO | Scoop.it
Working examples of how to SeoTools for Excel to complete SEO tasks faster and more easily...
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Excel for SEO – Powerful Cheat Sheet to Boost Productivity

Since no one has time to spend ages mining for Excel answers from mountains of text, so I came up with my own cheat sheet for Excel.

 

What I am going to present to you is actually a worksheet (we use internally for training purpose and quick reference) in the form of a blog post which i thought will be useful to share with the community. This cheatsheet is for Excel 2007.

 

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

Using SEO Spider Data in Excel | distilled

Using SEO Spider Data in Excel | distilled | Excel For SEO | Scoop.it

We’ve been using Screaming Frog’s SEO Spider in the office for a few months now and, along with other spider software, it provides a great means of identifying technical and on-page issues quickly and easily.

 

My personal preference is to export the data to Excel where you can manipulate it however you like. In addition, you can then email the spreadsheet to a client, development team etc. once you’ve highlighted the problem you’re trying to fix.

 

Here are some of the Excel features and formulas that I’ve been using to generate meaningful, actionable reports.

more...
No comment yet.