Excel Data Cleaning Fundamentals
4.1 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
11 students enrolled

Excel Data Cleaning Fundamentals

How to detect and fix errors in datasets imported into Excel for data analysis
4.1 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
11 students enrolled
Created by Nasiru Musa
Last updated 7/2020
English
English [Auto]
Current price: $16.99 Original price: $24.99 Discount: 32% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 3 articles
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to detect and fix errors in datasets imported into Excel for analysis
  • How to categorize and fix errors in the different data types in excel using basic to advanced excel functions
  • Different concepts and techniques used in excel data cleaning
Requirements
  • Basic Knowledge of Microsoft Excel
Description

Analyst from time to time may need to analyze small datasets from larger datasets that may exist in other applications or other forms of storage for very quick results.

Excel has proven to be a very reliable support analytical tool in this regard , it is easy to learn and work with, it provides the analyst with reliable and easy ways of  importing datasets into excel for quick analysis.

The main challenge that analysts  face  having imported datasets into excel from different applications is the issue of data inconsistencies, anomalies and other errors.

The course is designed to provide the analysts with the necessary skill set to overcome this problem, by providing a step by step instruction using a follow along exercise and also several case study exercise and quizzes, on how to use basic to advanced excel functions , concepts and techniques in a fast and efficient way to detect and fix errors that result from datasets imported from other sources into excel for analysis.

The techniques in this course are simple but yet very effective in excel data cleaning , and will not require the use of macros or any excel add on tools

Who this course is for:
  • Analysts, who want a quick start in excel data cleaning
  • Consultants
  • Marketing professionals
  • Bankers
  • Accountants
  • Anybody who wants a quick start to some essential excel data cleaning concepts and techniques
Course content
Expand all 37 lectures 01:49:42
+ Introduction
3 lectures 06:08
What are the attributes of a good Data-set in Excel?
01:44
+ Data Cleaning- Text Values
1 lecture 02:29
Introduction to Text Data Type Data Cleaning
02:29
+ Text Values Data Cleaning: First Name Column Values
6 lectures 21:51
First Name Column Values : The CODE() and ASCII
03:19
Applying the CLEAN() function to clean non-printable characters
02:42
Applying the TRIM() function to clean Leading and Trailing Spaces
02:13
The PROPER() function to format Text Values
03:43
+ Text Values Data Cleaning Exercise: Last Name Column Values
3 lectures 11:15
Introduction to the Last Name Data Cleaning Exercise
01:16
CODE() function to detect errors in Last Name column values
04:46
Applying the =PROPER(CLEAN(SUBSTITUTE(CHAR()))) combination for data cleaning
05:13
+ Text Values Data Cleaning Exercise: Address Column Values
4 lectures 10:47
Introduction :The IF() function in the data cleaning exercise
01:07
CODE() Try it yourself Exercise: Detecting Errors in the Address Column Values
04:53
Combining the IF() with OR(),TRIM(),CLEAN(),SUBSTITUTE() and PROPER() functions
02:20
+ Text Values Data Cleaning Exercise: Mobile Phone Column Values
3 lectures 10:34
Introduction to exercise and try it yourself exercise: RIGHT() and LEN()
03:34
Applying the LEN() Function to check for errors in the Phone column
03:26
Combination RIGHT(),LEN() ,IF(IF()) and other functions to correct phone values
03:34
+ Text Values Data Cleaning Exercise: Currency Column Values
1 lecture 05:13
=TRIM(CLEAN(SUBSTITUTE(CHAR()))) to fix Text Errors
05:13
+ Text Values Data Cleaning Exercise: Airport Column Values
2 lectures 06:51
VLOOKUP() and IFERROR() in Data Cleaning
04:32
=IFERROR(VLOOKUP()) combination in fixing the column value Errors
02:19