Save for later
Data Cleaning in Excel
Techniques to Clean Messy Data
Rarely do analysts begin working with a dataset without cleansing it first. Having clean data will allow for the highest quality of information for strategic decision-making. Data cleaning is also a vital part of the data analytics process. Data Cleaning in Excel: Techniques to Clean Messy Data, is for a beginner audience with basic computing skills, typing, and using Excel web. In this 90-minute Guided Project, you will explore the principles of tidy data, apply built-in Excel features to clean data, and use Excel functions to perform text manipulation. To achieve this, we will clean up untidy data set of student data containing names, registration numbers, addresses, marks for three courses, averages, total, and grades. This project is unique because you will learn by doing through step-by-step instruction using a real-world scenario to equip you with foundational data analysis skills that are useful for reporting data. In order to be successful in this project, prerequisites include basic computing skills, familiarity with Windows, files and folders, and basic typing.
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 2 weeks |
Effort | 90 minutes |
Starts | Jul 17 (earlier today) |
Cost | $9 |
From | Coursera Project Network via Coursera |
Instructor | Dr. Chao Mbogho |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Data Science |
Tags | Data Science Data Analysis |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Clean Room Medical Assembler $49k
Coordinator, Partnership for Clean Indoor Air $52k
clean room carpenter $66k
Deep Clean Sales Specialist $76k
Deep clean specialist $76k
Clean Room Environment Inspector 3 $76k
Clean Technology Investment Banking Analyst $89k
Manager, US Clean Products Scheduling $91k
Senior Clean Pack Chemist Lead $92k
Analyst - Clean Technology and Renewable Energy $96k
Clean Room Manufacturing Engineer $103k
Employer Program Manager at The Clean Air Campaign $111k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 2 weeks |
Effort | 90 minutes |
Starts | Jul 17 (earlier today) |
Cost | $9 |
From | Coursera Project Network via Coursera |
Instructor | Dr. Chao Mbogho |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Data Science |
Tags | Data Science Data Analysis |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course