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
На этой странице сайта вы можете посмотреть видео онлайн Data Cleansing in Excel | Tutorial длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Carolina Data Analyst 24 Ноябрь 2022, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 43,537 раз и оно понравилось 1.9 тысяч зрителям. Приятного просмотра!
