The Hive - Learn, Help, Connect

​Beginner’s Guide to Effective Data Collection

​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


$ 47

$ 100

Try it first - decide later!

​No obligation to buy or register


Single Payment

Lifetime Access


All Access Pass

  • ​Description
  • ​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:

1.

​you’ll learn how to import data into Excel from a variety of sources – including entering data manually – gaining practical experience along the way

2.

​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

3.

​you’ll learn the anatomy of a good worksheet, ensuring that the structure of your data is correct right from the start

​4.

​you’ll learn to use Excel’s Data Entry Form. This is one of Excel’s best kept secrets – hardly anybody knows about it!

​5.

​you’ll learn to set up and use Data Validation in Excel to ensure your data are clean and error-free

​6.

​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

100% Satisfaction Guarantee for 30-Days

​​We are proud to offer a 30 day no-quibble money back guarantee.

We don't like being hassled when we want our money back, and we extend that same courtesy to you.

​You can be refunded in full any time during the first 30 days of your purchase or subscription*. After the 30 day period you will not be able to get a full refund, but you may cancel ​your subscription any time you like.

*If any member exceeds 10% of total progress or ​logs in several times and follows the majority of ​any premium course, we reserve the right to refuse refund.

CEO Lee Baker

Got any questions or comments? I need your feedback to help me create the perfect course for your needs!

​Ask your ​questions ​below.

Your view really matters, and I will respond to every comment personally!


How to analyse categorical survey data in Excel and in R
Do NOT follow this link or you will be banned from the site!