11/100 Days of Data: Data Cleaning in Excel — Filtering, Sorting, and Formatting

Welcome to Day 11 of 100 Days of Data with Miss Mailiana.

In this video, we continue data cleaning in Excel by focusing on filtering, sorting, and formatting, three key steps every data analyst uses to understand and prepare a dataset before analysis.

We use the same dataset from Day 10, so you can practice and build confidence step by step.

In this video, you’ll learn:

How filtering helps you understand groupings in your data

How to sort data from oldest to newest or lowest to highest

How to identify remaining blank values during cleaning

How to format text using UPPER and LOWER functions

Why pasting formulas as values matters

Data cleaning is not a one-time task.
Issues often appear when you start filtering and sorting, and that’s normal.

Dataset used in this video

Download the dataset here and practice along:
https://drive.google.com/file/d/1QU7pjBA4C7Y7uHZXeCIFUd4hOQ72xh9a/view?usp=sharing

Use this dataset to experiment, make mistakes, and learn.

Join the learning community.

https://chat.whatsapp.com/BuV8yL0LGqd33E90UDwrrV

Subscribe and stay consistent with the 100 Days of Data 2026 challenge.

Let’s keep learning and building together.
#100daysofdata #datacleaning #excelfordataanalysis #learnexcel #DataAnalytics #missmailiana #100daysofdatawithmissmailiana

Видео 11/100 Days of Data: Data Cleaning in Excel — Filtering, Sorting, and Formatting канала Data with Miss Mailiana