Showing posts with label excel spreadsheet. Show all posts
Showing posts with label excel spreadsheet. Show all posts

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

Wednesday, January 12, 2011

Excel Model Building - Experts vs. Non-Experts

Excel Model Building -

Experts vs. Non-experts



What makes a great Excel modeler? There actually are identifiable skills and problem-solving tendencies that expert Excel modelers seem to possess in greater abundance than the average Excel modeler.

A brief study was done by Dartmouth Professors Stephen Powell and Kenneth Baker, authors of the best book ever written about quantitative Excel modeling: Management Science – The Art of Modeling With Spreadsheets. (If you are interested, I've reviewed the book on this page. It is the 4th Internet marketing book review on the web page)

Professors Powell and Baker audiotaped 28 of their MBA students work through 4 ill-structured modeling problems. The focus of the test was not to observe the students create a spreadsheet for a well-defined problem but rather to craft the right Excel modeling approach to a problem that had not been well thought-out and structured in advance. This situation much more closely approximates the real life faced by a consultant or business decision-maker.

Major Differences Between Expert and Non-Expert Model Builders

Professors Powell and Baker listed the following conclusions of their study in their well-respected book:

1) The expert model builders would build the model first and then ask for data later. Non-experts would immediately focus on the data. Non-experts appeared to exhibit a much stronger reliance for the data at hand.

2) Experts would create and evaluate a number of solutions before narrowing their efforts on just one. Non-experts tended to select an overall direction after significantly less evaluation or creation of other alternatives. Non-experts sometimes had a tendency to try and avoid the model-building process altogether and propose solutions such as: “Let’s call an expert” or “Let’s do market research.”

3) Expert modelers as a whole are stronger in math than non-experts.

4) Expert modelers would think more in terms of variables and relationships in the early stages of problem solving. Non-experts would often use concrete numbers right away.

5) Experts tended to stop much more often during the model-building process and re-evaluate their current progress and direction.

6) Experts initially framed problems in ways that could be translated to a model quickly. Non-experts tended to be much more unstructured in their early attempts to create an overall plan. Their attempts at early organization seemed to resemble brainstorming sessions.

7) Expert model builders solved the problems by working backward from what the solution was supposed to provide. Non-experts did not use this approach as much.

Conclusions

Practical Excel model-building advice based upon the modeling approaches of experts would be the following:

1) Don’t expect data to answer the problem.

2) Don’t be in a rush to find the quick answer.

3) Try to see the forest through the trees. Always keep in focus what the overall goal of the model is.

4) Try to create and evaluate a number of different approaches before deciding on the overall direction that your model will take.

5) Regularly re-evaluate your progress toward your model’s completion and the direction that you are currently taking.


Here are some other blog entries related to this article:

Correctable Reasons Why Your Data Is Not Normally Distributed

22 Big Statistical Mistakes You Don't Want To Make

Logistic Regression in Excel To Predict If a Prospect Will Buy

How To Build a Better Split-Tester in Excel Than the Google Web Site Optimizer

Using the Normal Distribution in Excel To Find Your Daily Range of Sales

If you would like to create a link to this blog article, here is the link to copy for your convenience: Modeling in Excel - Experts vs. Non-experts

Excel Model Building - Experts vs. Non-Experts
Please post any comments you have on this article. Your opinion is highly valued!

If You Like This, Then Share It...
Excel Model Building - Experts vs. Non-Experts Excel Model Building - Experts vs. Non-Experts Excel Model Building - Experts vs. Non-Experts Excel Model Building - Experts vs. Non-Experts Excel Model Building - Experts vs. Non-Experts Excel Model Building - Experts vs. Non-Experts Excel Model Building - Experts vs. Non-Experts

Excel Master Series Blog Directory

Statistical Topics and Articles In Each Topic