Privacy settings

This website protects your privacy by adhering to the European Union General Data Protection Regulation (GDPR). We will not use your data for any purpose that you do not consent to and only to the extent not exceeding data which is necessary in relation to a specific purpose(s) of processing. You can grant your consent(s) to use your data for specific purposes below or by clicking “Agree to all”.

i
Cleaning Data in Excel

Video

Cleaning Data in Excel

Anyone with a little experience in working with data knows: data often is messy. Datasets with errors, missing values, wrong formatting: before beginning an analysis or visualising data, there is a lot of work in cleaning and transforming data.

For very small data sets it often makes sense to do the cleaning and transforming manually. You can just type in the correct data or make some calculations yourself. But when the data set you are working with contains tens, hundreds, thousands or even more lines, this manual approach is no longer feasible. It would just take up to much time and the risk of making errors becomes too big.

So for cleaning up larger data sets, you need tools. And there are some very powerful tools out there that can clean up data. But most of them are aimed at advanced users: very often programming skills are needed. As this course isnt aimed at programmers, we are going to use an everyday tool a lot of people already are familiar with: Microsoft Excel.

So in this course we'll introduce and demonstrate some useful Excel commands and formulas for cleaning up and transforming data. But youll also learn some strategies and tricks for managing your data cleaning processes.

No prior knowledge is needed, but a little knowledge of Microsoft Excel will come in handy.

Teacher

Related

Receive insights, knowledge and updates on funding opportunities.
Receive our monthly update, delivered straight to your inbox.