Home »
Resources » Archive by tag 'Excel'
by Gerard Yap on Flickr
Every SEO Person Needs This in their Link-Building Toolkit
Link building is the process of trying to manipulate the inbound links that are directly aiming towards a site. It is an essential part of an SEO campaign but a lot of SEO people do not use or have the essential tools to do the job properly and thoroughly. Even so, the people with the right tools still don’t use them to their full potential and are making life difficult for themselves.
If you want to learn more about building your own spreadsheet then take our Excel Training course ( we also offer advanced excel training), also if you want to learn more about Search Engine Optimisation, then try our SEO Training course in Brighton, Sussex.
I have created an Excel document and a Word document to help you with your link building campaign. The Excel document includes different worksheets with different lists in to enter your data as you go along. For data entry, Excel will always be a useful tool to use as it allows you to switch from cell to cell while entering data with ease.
Normally, link building is an on-going practice and from time to time it can get boring and repetitive, but if you keep it all organised then you will find it a lot easier. Also, if you need to get someone else to do the link building for you, with these resources, you can easily pass on what you have done and they can just pick up where you left off.
You can download the resources at the bottom of this page, but here’s a breakdown of what is in them and what you should be considering when starting your link building campaign -
Keywords List -
You should research which keywords you want as these will be important for your anchor text when you are link building. Anchor text is the text that is in the hyperlink which links to your site; you will need to specify this when linking with other web sites. Ideally your keyword list should be around three to five keyword phrases.
Link Partners –
Research should be undertaken to find out and pick possible people to link with. You should look through your existing businesses and also do some other searching on search engines to find new link partners. In the worksheet I have created there are rows named – Web Site Name, Web Site URL, Subject Area/ Topic, Page Rank, Desired Link Page, Webmaster Name and Contact Info.
Directories –
Yahoo and DMOZ are great directories to get your link on, they are regularly used by search engines to build their indexes with, and that makes them a very useful target for your link building campaign. As you are adding to more and more directories, you will need to keep a record of the links you are submitting. In the worksheet I have included the following field which you should fill in – Blog/ Forum Name, Web Site URL, Subject Are/ Topic, Most Relevant Section/ Forum and Contact Info.
Blog and Forums –
You should post articles on internet blog sites and forums, when you do so you should include links back to your web site, this will increase traffic to you web site. You will want to keep a record of all the places you have posted on, with relevant passwords if you need to. In the worksheet I have put the following fields in – Blog/ Forum Name, Web Site URL, Subject Area/ Topic, Most Relevant Section/ Forum and Contact Info.
PR Sites –
Press Release sites are a great way for you to make and share out online press releases swiftly and with ease; this gives you the benefit of adding easy links as well. You will want to keep a list going of all the sites you add to. On the worksheet I have included the following fields for you to fill in – Web Site Name. Web Site URL and Other Info.
Link Request –
I have created a link request template, read more information on that and download it at the bottom of the page. You will need to keep a record of who you have requested links from so not to pester them or send them more than one request. In the worksheet I have created a link building section, it includes the following fields – URL of Linking Page, Requested Landing Page, Date Requested, Contact E-Mail or URL, Link Received, Link With Anchor Text, Date Link Posted and Follow Up.
Paid Listings –
You will need to keep a record of all expenditures, if you are paying for links of directory listings then this will all need to be logged. I have created a Paid Listings worksheet which you should fill in, the fields included are – Web Site Name, Web Site URL, Requested Landing Page, Start Date, End Date, Payment Amount, PO Number, Invoice Number and Renewal URL/ Contact.
Link Tracker –
With all the time and effort you will be putting into your link building, you will want to see some results, if you track your pages then you will be able to see an impact. I have created a worksheet which you should aim to fill in weekly, depending on how heavily you are link building, fortnightly and monthly is also fine. The worksheet includes the following fields – Ranking, Number of Inbound Links, Organic Traffic Search and Organic Search Conversions.
Link Request Template –
To request a link from someone you will normally need to send them an e-mail request. I have made a simple link request template for you to fill in and send away, it needs a few bits filled in and you can of course alter it for your needs and specifications. All link request email should include the following – A polite and personal greeting, a simple kind word about their site, a short summary of your website, a link request (obviously!), the anchor text you want included and a pleasant sign-off with your name and, if possible, an email address which is the same name as your web site.
Remember that these are general resources and they may differ slightly from your own businesses needs. Some simple editing of the documents will make it relevant for you, but the basics are all there.
Read more
Posted by Heather Buckley in Excel Training, SEO Training, Social Media Training on October 1st, 2010 | 2 Comments »
Microsoft Excel is a spreadsheet application for Windows and Mac. Its features include powerful calculation tools and graphing capabilities. It has been the most widely used spreadsheet application since 1993.
Over the years Excel has become an integral part of the accounting functions of many businesses, but can used be anyone who needs to organise data or figures effectively. It provides an easy and effective way to format and manage data, giving the user the ability to create a chart or graph with ease. Understanding and being able to use Excel is now a basic necessity for many companies.
Excel can seem complicated and intimidating at first. The aim of the tutorial that follows is to guide you through the basics. You can follow each stage step by step, or dip in to particular sections to learn a specific tool.
For a really comprehensive coverage of Excel we’d recommend attending one of our instructor-led training courses which are delivered by experienced industry professionals.
The courses available include:
Read more
Posted by Alistair Wylie in Excel Training on May 1st, 2009 | 1 Comment »
Start off by opening up Excel 2007 by double clicking on the icon, either on your desktop or via the Programs list from the Start menu in the bottom left of your screen. All of this is covered in our Beginners Excel Course in Brighton, Sussex.
At the top of the Excel window is the title bar which will display the name of the workbook you are working on (Excel files are called Workbooks!). The default name for for a new Workbook is ” Book1″.
To the left of the Title Bar is the Quick Access Toolbar. This tool bar provides shortcuts to the most frequently selected tools. It looks like this:
If this is your first time using Excel then the bar will be set to its defaults: Save, Undo and Redo.
Undo will delete the action you have just taken and go back to what the situation was previously (useful if you make a mistake!)
Redo reverses the effects of pressing “undo” (if you decide it wasn’t a mistake after all!)
Save will initially prompt you to give your Workbook a name (something more exciting than Book 1!) and a location to save it in. After you’ve saved your Workbook for the first time, pressing “Save” again will save any updates you have made to the same file.
Located in the top left hand corner of the Excel Window is the Microsoft Office button. Click here to select from a variety of tasks from a drop-down menu including “Open”, “Save”, “Save As” etc… If you’ve worked with other Office product’s you’ll be familiar with these options.
In order to work well with Excel you have to give it the right instruction, and most of these are available on the ribbon. The ribbon is located below the Quick access toolbar across the top of the window. The ribbon is made up of lots of different tabs which display their corresponding command instructions when clicked. These tabs allow you to issue commands, access menus or access dialog boxes. There is also a “dialog box launcher” that, when clicked will offer additional commands that you may wish to use. Here is a picture of the Ribbon:
Excel Ribbon
Click image to view full size
Read more
Posted by Alistair Wylie in Excel Training on May 1st, 2009 | No Comments »
Microsoft Excel Workbooks are made up of Spreadsheets. A Spreadsheet is organised into rows and columns of cells. The columns lettered and the rows are numbered. These numbers and letters combine to give each cell an address (e.g A1). All of this is covered in our Beginners Excel Training Course in Brighton, Sussex.
The contents of each cell can be entered via the formula bar. This is divided into two parts: the left side of the formula bar shows the cell address, and the right side shows the information that the cell is holding. If you can’t see the formula bar, select the “view” tab in the top menu and click the formula button in the show/hide section.
You can also see the total, mean, maximum or minimum of any numbers or cells by highlighting them and looking at your status bar. This is located at the very bottom of your excel window. If you wish you can also change the information the status bar gives by right clicking on the status bar and choosing its options in the Customise Status Bar Menu.
Excel Status Bar
Read more
Posted by Alistair Wylie in Excel Training on May 1st, 2009 | No Comments »
The first thing that you will need to learn is how to move around a Spreadsheet. One way of doing this is to use the arrow keys on your keyboard to highlight a particular cell. The highlighted cell has a thicker black border than the others. Using the arrow keys you can move the selected cell up, down, left or right one cell at a time. You can also use the page up or page down keys to move a whole page at a time. All of this is covered in our Beginners Excel Course in Brighton, Sussex.
It’s easy to lose track of where you are in a spreadsheet – at any time you can hold the “Ctrl” key the “Home” keys together to return the selected cell to the top left of the sheet (cell A1). If you are new at this then it is worthwhile practicing this for a few minutes before continuing so as to get a better feel for moving around.
For a quick and easy way to locate a cell press the F5 key. This will open the “go to” box, where in you can enter the address of the cell that you want to go to, and be taken there immediately. Alternatively, you may find it easier to use the left part of the Formula bar at the top of your spreadsheet. Just type the address of the cell (e.g A1 or C4 etc…) and press enter
Read more
Posted by Alistair Wylie in Excel Training on May 1st, 2009 | No Comments »
In the last section we explored how to select one cell at a time, however there are times when you might want to select a group (or “range”) of cells together. All of this is covered in our Beginners Excel Training Course in Brighton, Sussex.
There are two ways to do this. The first is to simply press and hold the left mouse button and then drag the curser over the area which you which to highlight.
The second way is to highlight one cell (for example A1), and then press the F8 button on your keyboard. When you have done this the “Extend Selection” notification will appear on you status bar. Now select the last cell you which to highlight by clicking on it with your left mouse button and the computer will then highlight all the cells in between those two points. For instance if you click on A1 then E13 then all the cells between those two rows and columns will now be selected. Try it now!
In order to highlight more than one separate area at a time you can hold down “Ctrl” whilst using the dragging technique described earlier. Also if at anytime you want to completely clear your spreadsheet of all highlighted areas then press Esc.
Read more
Posted by Alistair Wylie in Excel Training on May 1st, 2009 | No Comments »
OK – we now know how to highlight cells, but we still don’t have any data in them!
Cells can hold all sorts of data, including text, numbers and calculations.
In order to enter data into a cell, first select it. After you have highlighted the cell you want, you can add data to it either just by starting to type straight away, or by clicking the in to the right hand side of the formula bar and typing there:
To delete any unwanted or incorrect information simply press backspace. If you highlight a cell that already has data in it and start typing, the original data will be wiped. If you want to edit the data that is already in the cell, highlight that cell and press F2.
After you are satisfied that you have put what you want to in the cell, press enter to finish or if you prefer use the directional key buttons or mouse to move to another cell or area.
All of this is covered in our Beginners Excel Course in Brighton, Sussex.
Read more
Posted by Alistair Wylie in Excel Training on May 1st, 2009 | No Comments »
The cells in a spreadsheet are quite small, so typing in a lot of information can lead to it overlapping and covering up other cells. One method for confining lots of information to just one cell block is text wrapping.
Try this out by typing a lot of text in to a cell so that is overlaps the edge. Next, select the cell by clicking on it, and then click on the Wrap text button in the ribbon above. After you have done this the text should be confined to the vertical cell borders, as seen below:
Read more
Posted by Alistair Wylie in Excel Training on May 1st, 2009 | No Comments »
