Webmaster/SEO professional usually uses analysis tool like Excel for analysis (searching, filtering, sorting, comparison and alerts) to keep track of the past and current web performances and efficiency.Here are the Microsoft Excel skills every webmaster/SEO professional should possess.
Microsoft Excel definition: Joins several text strings into one text string.
Syntax: CONCATENATE(text1,text2,…) ->
Alternative Syntax: text1&text2
The formula used for the above scenario is : =CONCATENATE(A2,B2)
Alternative Formula is =A2&B2
You may also add text string before, after or in between the text string by adding a double quote like this :
Syntax: CONCATENATE(” “, text1,” “,text2,” “,…)
Alternative Syntax: ” “&text1&” “&text2,” ”
The formula used for the above scenario is : =CONCATENATE(“http://”,A2,”.”,B2,”/”)
Alternative Formula is =”http://”&A2&”.”&B2&”/”
Microsoft Excel Definition: Counts the number of cells within a range that meet the given criteria.
The formula used for the above scenario is : =COUNTIF(A:A,”None”).. Change the text string in the double quote to the name you would like to count.
For instance, to count the number of christine in the column, change the “None” to “Christine”. The new formula will look like this =COUNTIF(A:A,”Christine”). Simple!
Microsoft Excel Definition: Returns a value that you specify if a formula evaluates to an error; otherwise, it returns the result of the formula. Use IFERROR to trap and handle errors in a formula.
The formula used for the above scenario is : =IFERROR(A2/B2,”None”). The formula will take value in column A, row 2 and divide it with the value in column B, row 2. The division will return a value or 0. In this case, if 0, the formula will return value as “None”.
TEXT TO COLUMN
Microsoft Excel definition: Distribute the contents of one cell across separate columns.
1. Highlight the row content that need to be separated
2. Go to “Data” tab on the top menu panel.
3. Go to “Text To Column” button.
4. A pop up window will appeared. Select “Delimited” and click “Next”.
5. Choose “Other” then key in “/”
6.Format cells (skip for this example) and select a destination (it’s ok to select default destination )
2. Convert range to a table using Ctrl+L (Windows) & Ctrl+T (MAC). The converted table make sorting and filtering data easier.
1. For instance you have raw file consisting 2 columns which you want to convert to table.
2. Highlight the cells you want to convert
3. Then, press CTRL+L and a pop up window will appear. Click OK to create table.
4. Finally, a new table is created.
5. To filter or sort, click on the button on the bottom right of every cells.
6. You will see this drop down menu. Select the available options to sort or filter