Increase your efficiency with a customised toolbar in Microsoft Office

The quick access toolbar is an incredibly useful feature that in my mind is often overlooked.If you regularly use Microsoft office, and particularly if...

Formula-free super quick maths

Normally in Excel, if you want to do some calculations on values in a cell or range of cells, then it's fairly easy to...

How to: Word counts in Excel

Ever needed to know the word count of text in a certain cell in Excel? It's not something that you would need know often,...

Identifying unique values in a database

Conditional formatting is a very useful tool in Microsoft Excel that can be used for a variety of purposes when analysing data. It's particularly...

Add a calculator into Microsoft Excel

Microsoft Excel has lots of little hidden tips, tricks and add-ons that many people don't know about, and it's my mission to make these...

Painlessly extracting the data you need from a database – Part...

In our previous article, we looked at using the Advanced Filter function of Excel to copy certain records from one database to another using...

Painlessly extracting the data you need from a database

A common use for Excel spreadsheets is to create databases of contacts or event attendees but a mere spreadsheet of names and details isn't...

Easy viewing for your spreadsheets – shading alternate rows

When you have a large database, it can sometimes be difficult to see the data clearly. In cases like this, it can be useful...

Never manually type a formula again!

Hands up if you've ever managed to lose a day or two trying to format an Excel spreadsheet! Don't worry, it happens to the best...

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...

DON'T MISS