Course Description

We've moved. You can find our courses here.

Do you feel like data cleaning is a waste of your time?

Does having to correct errors in your dataset frustrate you?

“Data is a lot messier and noisier than people want to acknowledge”

Nate Silver


There are steps you can take to become more organised and efficient with your data and if you follow them, you can get it cleaned more quickly and easily - saving you time and money.


When you learn the organisational tips and tricks in this course, you WILL:

  • save hours and hours of work
  • simplify your data cleaning process
  • get your results much faster
  • keep your boss happy

Learn the steps to become more organised and efficient with your data in Excel. Enrol in this course NOW!


How do I know?

Because cleaning data was a major part of my job as a medical statistician. And I don't mean 'major' as in 'important', I mean it took up most of my time. I usually had to spend weeks to clean a single dataset and it seriously impacted on everybody's deadlines, not just my own. So I had to develop a process to get the data analysis-ready quickly.
This process was fine-tuned over several years of being a statistician and this course will teach you the first step of the whole process.
The first thing you need to do is to get organised with your data, how to enter your data onto a single worksheet and how to utilise your entire workbook. When you get organised like this your data cleaning processes become much easier and faster, giving you time to top up your tan at the beach.

This is what you will be learning in Data - Getting Yourself Organised in Excel.


What’s included in the course

This video course - totalling more than an hour of video lessons - will teach you the anatomy of a good worksheet and why it's important to get these basics right from the start.

It will also teach you the anatomy of a good workbook, and how to build a chronological flow into your data cleaning processes so you can detect when, how and where errors were introduced. This will save you from spending hours trying to find these "new" errors and will save your patience and your eyesight.

Everything is explained in simple language and is perfect for beginners.


  1. Welcome and Overview
  2. Anatomy of a Good Worksheet
    • The Dos and Don'ts that Define a Good Worksheet ... so you can get it right first time and not waste time reformatting your dataset 
  3. Anatomy of a Good Workbook
    • What Makes a Great Workbook? You'll Find Out in This Lesson ... so you can quickly and easily identify errors that need your attention, fast-tracking all your data cleaning operations
  4. Recap



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 technique


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 - Getting Yourself Organised in Excel is the right course for you if…

  • You are starting on your data journey and want to learn the essential elements of getting your data organised
  • You want to stop feeling like you're wasting your time collecting and cleaning your data
  • You want a simple process that you can follow again and again
  • Your data will fit in an Excel spreadsheet


Data - Getting Yourself Organised in Excel 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
  • You enjoy cleaning your data
  • Your data is so large it won’t fit in Excel

Frequently Asked Questions:

How long is the course?

There are 4 short modules in the course. All materials will be made available to you immediately upon enrolment and you can complete the course at your leisure.

How much time will it take me to complete the course?

The videos last for a little over an hour - but the lessons learnt will stay with you for a lifetime...


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.
Getting yourself organised will help you build checks and balances into your data handling so that you begin to learn how to clean your data automatically. Don't be surprised if your data cleaning time is slashed by half after taking this course!

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.

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.









CEO Chi-Squared Innovations

Lee Baker

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.

Course curriculum

  • 1

    Welcome and Overview

  • 2

    1. The Anatomy of a Good Worksheet

    • The Dos and Don'ts That Define a Good Worksheet (Video)

    • The Problem With Data (Video)

    • The Dos and Don'ts That Define a Good Worksheet (Notes)
  • 3

    2. The Anatomy of a Good Workbook

    • What Makes a Great Workbook? You'll Find Out in This Lesson (Video)

    • What Makes a Great Workbook? You'll Find Out in This Lesson (Notes)
  • 4

    Recap

    • Recap (Video)

    • Recap (Notes)

    • Your Next Step (Video)
  • 5

    Supplementary Material

    • Practical Data Cleaning Guide (eBook)

    • Practical Data Cleaning Template (Excel Workbook)

    • Practical Data Cleaning Cheatsheet (List of Dos & Don'ts)

Reviews

5 star rating

Great Overview, Template and Cheat Sheet

Lawrence Groves

Course was thorough on setting up Excel for Data Cleaning. Great tips on best practices. Appreciate the workbook Sample and Cheat Sheet in case I need to r...

Read More

Course was thorough on setting up Excel for Data Cleaning. Great tips on best practices. Appreciate the workbook Sample and Cheat Sheet in case I need to refresh myself on the material

Read Less