Staff spotlight: The Spreadsheet King Uncovered

Date: Thursday, 28th April 2016 | Category: , , , , , , ,

We all know someone like it, every office seems to have one. But we truly believe our Excel Guru trumps them all.

Not only does he have his own mug highlighting just how much he loves spreadsheets, he is also fiercely protective over it – use it at your peril.

From planning his home renovations to budgeting, our Managing Director Matthew Burgess utilises a spreadsheet for every aspect of his life.

But as we all know, with great power comes great responsibility; and with all the Excel knowledge and expertise that Matthew has, we thought it only fair that he shared his top excel tips and tricks.

WARNING: the following content contains moderate excel-geek language, try and stay with us…

Tip 1: De-duplicate data

MB: “Knowing how to de-duplicate data is really useful for email management, especially when you have a list of hundreds or even thousands of contacts – you don’t want to be sending multiple emails to the same person. Poor email management could insinuate a lack of organisation and/ or management from the business, potentially leading to a lack of trust in the company”.

Learn more about de-duplicating data here.

Tip 2: Concatenate

MB: “The Concatenate function is really useful if you want to join multiple fields of data together. Just make sure you have designated spaces between the separate text entries otherwise they will run together”.

See how to do this and read more about the formula here.

Tip 3: SUMIF

MB: “One of the best calculation tools, the SUMIF function is a step on from the more commonly-known SUM function. It allows you to only calculate the numbers in a certain range if a cell/ cells within a certain range contain a specified value”.

Lost? See this page for further explanation and examples.

Tip 4: Column Filters

MB: “This is one that most people are probably aware of already but the ability to filter data is just so useful. By using a slicer as well, you can filter your pivot table data by simply clicking on the type of data that you want”.

Find out more here.

Liked these? Look out for more of our tips in upcoming blog posts or take a look back through previous articles to find ways of making your day that little bit easier.

Don’t forget you can also find us on Twitter @PhewUK and LinkedIn (Phew).