Data Wrangling (Cleaning) in Excel



One of my first steps in Data Wrangling / Cleaning is creating a new column right next to the Vice President column.  Notice in the left column that there are extra spaces between the words...what I did was a trim function in the new column and copied the result within.



 



Next, seeing the salary is in text format where it should be in either currency or number (integer).  Will change in within the drop down from text to number.






This is more in the reporting category but this is conditional formatting highlighting the values between $15,000 to $25,000.


















Popular posts from this blog

Pivot Table

Image
  Below is a regular table then a pivot table.  The pivot table has the retailer column that has the sum of Price per Unit column as well as the Sum of Units Sold.   Retail Partners Table Pivot Table
Read more

Removing Duplicates in Excel

Image
  There is a duplicate row of a president (showing below), I'm going to remove it by selecting the DATA menu and then selecting the Remove Duplicates icon.  
Read more