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

a. In excel folde (sales_data)

b. in excel folder (sales_data )

Total sum of sale		10032628.85
Average of Sales			3553.889072
Standard Deviation of Sales			1841.865106
Variance of Sales			3392467.068
Maximum Sales			14082.8
Minimum Sales			482.13

c. In excel folder (c-bit )

d. unable to customise ribbon as my excel version 2007 . In 2007 version , there is no option of ribbon customise .

The generally process to customise Ribbon is Select file > Options >customise Ribbon . To add a new tab to ribbon , select New tab and select option ADD . In case to remove tab in customise ribbon list , select it and select option REMOVE .

Renaming of tab can also be done by selecting option RENAME and select ok .

To add data formatting commands like font style , border style etc to custom group , choose and select list of commands and select ADD option . Commands gets added to custom group .

e. In excel (e-bit )

f. In excel (sales_data)

g. In excel folder (sales_data)

h.In excel folder (h-bit)

i.In excel folder (i-bit )

Data>text to coloum > select required option > finish

j.In excel (sales_data)--highlighted in blue