Monday, January 17, 2011

Top 10 Excel SEO Functions - You'll Like These

Top 10 Excel SEO

Functions -

You'll Like These !



There are some functions in Excel that seem like they were custom-made just for SEO. If you are big into high-volume SEO and haven’t used many of these, you’re in for a treat.

Here are my top 10 Excel functions for SEO. I am excluding VLOOKUP, Pivot Tables, and If-Then-Else from this list because each of these is important enough to merit its own separate article. Here are my Top 10 (minus these mentioned 3):



Trim Off Extra Characters From Front and Back of a Character String

Before you perform any serious SEO work on character strings, it is always a good idea to trim off the extra and not-very-obvious spaces you may have accidently inserted at the beginning or end of a character string.

Click On Image To See Larger Version



Number of Characters in a String

This is very useful for limiting your page title and meta descriptions to correct lengths. It is also useful if you are using Twitter automation software and you are creating a bunch of tweets. Use this functionality as a quick check to keep under the 140-character Twitter limit.

Click On Image To See Larger Version



Substitute All instances of One Character In a Cell For Another

By itself, it can be useful, but it is also very useful when combined with other formulas, as we will soon see.

Click On Image To See Larger Version



Word Count in a Cell

There is no single function that directly does this, but you can overcome that with a little creativity. The following function combination will count the number of words in a cell.

Click On Image To See Larger Version


Concatenate (Combine) Contents of Multiple Cells

Concatenate has tons of uses, especially in high-volume PPC work. Here’s how to use Concatenate() to automatically create phrase match and exact match keyword phrases.

Click On Image To See Larger Version


Convert All Characters In a Cell to Lower Case

This turns all text in a cell into lower case. You might use this if you are developing a list of keywords to check with Google’s Keyword Tool.

Click On Image To See Larger Version



Create a Hyperlink With User-Friendly Anchor Text

This creates a live link on your spreadsheet so you don’t have to paste the URL into the browser address bar.


Click On Image To See Larger Version


Capitalize First Letter of Each Word In a Cell

I use this for constructing AdWords ads.

Click On Image To See Larger Version
Click On Image To See Larger Version



Calculate the Percentage of Current Month That Has Passed

This functionality is useful for creating projections for the current month.

Click On Image To See Larger Version



Convert a Number To An Integer By Truncating All Decimal Places

ROUND, ROUNDUP, and ROUNDDOWN are similar functions.

Click On Image To See Larger Version


I hope you find these helpful. If you know of any other Excel functions that would be helpful for SEO work, feel free to comment on them. Thanks.






If you would like to create a link to this blog article, here is the link to copy for your convenience: Top 10 Excel SEO Functions


Top 10 Excel SEO Functions - You'll Like These
Please post any comments you have on this article. Your opinion is highly valued!

If You Like This, Then Share It...
Top 10 Excel SEO Functions - You'll Like These Top 10 Excel SEO Functions - You'll Like These Top 10 Excel SEO Functions - You'll Like These Top 10 Excel SEO Functions - You'll Like These Top 10 Excel SEO Functions - You'll Like These Top 10 Excel SEO Functions - You'll Like These Top 10 Excel SEO Functions - You'll Like These

Excel Master Series Blog Directory

Statistical Topics and Articles In Each Topic

9 comments:

  1. cool post bookmarked for future use
    thanks!!! in advance
    .....

    ReplyDelete
  2. Excellent blog! Je tiens à remercier pour les efforts que vous avez faits dans la rédaction de ce poste. Je espère que le même meilleur travail de vous dans l'avenir ainsi. Je tenais à vous remercier pour cette sites! Merci d'avoir partagé. Grands sites! dallas seo company

    ReplyDelete
  3. Thanks for the post and great tips..even I also think that hard work is the most important aspect of getting success. Plummedia seo

    ReplyDelete
  4. I have not heard about before. Keep sharing more blog posts on this Community and get extra benefits with this ideas and knowledge. Thanks for this one.
    techno authorsden
    authorsden
    saatchigallery

    ReplyDelete
  5. Wonderful post! this share best article and thoughts and provide best community in all over the world. Special thanks for this post and getting good services of this sites.
    indian ventually tips
    stock tips
    indian stock

    ReplyDelete
  6. Scholars for both SEO organizations that present individual or encase administrations will convey comes about for the client. http://www.adorableseo.com

    ReplyDelete
  7. I Will Provide SEO Blog Comment Service. & niche relevant blog comment service we provide a quality service with 100% Buyer satisfaction and My team Believed in Quality work not Quantity Contact me Now 24/7.check out this Blog for your business . your business will be gain 200% more profit I can not recommend you guys enough. SEO Service

    ReplyDelete
  8. Your goal should be to get as many links as you can, preferably from websites that are related to your topic or niche.
    link pyramids

    ReplyDelete
  9. I Will Provide Seo Blog Comment Service. & niche relevant blog comment service we provide a quality service with 100% Buyer satisfaction and My team Believed in Quality work not Quantity Contact me Now 24/7.

    ReplyDelete