Basic Data Cleaning for Data Analysts

This concise tutorial explores essential Excel functions for effective data cleaning for Data Analysts.

Timestamps:

00:00 Introduction
01:01 Auto Fit: Learn how to adjust column widths automatically to fit your data.
01:34 CONCATENATE() and &: Combine text from multiple cells into one.
03:28 UPPER(): Convert text to uppercase letters.
03:40 LOWER(): Change text to lowercase letters.
03:50 PROPER(): Format text to capitalize the first letter of each word.
05:50 Replace Blank: Fill in or replace blank cells within your dataset.
07:00 TRIM(CLEAN): Eliminate extra spaces from text strings and remove non-printable characters from text
08:20 Date Fixed Width: Convert and format dates using fixed-width settings.

Dataset Download :
https://bitly.cx/rUvbL