Data Cleaning in Excel for Analysts and Researchers

Data Cleaning in Excel for Analysts and Researchers

Get your data ready for analysis effortlessly and save tons of time | taught by Lee Baker

Interested in this course? Email us at lee.baker@chi2innovations.com

Course description

Do you hate having to clean your data?

Are you tired of wasting weeks of your precious time trying to find errors and typos in your data?

“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:

  • become more productive and save hundreds of hours
  • get your results much faster
  • keep your boss happy

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.


What’s included in the course

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.

  1. Welcome and Overview
  2. Data Collection
    1. How to import data into Excel … for when you already have data
    2. How to record data on paper … for when you’re just starting out collecting data
    3. How to enter data Manually into Excel … for when you’ve collected your data and you need to transcribe it into Excel
  3. Data Cleaning
    1. How to remove Trailing and Leading Spaces ... and all other invisible and non-printing characters, from your entire dataset in just 60 seconds!
    2. How to clean Text Data ... correcting typos and incorrect entries and getting your text data ready for analysis
    3. How to clean Numerical Data ... identifying and correcting poorly formatted numerical data
  4. Data Codification and Classification
    1. How to make your data calculations … use formulae to calculate composite variables and prepare it for analysis
    2. How to code your data … get your text data ready for analysis – including transforming it to numerical codes
    3. Data Types ... learn the difference between ratio, interval, ordinal and nominal data to help make better analysis decisions
  5. Data Integrity
    1. Prepare your dataset for analysis ... learn how to transform a dataset that’s been created for data storage into one that’s analysis-ready
    2. Check that your numerical data is sensible ... real life has rules, and so does your data – learn how to discover and correct data that is not fit-for-purpose
    3. Remove outliers ... learn how to quickly and easily identify outliers in your data so you can decide whether to include or exclude them from your analysis
  6. Work Smarter


Some Extra Stuff for You:

  • Free - Practical Data Cleaning Guide
  • Free - An Excel workbook to help you get a great start
  • Free - A cheatsheet to print out and stick on the wall – a reminder of all the good techniques
  • Free - On completion of the course you will also get a certificate for your LinkedIn profile
    • prove to your boss or future employer that you can handle data efficiently

Special Bonus worth more than $2200:

  • Free - A 12 month DataKleenr licence
  • Free - 300 DataKleenr Credits

Your investment in Data Cleaning in Excel is $397

Guarantee

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.

Data Cleaning in Excel For Analysts and Researchers is the right course for you if…

  • You are starting on your data science journey and want to learn the essential elements of data cleaning
  • You are a researcher and want to stop wasting time collecting and cleaning your data so you can focus on doing your research
  • Your data will fit in an Excel spreadsheet
  • You want a course that takes you from beginning to end with a clear focus, no unnecessary lessons

Data Cleaning in Excel For Analysts and Researchers is NOT the right course for you if…

  • You’re a more experienced analyst who is looking to automate their data cleaning within their programming workflow (e.g. in Python, Java or R)
  • You work mostly on merging customer datasets within an organisation
  • Your data is so large it won’t fit in Excel

Frequently Asked Questions:

How long is the course?

There are 5 modules in the course. The materials in this course will be made available to you on a weekly basis.

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
Lee Baker
CEO Chi-Squared Innovations

I am an award-winning software creator with a passion for turning data into a story.

A proud Yorkshireman, I now live by the sparkling shores of the East Coast of Scotland. Physicist, statistician and programmer, child of the flower-power psychedelic ‘60s, it’s amazing I turned out so normal!

Every week, while I was working as a 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 I'll be teaching you in the Data Science University data cleaning courses.

I hope you get as much value out of these courses as the hundreds of researchers I've helped over the past decade.

Lee Baker

Lee.Baker@chi2innovations.com

Course Curriculum

2. Data Cleaning
180:45
Introduction to Data Cleaning (Video) FREE
Introduction 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
2.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
Data Cleaning Recap (Notes)
Hide Content

Interested in this course? Email us at lee.baker@chi2innovations.com

50372