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

a. Do proper formatting of the data with using borders, font size and appropriate alignment of the content.

used borders, font size - heading(14),other(12)

b. Make summary of Products Sales by providing

1. Total Sum of Sales -

   10032628.85

2. Average of Sales -

   3553.889072

3. Standard Deviation of Sales -

   1841.865106

4. Variance of Sales -

   3392467.068

5. Maximum Sales -

   14082.8

6. Minimum Sales -

   482.13

c. Analyse the sales happened by product line & status using pivot table

Cancelled DisputedIn ProcessOn Hold Resolved Shipped Grand Total

Classic Cars	59242.81	26012.87	57760.66	49039.65	25799.34	3701760.33	3919615.66
Motorcycles		31821.9		4992.61		1129573.83	1166388.34
Planes	35432.71	3843.84		34727.53	34532.92	866466.57	975003.57
Ships	56665.65	3070.4		23664.61	39863.71	591172.76	714437.13
Trains	5082.42			5808.48		215352.57	226243.47
Trucks and Buses			43026.41	20193.29	20472.75	1044097.39	1127789.84
Vintage Cars	38063.89	7463.85	43942.89	40553.02	30049.56	1743077.63	1903150.84

Grand Total 194487.48 72212.86 144729.96 178979.19 150718.28 9291501.08 10032628.85

h. Calculate the total sales of all “Shipped”, “Cancelled”, “Disputed”, “In Process”, “On Hold”, “Resolved” products. (Hint:Use pivot table or sumif function)

Row Labels Sum of SALES

Shipped	9291501.08
Cancelled	194487.48
Disputed	72212.86
In Process	144729.96
On Hold	178979.19
Resolved	150718.28

Grand Total=10032628.85

d. Make Customized Tab by naming ABC and keep few data formatting commands in the newly created Tab.