Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
- In this project i done Formatting and conditional formattting For highlightening the data
- i am converted the data to a proper date functions with help of Find and replace functions
- I am using the pivot tables for more comfortable with this data to make summarry data from the sales data
- i am highlighted the columns by containing the different values that contains by different colours and highlighted the top 10% in an the column
- i am make customized ribbon tab named ABC and it keeps all formatting options