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

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

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

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

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

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

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

How to analyse sales performance using conditional formatting in Microsoft Excel...

 Conditional formatting is a useful tool that formats your Excel data based upon certain criteria or conditions that you have set in Excel 2013....

DON'T MISS