11/100 Days of Data: Data Cleaning in Excel — Filtering, Sorting, and Formatting скачать в хорошем качестве

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/1QU7p... Use this dataset to experiment, make mistakes, and learn. Join the learning community. https://chat.whatsapp.com/BuV8yL0LGqd... 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