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
Auf dieser Seite können Sie das Online-Video Data Cleansing in Excel | Tutorial mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Carolina Data Analyst 24 November 2022 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 43,537 Mal angesehen und es wurde von 1.9 tausend den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
