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

Two easy ways to split text in Google Sheets

Manipulating data is one of the key functions of spreadsheet use, and you might already be aware of the various options for separating data...

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

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

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

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

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