Excel
Python
R
Data cleaning is a serious business – you’ll typically spend up to 80% of your time cleaning data!
In this course you’re going to learn how to clean your data - in Excel, Python and R - in hours rather than days or weeks!
I’ll teach you a method that took me several years to perfect, and as a result you’ll become much more productive, get your results faster and make your boss happy in the process.
The steps you’ll learn in this course are very simple to follow, but are extremely effective, so you’ll know that you’re getting the best start possible, saving you weeks of misery!
Video lessons
Articles
Downloadable resources
Certificate of completion
Interactive experience
Perfect for beginners
[wpc_button]
- Description
- Features
- Excel
- Python & R
- Outcomes
- CertificatE
- 14D2C2
Suitable for beginners to cleaning data in Excel (and those that have a basic grounding in Python and/or R), in this course you’ll learn to ‘play’ with your data, learning what you can and – more importantly – can’t do with it.
Each lesson starts with a quick question to get your mental juices flowing, then you’ll dive straight into the data. There will be LOTS of playing and practising with data in Excel and your choice of Python or R, and you’ll learn by doing.
Then you’ll finish each lesson with a quiz – by now you should have learned EXACTLY what the correct responses are, and answer with confidence!
Lee Baker
Data Cleaning Course
" This course can be taken as a stand-alone or as part of the series - the lessons learnt are equally valuable and will stay with you for a lifetime! "
Your Curriculum
1
Introduction to Data Cleaning
An introduction to this course and to the 14 Day Data Cleaning Challenge!
Open Access
Introduction to Data Cleaning
2
Removing Unwanted Spaces
In this chapter you'll how to remove all unwanted spaces from your data in one amazing move!
Open Access
Free Plan
Anatomy of a Good Workbook
Remove Trailing & Leading Spaces Part 1
Remove Trailing & Leading Spaces Part 2
Standardising the Case of Text Entries
3
Cleaning Text Data
The focus in this chapter is on how to clean your text data in Excel accurately and efficiently
Premium
Cleaning Text Data Using Remove Duplicates and Find & Replace
Cleaning Text Data Using Remove Duplicates and VLOOKUP
Cleaning Text Data Using Filter and Find & Replace
4
Cleaning Numerical Data
The focus in this chapter is on how to clean your numerical data in Excel accurately and efficiently
Premium
Identifying Text in Your Numerical Data
5
Order, Order, We Must Have Order...
In this chapter you'll learn the precise order in which to apply all the techniques you've learned
Premium
Order, Order, We Must Have Order…
6
Data Cleaning Recap
In this chapter you'll recap everything you've learnt and practice it all again!
Premium
Data Cleaning Recap
