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

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

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

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

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

Adding a custom font to Microsoft Office

Most applications that you use for day to day business come with a vast array of fonts already installed, however, now and again you...

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

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

Creating flexible ranges that grow with your database

When constructing formulas or using charts in Microsoft Excel, it's usual to have to define a range of cells to use in your formula....

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

DON'T MISS