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

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

Identifying unique values in a database

Conditional formatting is a very useful tool in Microsoft Excel that can be used for a variety of purposes when analysing data. It's particularly...

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

A common use for Excel spreadsheets is to create databases of contacts or event attendees but a mere spreadsheet of names and details isn't...

Video tip: Filling in blank cells in Excel

Here's our first Excel video tip, for those occasions where you have a spreadsheet full of data and group headings/categories have only been entered...

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

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

Using the ‘SUM’ Function in Excel

The formulas available to you in Excel are the reasons why most most of us love it, or are incredibly scared of it! But if...

A Fast and Easy Way to Separate Data

If you're an Excel user, chances are that at some point in your life, you have come across a spreadsheet stacked full of data...

DON'T MISS