Home Tags Microsoft Excel

Tag: Microsoft Excel

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

Use Format Painter to Quickly Copy Conditional Formatting in Microsoft Excel

Conditional formatting is a handy tool in Excel that can help you to add visual highlights to data to identify trends, highlight errors or...

How to create a drop down menu in Excel using data...

In a previous article we showed you how to create useful data sets with data validation, however in this walkthrough we are going to show 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...

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

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 to: Word counts in Excel

Ever needed to know the word count of text in a certain cell in Excel? It's not something that you would need know often,...

DON'T MISS