Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring

EXCEL PROJECT (1):

I have learned about the excel regarding data formation data cleaning ,pivot table with different like how to insert table column creating ribbon and changing specifix text.

And how to calculated different type of color changing dataset and finding the sum,max,min, average,unique ,value of different type of vaalues based on questions.

Creating the data set of pivot table and arranging the table set values ect.....,

Analysis the data with different type off years and in the particular field and changing the colors fields .

And how to create the conditional formatting of excel sheet to changing the years and specific column rows ect...

Then how to calculate the particular value for row and column ect...

and how to split the value for column and another column

And at last how to highlite the last column and particular value with use of option conditional formatting.