Data collection is one of the most important aspects of any project that involves data.
In this course you’re going to learn how to collect and enter your data into Excel effectively and efficiently.
Why? Because 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!
Video lessons
Articles
Downloadable resources
Certificate of completion
Interactive experience
Perfect for beginners
[wpc_button]
- Content
- Outcomes
- FORUM
- CertificatE
- 14D2C2
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.
Here's what you'll learn:
you’ll learn how to import data into Excel from a variety of sources – including entering data manually – gaining practical experience along the way
you’ll learn how to record data on paper, observing some simple but crucial data entry rules. This is a very important, but often overlooked, step in data collection
you’ll learn the anatomy of a good worksheet, ensuring that the structure of your data is correct right from the start
you’ll learn to use Excel’s Data Entry Form. This is one of Excel’s best kept secrets – hardly anybody knows about it!
you’ll learn to set up and use Data Validation in Excel to ensure your data are clean and error-free
you’ll learn all the best data entry tips and tricks that money can buy, slashing days and weeks off your data entry
Your Curriculum
1
Introduction to Data Collection
An introduction to this course and to the 14 Day Data Cleaning Challenge!
Open Access
CHAPTER HIGHLIGHTS
2
Importing Data into Excel
In this chapter you'll how to get data into Excel from various sources and manually
Open Access
Free Plan
CHAPTER HIGHLIGHTS
3
Manually Enter Data into Excel
The focus in this chapter is on how to manually enter your data into Excel efficiently
Free Plan
Premium
CHAPTER HIGHLIGHTS
4
Data Collection Recap
In this chapter you'll recap everything you've learnt and practice it all again!
Premium
CHAPTER HIGHLIGHTS
