Challenge

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

b)

i. Total Sum of Sales 10032628.9
ii. Average of Sales 3553.88907
iii. Standard Deviation of Sales 1841.53885
iv. Variance of Sales 3391265.34
v. Maximum Sales 14082.8
vi. Minimum Sales 482.13

c) Added in new Sheet

d) Added customization in the ribbon

e) Analysed with pivot table in sheet 1

f) conditional formatting is given in the respected tab.

Your portfolio, next

Ship work like this
in your own course.

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.