0% found this document useful (0 votes)
11 views8 pages

Advanced Functions

Uploaded by

iyad mais
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
11 views8 pages

Advanced Functions

Uploaded by

iyad mais
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 8

Name First Last

Dr. Fernando Alonso #NAME? #NAME?


Dr. Lewis Hamilton #NAME? #NAME?
Mr. Charles Leclerc #NAME? #NAME?
Mr. Carlos Sainz #NAME? #NAME?
Yuki Tsunoda #NAME? #NAME?
Alex Albon #NAME? #NAME?
Mr. Valteri Bottas #NAME? #NAME?
Mr. Pierre Gasly #NAME? #NAME?
Work Days: 5

Profit: $3,050

Dates 03-Sep 04-Sep 05-Sep 06-Sep 07-Sep 08-Sep 09-Sep 10-Sep


# of days 1 2 3 4 5 6 7 8
Revenues 1,000 1,200 800 450 1,100 450 1,500 1,650
Expenses 250 350 180 400 320 330 400 650
Profit 750 850 620 50 780 120 1,100 1,000
11-Sep
9
900
350
550
ID Number Company Sale Amount Name Sale Amount
124300 Coca-Cola Inc. $5,436 Tesla Inc. $6,197
149160 Tesla Inc. $6,197 #NAME?
152143 Amazon UK $7,065
121715 Apple EMEA $8,054
109543 XYZ Limited $9,182
120497 Pepsi Co $10,467
122907 Adobe Inc $2,446
98326 Zara Fashion $2,691
88493 H&M Global $2,960
97343 Ralph Lauren Int. $3,256
99289 Adidas Co. $3,582
79432 P&G Global $3,940
Advanced IndexMatch
Country: Iceland
Year: 2023
Month: February
Sales: 10,654

2021 2021 2021 2022 2022 2022


Country January February March January February March
Spain 92,799 100,223 130,290 110,746 104,102 116,594
Italy 666,566 719,891 683,897 649,702 617,217 586,356
France 99,127 107,057 139,174 118,298 111,200 124,544
Portugal 65,468 70,705 91,917 78,130 73,442 82,255
Belgium 18,856 20,364 26,474 22,503 21,153 23,691
Holland 7,648 8,260 10,738 9,127 8,579 9,609
Switzerlan 9,865 10,654 13,850 11,773 11,067 12,394
Austria 11,061 11,946 15,530 13,200 12,408 13,897
Germany 78,305 84,569 109,940 93,449 87,842 98,383
Bulgaria 122,473 104,102 9,865 10,654 13,850 11,773
Greece 80,887 68,754 11,061 11,946 15,530 13,200
Poland 23,297 19,802 78,305 84,569 109,940 93,449
Norway 9,449 8,032 122,473 104,102 9,865 10,654
Sweden 12,188 10,360 80,887 68,754 11,061 11,946
Romania 13,666 11,616 23,297 19,802 78,305 84,569
Iceland 96,747 82,235 9,449 8,032 122,473 104,102
Finland 8,681 9,376 12,188 10,360 80,887 68,754
Albania 9,734 10,512 13,666 11,616 23,297 19,802
Serbia 68,908 74,421 96,747 82,235 9,449 8,032
Ireland 20,499 17,424 34,945 29,704 117,458 126,854
2023 2023 2023
January February March
130,585 146,255 160,881
557,038 529,186 582,105
107,057 139,174 153,092
90,480 99,528 109,481
20,137 17,117 18,828
10,089 10,190 106,468
9,865 10,654 70,317
11,061 11,946 20,252
96,416 94,487 8,214
11,067 12,394 10,596
12,408 13,897 11,880
87,842 98,383 84,104
13,850 11,773 9,589
15,530 13,200 10,751
109,940 93,449 76,112
9,865 10,654 93,692
11,061 11,946 61,879
78,305 84,569 17,822
122,473 104,102 7,229
164,910 140,174 9,324
Revenue by Manager Sum & Filter
Manager 2019 2020 2021 2022 Salesperson Year
Billy $1,087 $1,250 $1,188 $1,414 Billy 2019
Billy $1,239 $1,425 $1,354 $1,611
Billy $1,413 $1,625 $1,544 $1,837
Billy $1,611 $1,852 $1,760 $2,094
Jackson $1,836 $2,112 $2,006 $2,387
Jackson $2,093 $2,407 $2,287 $2,722
Jackson $489 $563 $535 $636
Jake $538 $619 $588 $700
Jake $592 $681 $647 $770
Jake $651 $749 $711 $847
Jake $716 $824 $783 $931
Jake $788 $906 $861 $1,024
Sara $867 $997 $947 $1,127
Sara $953 $1,096 $1,042 $1,240
Sara $1,049 $1,206 $1,146 $1,364
Sara $1,154 $1,327 $1,260 $1,500
Ann $1,038 $1,194 $1,134 $1,350
Ann $1,350 $1,552 $1,475 $1,755
Ann $1,755 $2,018 $1,917 $2,281
Ann $2,281 $2,623 $2,492 $2,966
Lana $1,330 $1,529 $1,453 $1,729
Lana $1,468 $1,688 $1,604 $1,909
m & Filter
Commission
#NAME?

You might also like