Why is my CSV file saving as a SLYK file and...

This is a problem that we have recently encountered in our work and it took us a good while to find the solution. Now...

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

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

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

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

Use Advanced Filter to Remove Duplicates from your Database in Excel

I love databases. It's true. I'm a secret geek and I love finding new ways of working with Excel and making it do things...

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

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

Understand Numeric and Special Formatting in Excel 2013

Excel 2013 has a wealth of numeric formatting options which gives users the ability to perform number-crunching easily. In fact, Excel is designed to...

DON'T MISS