My first excel data cleaning

As I have started my Data analysis and science curriculum, Microsoft excel is the first tool we have learnt. In my life before getting into this course, I used to underestimate the power of Microsoft excel. Definition of Microsoft Excel This is a spreadsheet software developed by Microsoft that allows you to collect, organize, analyze, calculate and visualize data efficiently. The Excel Interface When open Microsoft excel, you first an interface made of various tools We start with the ribbon. The ribbon contains a toolbar that contains all the commands organized into tabs such, Home, Insert, Page Layout , Formulas, Charts and Data There is a formula Bar that content and formulas appear. In addition, we have Quick access toolbar that contains icons for Save, Undo and Redo. A row is a horizontal line of cells that runs from left to right across the grid while a column is a vertical line of cells that runs from top to bottom down the grid. A cell is where row and column intersect and form a single box. Cleaning A Dirty Dataset As we learnt about Data cleaning with Excel on dataset that was a bit very disorganized. We first started with sorting that data which basically means arranging the data in specific order. The sorting can be Text sorting which is A-Z or Z-A, Number sorting which is from largest to small and vice versa, Date sorting which is Oldest to Newest and vice vera. Next was filtering which allows you display data that meet certain criteria and hide the rest temporarily. Next, Number formatting changes how numbers display without altering their actual value. Conditional Formatting highlights cells automatically based on rules or criteria, helping spot trends or outliers. The dataset we were cleaning had a lot of duplicates, so it was important for us to remove the duplicates. Text functions for Cleaning Data Text functions are used to remove extra spaces , standardize text ,extract parts of strings or find and replace sub strings. text functions include UPP