Data Cleansing in Excel | Tutorial
Data Friends! Data cleansing, in general, is a fundamental skill for any data analyst and/or professional who wants to improve their analytical skills. Data cleansing not only helps prepare data for further analysis but also helps us become familiar with and understand the details of the data.
In this video, I'll show you how to clean your data sets with a simple yet effective approach using Excel.
This simple yet effective tutorial or guide will help you identify the most common tasks when performing data cleansing, helping you obtain the clean and organized data you need for your analyses and projects.
=======================
🔔 Subscribe to my channel: https://bit.ly/3xkFL62
🔍 More videos - Data Analytics: bit.ly/3QcaQRH
📚 Visit my blog: https://bit.ly/3NXVHSe [Articles and complementary material to the videos, recommendations, and more]
💲 Support my work: https://paypal.me/carolinacnb
========================
👉 Document link:
https://drive.google.com/uc?export=do...
=======================
Content:
0:00 Intro
0:22 Data set
1:20 Checklist for cleaning data
1:49 Table formatting
2:19 Spelling check (Spelling)
3:42 Remove invisible characters (Clean)
5:00 Remove extra spaces (Spaces)
7:18 Join two texts (&) / select the first letter of a word (Left)
9:07 Identify and remove duplicate data (Conditional Formatting - Remove Duplicates)
11:04 Convert text to uppercase (UPPERCASE)
11:47 Capitalize only the first words (PROPER)
12:22 Separate text into two or more columns (Text to Columns)
14:31 Errata
14:49 Join two texts and add extra text (CONCAT / &)
16:21 Format numbers / currencies / figures (find and replace)
17:44 Date format - Excel Doesn't recognize dates (Text to columns)
20:26 Rename "Boolean" text (IF / Find and Replace / SUBSTITUTE)
22:29 Identify and delete empty cells - null data (filters / conditional formats / special search).
24:15 Recommendation
On this page of the site you can watch the video online Data Cleansing in Excel | Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Carolina Data Analyst 24 November 2022, share the link with friends and acquaintances, this video has already been watched 43,537 times on youtube and it was liked by 1.9 thousand viewers. Enjoy your viewing!
