- 19 (Registered)
If you are a newbie to collecting and managing data, then congratulations! You are here at the right place because we are going to introduce you to one of the most important aspects of any project that involves data: data collection. Sure, it’s not sexy, and this process is often overlooked by most researchers, but I can’t stress how important it is. I mean, how hard can it be to collect data? Well, it’s not difficult to collect, but if you don’t observe a few basic rules of data collection then you’re in a world of hurt when it comes to preparing and cleaning your data. If you’ve been there, then you know what I’m talking about. In this course, we’re going to give you the best start possible, introducing you to some of the best tricks you’ll ever learn, saving you weeks of misery!
The 14 Day Data Cleaning Challenge
This course forms Part 1 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.
At the end of this course you will receive a certificate of completion. Post it to Facebook, your LinkedIn page or print it out and stick it on your wall. Just don’t throw darts at it, ok…
- Over 1.5 hours of video content!
- 30 minutes of practice exercises
- Learn how to import data into Excel
- Learn how to record data on paper
- Learn how to set up a data worksheet for maximum effectiveness
- Learn how to enter data using Excel’s Data Entry form
- Learn data validation in Excel
- Loads of data entry tips and tricks
- Best suited for beginners
- Excel is used as a learning tool, but the lessons learned are transferable to other media
- Data files are provided for the student to practice with
- Practical learning experience with real data
Section 1 - Introduction to Data Collection
Section 2 - Importing Data into Excel
Section 3 - Recording Data on Paper
Section 4 - Manually Enter Data into Excel
- Anatomy of a Good Worksheet – Video
- Using Excel’s Data Entry Form – Video
- Data Files to Practice Using Excel’s Data Entry Form – Downloadables
- Data Validation in Excel – Video
- Data Files to Practice Data Validation in Excel – Downloadables
- Practice Session
- The 14 Day Data Cleaning Challenge – Day 2
- Data Entry Tips & Tricks – Video
- Data Files to Practice Data Entry Tips & Tricks – Downloadables
Section 5 - Data Collection Recap
Section 6 - Your Next Steps
- Over 1.5 hours on-demand video
- Language: English
- Certificate of Completion