Suitable for beginners to data validation 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. 

With each lesson you’ll dive straight into the data. There will be LOTS of playing and practising with data, 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! 

With the fundamentals mastered in Excel, you’ll then learn to make the transition to your choice of Python or R and gain confidence in knowing precisely how to do the same analyses you learned in Excel in the programming language of your choice.

In this course, you will get:

I won't formally teach the concepts in Python or R, but I will point you in the right direction with strong code hints.

Why?

I could just hand you all the code to use, but that wouldn't aid your learning path and would only hinder your progress in the long run.

The best way for you to make the transition from Excel to Python/R is for me to:

So for every exercise you will be encouraged to write your own code to perform precisely the same data cleaning tasks in Python/R as you do in Excel.

Don't worry - there are already pre-built functions in Python that we can use. It's all rather straight-forward!

In this course, Excel is used as a learning tool, but the lessons learned are transferable to other media - like Python and R, and you will learn how to:

This course has a dedicated forum where you can ask questions, get answers and connect with our learners.

You can find the forum here:

Students completing the course will have the knowledge and confidence to be able to make their data fit-for-purpose and follow real-life rules in Excel (and optionally in Python and R as well) quickly and accurately.

Complete with HD videos, data, examples and practice exercises, you’ll be able to work alongside the instructor as you work through each concept, and will receive a certificate of completion upon finishing the course.

Oh, yes – and there are lots of little surprises for you along the way!

This course is Part 4 of our 14 Day Data Cleaning Challenge, where I’m going to teach you a method of data cleaning and preparation that I developed some years ago. It’s been tried and tested by hundreds of people, and it’s been tweaked along the way, improving it so that it’s always up-to-date and always works!

It will help you get your data clean and analysis-ready in minutes rather than weeks.

Yes, you read that correctly – minutes!

The 14D2C2 is a 14 day course that will take you through 1 hour of video lessons and practice sessions every day. In other words, with a 1 hour investment daily for 14 days you will become an expert in data collection, cleaning and preparation!

If you’re ready to take the 14D2C2, email me and I’ll send you the details to get started.