10 Excel Tricks Template
Get 10% OFF our course using coupon code EMAIL10
Get Our Excel for Business & Finance Course
Made by Kenji Explains / Career Principles
Note
All content is copyright material of Kenji Explains / Career Principles
This Excel model may not be reproduced or distributed by any means, including printing,
screencapturing, or any other method without the prior permission of the publisher.
Customer ID First Last Brand Product City Country Fulfillment (%) Price
1295 Bill Smith Nike Magista ShoesLondon UK 0% 122.79
1301 Harley Fritz Nike Football Shirt Tampa USA 30% 122.76
1304 Nyla Novak Nike Air Max Tokyo Japan 30% 81.6
1346 Bruce Rich Nike Air Max London UK 60% 122.79
Product Customer ID First Last Brand City Country Fulfillment (%Price
Magista Shoes 1295 Bill Smith Nike London UK 0% 122.79
V-Neck Tshirt 1298 Kennedi Singh Armani Madrid Spain 0% 204.62
Football Shirt 1301 Harley Fritz Nike Tampa USA 30% 122.76
Air Max 1304 Nyla Novak Nike Tokyo Japan 30% 81.6
Casual Shoes 1307 Ivan Hines New Balance London UK 100% 203.79
Core Sprinter 1310 Jonah Higgins Asics London UK 100% 122.77
Core Ss Top 1313 Jordan Boone Asics Berlin Germany 100% 123.96
Casual Shoes 1316 Kylee Townsend New Balance Berlin Germany 30% 206.97
Casual Shoes 1319 Nora Rollins New Balance Madrid Spain 60% 207.14
Japan Shirt 1322 Brendan Walls Asics Berlin Germany 60% 122.79
Casual Shoes 1325 Steven Michael New Balance Berlin Germany 100% 122.76
Core Ss Top 1328 Lucia Mckay Asics Madrid Spain 60% 81.6
Core Ss Top 1331 Josue Roach Asics Paris France 100% 54.67
Football Shoe 1334 Franklin Wright Puma Paris France 30% 203.79
Football Shoe 1337 Denzel Flores Under ArmourParis France 100% 123.96
Football Shoe 1340 Bruno Cordova Uniqlo Paris France 100% 206.97
Core Sprinter 1343 Jaylynn Knapp Asics Tokyo Japan 100% 207.14
Air Max 1346 Bruce Rich Nike London UK 60% 122.79
Dunk High Ret 1349 Bryce Carpenter Lululemon Tokyo Japan 60% 122.76
Dunk High Ret 1352 Jaidyn Andersen Lululemon Madrid Spain 60% 81.6
Week 1 Financials by Country
ID Date Product Country Revenue Profit
1185732 9/26/2022 Coca-Cola Mexico $4,975 $2,488
1185732 9/26/2022 Coca-Cola United States $23,880 $11,940
1185732 9/26/2022 Coca-Cola Canada $12,935 $3,363
1185732 9/26/2022 Coca-Cola France $23,880 $9,552
1185732 9/26/2022 Coca-Cola Spain $7,960 $6,368
1185732 9/26/2022 Coca-Cola Italy $16,915 $7,612
1185732 9/26/2022 Coca-Cola Germany $19,900 $7,960
1185732 9/26/2022 Coca-Cola UK $18,905 $9,453
1185732 9/26/2022 Coca-Cola Portugal $15,920 $4,776
1185732 9/26/2022 Coca-Cola Belgium $10,945 $2,189
1185732 9/26/2022 Coca-Cola Austria $17,512 $8,756
$30,000
$25,000
$20,000
$15,000
$10,000
$5,000
$0
Mexico United Canada France Spain Italy Germany UK Portugal Belgium Austria
States
Revenue Profit
Week 2 Financials by Country
ID Date Product Country Revenue Profit
1185732 9/26/2022 Coca-Cola Mexico $32,000 $2,488
1185732 9/26/2022 Coca-Cola United States $17,596 $11,940
1185732 9/26/2022 Coca-Cola Canada $15,522 $3,363
1185732 9/26/2022 Coca-Cola France $33,403 $9,552
1185732 9/26/2022 Coca-Cola Spain $35,640 $6,368
1185732 9/26/2022 Coca-Cola Italy $20,298 $7,612
1185732 9/26/2022 Coca-Cola Germany $23,880 $7,960
1185732 9/26/2022 Coca-Cola UK $22,686 $9,453
1185732 9/26/2022 Coca-Cola Portugal $19,104 $9,990
1185732 9/26/2022 Coca-Cola Belgium $32,413 $15,839
1185732 9/26/2022 Coca-Cola Austria $35,424 $19,540
$40,000
$35,000
$30,000
$25,000
$20,000
$15,000
$10,000
$5,000
$0
Mexico United Canada France Spain Italy Germany UK Portugal Belgium Austria
States
Revenue Profit
Country GDP
China
India
United States
Indonesia
Pakistan
Nigeria
Brazil
Bangladesh
Russia
Mexico
Regional Sales Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21
Spain 92,799 100,223 130,290 110,746 104,102 116,594 130,585 146,255
Italy 666,566 719,891 683,897 649,702 617,217 586,356 557,038 529,186
France 99,127 107,057 139,174 118,298 111,200 124,544 107,057 139,174
Portugal 65,468 70,705 91,917 78,130 73,442 82,255 90,480 99,528
Belgium 18,856 20,364 26,474 22,503 21,153 23,691 20,137 17,117
Holland 7,648 8,260 10,738 9,127 8,579 9,609 10,089 10,190
Switzerland 9,865 10,654 13,850 11,773 11,067 12,394 9,865 10,654
Austria 11,061 11,946 15,530 13,200 12,408 13,897 11,061 11,946
Germany 78,305 84,569 109,940 93,449 87,842 98,383 96,416 94,487
Total 1,049,695 1,133,671 1,221,810 1,106,928 1,047,009 1,067,724 1,032,729 1,058,538
Trendline
Revenue by Salesman $40,000
ID Name Sales Commission (%) $35,000
1185732 Bill $32,000 18%
$30,000
1185732 Kennedi $17,596 24%
1185732 Harley $15,522 30% $25,000
1185732 Nyla $33,403 10% $20,000
1185732 Ivan $35,640 12%
$15,000
1185732 Jonah $20,298 40%
1185732 Jordan $23,880 18% $10,000
1185732 Kylee $22,686 18% $5,000
1185732 Nora $19,104 18%
$0
1185732 Brendan $32,413 12% Bill Kennedi Harley Nyla Ivan Jonah Jordan Kylee Nora Brendan Steven
1185732 Steven $35,424 15%
Sales Commission (%)
Kylee Nora Brendan Steven
sion (%)
Sales Actuals Thousands Millions
Toyota 14,350,303 14,350,303 14,350,303
Honda 11,480,242 11,480,242 11,480,242
Audi 15,785,333 15,785,333 15,785,333
Hyundai 12,628,267 12,628,267 12,628,267
Ford 17,363,867 17,363,867 17,363,867
Tesla 13,891,093 13,891,093 13,891,093
Renault 19,100,253 19,100,253 19,100,253
Mercedes 15,280,203 15,280,203 15,280,203
Ferrari 21,010,279 21,010,279 21,010,279
Aston Martin 16,808,223 16,808,223 16,808,223
Week 21 Sales
Figures in USD Monday Tuesday Wednesday Thursday Friday
Spain 92,799 100,223 130,290 110,746 104,102
Italy 666,566 719,891 935,859 795,480 747,751
France 99,127 107,057 139,174 118,298 111,200
Portugal 65,468 70,705 91,917 78,130 73,442
Belgium 18,856 20,364 26,474 22,503 21,153
Holland 7,648 8,260 10,738 9,127 8,579
Switzerland 9,865 10,654 13,850 11,773 11,067
Austria 11,061 11,946 15,530 13,200 12,408
Germany 78,305 84,569 109,940 93,449 87,842
Slovenia 99,857 107,846 140,199 119,169 112,019
Total 1,149,552 1,241,516 1,613,971 1,371,875 1,289,563
Weekly Total 6,666,477
Weekly Average 1,333,295
