Challenge

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

Row LabelsSum of SALESGrand Total10034514.18

Singapore 288488.41
Spain 1215686.92
Sweden 210014.21
Switzerland 117713.56
UK 478880.46
Austria 202062.53
Belgium 108412.62
Australia 630623.1
Canada 224078.56
Denmark 245637.15
Finland 329581.91
France 1110916.52
Germany 220472.09
Ireland 57756.43
Italy 374674.31
Japan 188167.81
Norway 307463.7
Philippines 94015.73
USA 3627386.157
(blank) 2482.007779
SLNO CELL VALUE RESULT
S1 1680 1680 2019
S2 1670 2019
S3 1680 2021 2020
S4 1689 2022
S5 1680 2023 2021
S6 1937 1744
S6 1680 1834 2022
S7 1677 1934
S8 1680 1678 2023
Total 16955
Average
15373 16955
3074.6 4624.091

Sum of SALES

10034514.18
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.