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
En esta página del sitio puede ver el video en línea Data Cleansing in Excel | Tutorial de Duración hora minuto segunda en buena calidad , que subió el usuario Carolina Data Analyst 24 noviembre 2022, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 43,537 veces y le gustó 1.9 mil a los espectadores. Disfruta viendo!
