B04: Data Cleaning

Ensuring accuracy, Improving consistency, Reducing errors, Saving time

Data Cleaning features

Data cleaning

is a crucial step in any data analysis project, as it helps to ensure the accuracy and reliability of the data, and enables more effective analysis and decision-making.

=UPPER(cell address)

for Upper case conversion

=LOWER(cell address)

for Lower case conversion

=PROPER(cell address)

for Sentence case conversion

TRIM function

is used to eliminate excess spaces and tab spaces in the Excel worksheet cells

Find and Replace

will help you fetch and replace data in the entire worksheet to help in organizing and cleaning data in Excel

Flash Fill

A feature in Microsoft Excel that allows you to quickly fill in values in a column based on patterns or examples that you provide.