Category: Tips and Tricks

Using Count Functions In Excel

I was called upon this week to solve a problem using the Excel Count functions. The situation was that the user just didn’t understand the difference between each of the functions available, which I will summarise here. There are 5 Count functions COUNT Counts how many numbers are in the list of arguments COUNTA Counts …

Continue reading

Selecting a Web Designer or Developer

Before you choosing a designer for your website, step back and ask yourself 3 simple questions: What is the objective of the website? How much are you willing to spend, or how much can you afford to spend on the website? How much time do you have available to spend on the website? Let’s consider …

Continue reading

Successful Search Engine Listing Tips

This article highlights three simple steps to search engine optimisation. There are many articles that overcomplicate Search Engine Optimisation (SEO) by making references to search engine algorithms, PageRank formulas, keyword density, etc. This article will attempt to keep SEO in simple terms without getting involved in anything too technical. Firstly be aware of anybody that …

Continue reading

Guidelines to Good Web Site Design

It would appear that anyone thinks that they can build a web site, but can anyone build a successful website? No. Only look at the web and you will find many sites that quite frankly are worse than useless. So what are the key aspects to building a successful web site? You’ll find a few …

Continue reading

Speed up your PC (Part 4)

In this part of the Speed up your PC series we’ll be looking at a couple of tweaks that will help to optimise the performance of the PC. Stop Indexing Windows uses the index to perform very fast searches on your computer. By default , the Windows Search indexing service is turned on for all …

Continue reading

Speed up your PC (Part 3)

The previous articles in this series specifically considered the disk drive with part 1 concerned with decluttering the drive, and part 2 optimising the performance of the drive. It is important now that since these actions are complete and the hard drive is in good operational condition, it should be kept that way, do this …

Continue reading

Speed up your PC (Part 2)

The first part of this article was concerned with decluttering the hard disk drive, basically removing anything that is no longer needed, either by deleting, or by removing to an archive or other storage medium. This part is deal with the next step, in tidying up the hard disk drive. When a file is stored …

Continue reading

Speed up your PC (Part 1)

Over time computers are used to store a significant amount or have additional programs running, and that bright new shiny PC doesn’t seem to be as fast as when it was first run. This is normal, but it is possible to return the performance of the computer almost back to its original with a few …

Continue reading

Synchronizing Outlook to Hotmail Accounts

Surprisingly those with Hotmail or Live accounts are unable to directly connect to Outlook, even though these are Microsoft products. To allow these accounts (including the newer outlook.com) accounts to communicate with Outlook the Outlook Hotmail connector needs to be installed. The Microsoft Outlook Hotmail allows Microsoft Office Outlook 2003, 2007 or 2010 to access …

Continue reading

Save Time and Effort with Templates in Microsoft Office

In Microsoft Office use templates to create consistent documents and save time. Templates are particularly useful for documents that are used frequently, such as standard letters, weekly reports and presentations or expense forms. A template forms the basis of a document that is perhaps partially written with only some customisation to be inserted to complete …

Continue reading