The hassle free way to save your files where you need...

Ever thought about how much time you waste saving files in the wrong place? For most computers and programs, the default save location is set...

Part II: What is Page Layout View and How do I...

If you're using an Excel spreadsheet that contains a large amount of data or many columns, it can sometimes be difficult to adjust the...

What is Page Layout View and How do I Use it?

If you're using an Excel spreadsheet that contains a large amount of data or many columns, it can sometimes be difficult to adjust the...

How Do I Produce A Graph From A Table In Excel?

A frequently asked question by many of our readers, so we thought we'd tackle this little task first, and show you how to make...

Using the ‘SUM’ Function in Excel

The formulas available to you in Excel are the reasons why most most of us love it, or are incredibly scared of it! But if...

Using Conditional Formatting to Identify Duplicate Data in Excel

There are a couple of different ways of identifying duplicates within a dataset but by far the easiest way is with conditional formatting. There...

A Fast and Easy Way to Separate Data

If you're an Excel user, chances are that at some point in your life, you have come across a spreadsheet stacked full of data...

Mail Merging Made Easy – with Microsoft Word and Excel

The mail merge function of Microsoft Word is arguably one of its most useful features. It is a simple way of personalising a template...

Excel – Create Useful Datasets with Data Validation

If you have had experience in using Excel to create databases of information, it’s quite possible that at one time or another you have...

Video tip: Filling in blank cells in Excel

Here's our first Excel video tip, for those occasions where you have a spreadsheet full of data and group headings/categories have only been entered...

DON'T MISS