From the course: Excel: Managing and Analyzing Data

Unlock the full course today

Join today to access over 24,200 courses taught by industry experts.

Deciding if your data is ready for use

Deciding if your data is ready for use - Microsoft Excel Tutorial

From the course: Excel: Managing and Analyzing Data

Start my 1-month free trial Buy for my team

Deciding if your data is ready for use

“

- [Instructor] Now that you've checked your data, possibly done some data cleansing, there's one question, is your data ready to be used? Can you trust it? To answer that, you have to be clear. What are you trying to accomplish? Are you trying to get payroll calculated? Are there inventory issues? Are there orders that you have downloaded from the backend of the website and had to investigate and see if it's ready? That helps you to determine what you need to have and if you have it, and if it's in a format that you need. And then you have to really ask yourself, "What is at stake?" If the data's corrupt, are you looking at maybe mild embarrassment, or might you send termination warning letters out to the wrong people? Very different stakes there. If you send happy new year postcards out and somebody gets four and a bunch of people get none, that's low stakes. It'd be embarrassing, but nobody is going to get scared…

Contents