Separate Data into Columns in Excel or Google Sheets

Why use text to columns? If you're an Excel user, chances are that at some point in your life, you have come across a spreadsheet...

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

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

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

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

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

Custom Formats Part 1: Display numbers however you would like!

In Excel sometimes you need to format you cell in a way that is outside of the default and standard formatting provided. However, with...

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

How to create a double axis graph in Excel

Microsoft Excel’s chart functions help readers quickly visualise information and see insights buried within sheets of endless data. They can include bar charts, line...

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

DON'T MISS