Blog

Recent Post

Statistics – The Last Dark Art?

Statistics – The Last Dark Art?

In the first post in our ‘Discover Stats’ Blog Series we explain what stats is, what it isn’t and why you should take the time to learn the basics… No, wait, stop running – it’s really not that difficult. Honest! Come back and let me explain… Continue Reading

How to Clean Data Using Excel COUNTIF

How to Clean Data Using Excel COUNTIF

​Cleaning numerical data can take a ridiculous amount of time​, but learning to use ​Excel COUNTIF can save you a lot of time and hassle…​…and having to explain to your boss why that analysis report isn’t on his desk yet, a mere 2 weeks after he gave you the dataset! Bless him, he doesn’t understand. He…

How to Clean Text Data Using Excel VLOOKUP

How to Clean Text Data Using Excel VLOOKUP

​In this blog post I’m going to show you how you can combine Excel VLOOKUP with Remove Duplicates ​to clean text data.​​​It’s interesting that there is plenty of information in Excel’s help files about the way Microsoft suggests that you use ​these functions, but nowhere do they mention that you can use them to clean text…

Data Coding – Top 3 Data Classification Tips

Data Coding – Top 3 Data Classification Tips

​This blog post is all about data coding, and will give you our top 3 tips on how best to code your data. ​It is the third blog post in the series, following hot on the heels of 11 Essential Tips for Effective Data Collection and 5 Data Cleaning Techniques You Need To Learn. Here we deal with coding…

5 Data Cleaning Techniques You Need To Learn

5 Data Cleaning Techniques You Need To Learn

The previous blog post in this series 11 Essential Tips for Effective Data Collection dealt with practical data collection methods. This blog post is the second in the series and will teach you the 5 most important data cleaning techniques that you’ll ever need​. Data cleaning may not be everyone’s favourite part of working with data, but…

Data Collection Techniques – 11 Essential Tips

Data Collection Techniques – 11 Essential Tips

​This blog post will deal with data collection techniques and good data management practices in Excel, and will give you some great tips on how to get organised and avoid making the kind of mistakes that will make you prematurely grey!Over the next couple of weeks I will deal with other important issues such as…

Do NOT follow this link or you will be banned from the site!