Changing text case in Microsoft Excel

Recently, I had some databases sent in from a client that needed uploading to their CRM system. The problem is that that data wasn't...

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

DON'T MISS