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
Sur cette page du site, vous pouvez voir la vidéo en ligne Data Cleansing in Excel | Tutorial durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Carolina Data Analyst 24 novembre 2022, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 43,537 fois et il a aimé 1.9 mille téléspectateurs. Bon visionnage!
