How to calculate the difference between two dates in Excel

There might be a number of reasons why it would be handy to be able to calculate the difference between two dates in Excel...

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

Scaling an Excel worksheet to print to an A4 page

By the nature of what spreadsheets are used for, there's not often a need to print them, however, now and again you might want...

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

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

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

How Do I Produce A Graph From A Table In Excel?

A frequently asked question by many of our readers, so we thought we'd tackle this little task first, and show you how to make...

Custom Formats Part 2: bespoke dates and times

Following on from our previous article about using custom formatting in Excel, this time we will look at how to change the formatting of...

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

DON'T MISS