Data Cleaning in Excel for Analysts and Researchers
Get your data ready for analysis effortlessly and save tons of time
We've moved! You can now get all our paid and FREE courses here.
“Data is a lot messier and noisier than people want to acknowledge” – Nate Silver
Having to correct errors and mistakes in your data is a waste of your time and it gets in the way of your analysis and getting your results.
But there are steps you can take not only to clean your data efficiently but also to minimise the errors going into your data in the first place.
When you learn the steps and the essential Excel tools you need to clean your data, you:
I have been there.
Every week, while I was working as a medical statistician at one of the largest research hospitals in Europe, somebody would bring me their new project data and give me the tightest deadline to get it analysed. The problem was that I had to clean it first, which took me weeks every time. So I had to develop a system to get the data analysis-ready quickly – and to also teach researchers how to reduce the errors and mistakes in their data before they gave it to me.
This system was fine-tuned over several years of being a statistician, and is what you will be learning in Data Cleaning in Excel For Analysts and Researchers.
This course will teach you step by step how to go from recording your data to getting it clean and ready for analysis. No more, no less. Everything is explained in simple language and is perfect for beginners.
If you’re not completely satisfied, come and tell me why you’re not happy and what you feel is missing. If I can’t fix it and make you happy within 30 days I will refund your money IN FULL, and you’ll still keep access to the entire course.
How long will it take to complete the course?
There are 5 modules in the course. All the materials are available for you from the moment you enrol. You will then be able to work through them at your own pace but most of our previous students have completed it in about 5 weeks.
How much time will taking the course actually save me?
When I first started analysing data it typically took me about 2 weeks to clean and prepare each dataset.
It now takes me just a couple of hours to clean and get each dataset analysis-ready.
I already use some of these steps/tools you have mentioned. Why should I take the course?
If you spend more than a week cleaning one single data set, you are wasting your time.
Learning the tools, techniques and procedures in this course will enable you to slash the time taken to just a few hours for each dataset.
I have already read your guide Practical Data Cleaning Guide. What is the difference between the book and the course?
The Practical Data Cleaning Guide is a general guide to data cleaning and is a useful starting point.
The video course, on the other hand, is very detailed and gives you every tool you need to actually clean your data quickly and efficiently, including all the Excel code and practical examples.
Can I ask questions in the course?
Yes, of course. There is a discussion section in the course where you can ask questions and I will also be available by email.
Once we've released the material to you, you can look at it in your own time and work through it at your leisure.
Is there a live component in the course?
At the moment there isn't, but if enough students ask for one I will be happy to do live demonstrations, Q&A sessions, etc. Feel free to get in touch and tell me what you need!
I am a scientist, not a specialist in data, is this course still good for me?
Yes, it is. Everything is explained in simple terms with the assumption that you're just starting out. The videos, slides, cheat-sheets, etc. will show you all the steps so you can apply them again and again to your data.
What is your refund policy on this course?
If you're not completely satisfied, come and tell me why you're not happy and what you feel is missing. If I can't fix it and make you happy withing 30 days I will refund your money IN FULL, and you'll still keep access to the entire course.
Lee Baker
Introduction to Data Cleaning in Excel for Analysts and Researchers (Video)
FREE PREVIEWIntroduction to Data Cleaning in Excel for Analysts and Researchers (Notes)
Introduction to Data Collection (Video)
FREE PREVIEWIntroduction to Data Collection (Notes)
1.1 Import Data into Excel (Video)
1.1 Import Data into Excel (Notes)
1.1 Data Files to Practice Importing Data into Excel (Downloadables)
1.2 Record Data on Paper (Video)
1.2 Record Data on Paper (Notes)
1.3 Anatomy of a Good Worksheet (Video)
1.3 Anatomy of a Good Worksheet (Notes)
1.4 Using Excel's Data Entry Form (Video)
1.4 Using Excel's Data Entry Form (Notes)
1.4 Data Files to Practice Using Excel's Data Entry Form (Downloadables)
1.5 Data Validation in Excel (Video)
1.5 Data Validation in Excel (Notes)
1.5 Data Files to Practice Data Validation in Excel (Downloadables)
1.6 Data Entry Tips & Tricks (Video)
FREE PREVIEW1.6 Data Entry Tips & Tricks (Notes)
1.6 Data Entry Tips & Tricks (Downloadables)
Data Collection Recap (Video)
FREE PREVIEWData Collection Recap (Notes)
Introduction to Data Cleaning (Video)
FREE PREVIEWIntroduction to Data Cleaning (Notes)
2.1 Anatomy of a Good Workbook (Video)
2.1 Anatomy of a Good Workbook (Notes)
2.2 Remove Trailing & Leading Spaces - Part 1 (Video)
2.2 Remove Trailing & Leading Spaces - Part 2 (Video)
2.2 Remove Trailing & Leading Spaces (Notes)
2.2 Data Files to Practice Remove Trailing & Leading Spaces (Downloadables)
2.3 Standardise the Case of Text Entries (Video)
2.3 Standardise the Case of Text Entries (Notes)
2.3 Data Files to Practice Standardising the Case of Text Entries (Downloadables)
2.4 Cleaning Text Data Using 'Remove Duplicates' and 'Find & Replace' (Video)
2.4 Cleaning Text Data Using 'Remove Duplicates' and 'Find & Replace' (Notes)
2.4 Data Files to Practice Cleaning Text Data Using 'Remove Duplicates' and 'Find & Replace' (Downloadables)
2.5 Cleaning Text Data Using 'Remove Duplicates' & 'VLOOKUP' (Video)
2.5 Cleaning Text Data Using 'Remove Duplicates' & 'VLOOKUP' (Notes)
2.5 Data Files to Practice Cleaning Text Data Using 'Remove Duplicates' & 'VLOOKUP' (Downloadables)
2.6 Cleaning Text Data Using 'Filter' and 'Find & Replace' (Video)
FREE PREVIEW2.6 Cleaning Text Data Using 'Filter' and 'Find & Replace' (Notes)
2.6 Data Files to Practice Cleaning Text Data Using 'Filter' and 'Find & Replace' (Downloadables)
2.7 Identifying Text in your Numerical Data (Video)
2.7 Identifying Text in your Numerical Data (Notes)
2.7 Data Files to Practice Identifying Text in your Numerical Data (Downloadables)
2.8 Order, Order, We Must Have Order (Video)
2.8 Order, Order, We Must Have Order (Notes)
2.8 Data Files to Practice Cleaning Text & Numerical Data (Downloadables)
Data Cleaning Recap (Video)
FREE PREVIEWData Cleaning Recap (Notes)
Introduction to Data Codification & Classification (Video)
FREE PREVIEWIntroduction to Data Codification & Classification (Notes)
3.1 Make Your Data Calculations (Video)
3.1 Make Your Data Calculations (Notes)
3.1 Data Files to Practice Making Your Data Calculations (Downloadables)
3.2 Code Your Data (Video)
FREE PREVIEW3.2 Code Your Data (Notes)
3.2 Data Files to Practice Coding Your Data (Downloadables)
3.3 Identify Your Data Types (Video)
3.3 Identify Your Data Types (Notes)
Data Codification & Classification Recap (Notes)
Introduction to Data Integrity (Video)
FREE PREVIEWIntroduction to Data Integrity (Notes)
4.1 Remove Unwanted Entries (Video)
4.1 Remove Unwanted Entries (Downloadables)
4.1 Remove Unwanted Entries (Notes)
4.2 Check That Your Numerical Data is Sensible (Video)
4.2 Check That Your Numerical Data is Sensible (Notes)
4.2 Data Files to Practice Descriptive Stats
4.3 Remove Outliers (Video)
4.3 Remove Outliers (Notes)
4.3 Data Files to Practice Removing Outliers (Downloadables)
Data Integrity Recap (Video)
Data Integrity Recap (Notes)
Work Smarter, Not Harder - Use DataKleenr (Video)
Work Smarter, Not Harder - Use DataKleenr (Notes)
FREE PREVIEWA Reminder of Everything You've Learnt (Video)
A Reminder of Everything You've Learnt (Notes)
Practical Data Cleaning Guide (eBook)
Practical Data Cleaning Template (Excel Workbook)
Practical Data Cleaning Cheatsheet (List of Dos & Don'ts)