ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Final Project - Intermediate Excel by LearnByte
3
Lembar Kerja berikut merupakan Final Project Official dari PT LearnByte Edukarya Nusantara. Dilarang Keras untuk menyebar dan menduplikasikan file tanpa izin!
4
5
NAMA LENGKAPIRWAN SULISTIYO
6
7
INSTRUKSI (Bacalah 7 instruksi di bawah ini)
TanggalNama SalespersonID NumberTujuan PengirimanTotal Nilai BarangID Number Tujuan Pengiriman Total Nilai Barang Nama Salesperson Tanggal Asal Gudang Golongan Transaksi
8
15 Apr 2023Rini SetiawanJG-7307011/GCHAIndia Rp 2.756.098.170 BV-2912260/CJYBrunei Rp 1.523.162.756 Ika Suryani21 Okt 2021Gudang JayaTransaksi Makro
9
1Berdasarkan ID Number, carilah Tujuan Pengiriman (pada kolom O) dan Total Nilai Barang (pada kolom P)13 Nov 2022Dito NugrohoEP-4800088/GSBrunei Rp 597.004.358 JG-9105472/GHRPNIndia Rp 842.465.032 Dito Nugroho27 Agu 2021Gudang HarapanTransaksi Menengah
10
25 Nov 2021Bagus KurniawanBV-6109444/GSHongkong Rp 2.109.206.166 EP-3920039/GHRPNSingapore Rp 282.062.017 Adi Pratama27 Jan 2023Gudang HarapanTransaksi Mikro
11
2Berdasarkan ID Number, carilah Nama Sales Person (pada kolom Q) dan Tanggal (pada kolom R)28 Des 2021Bagus KurniawanJG-1303811/GCHAMalaysia Rp 2.969.239.840 EP-9467451/CJYBrunei Rp 2.232.884.782 Dito Nugroho02 Jun 2021Gudang JayaTransaksi Makro
12
31 Des 2021Dito NugrohoEP-6863988/GMGMRBrunei Rp 777.081.365 BV-1308203/CJYSingapore Rp 2.160.266.259 Ika Suryani10 Jul 2021Gudang JayaTransaksi Makro
13
3Tentukan Asal Gudang pada kolom S berdasarkan Setlist di bawah ini04 Des 2022Ika SuryaniEP-4923930/GMGMRMalaysia Rp 2.319.825.031 JG-3258472/GSIndia Rp 2.808.410.874 Dito Nugroho30 Mei 2022Gudang SentosaTransaksi Makro
14
ID GudangNama Gudang16 Nov 2021Ika SuryaniEP-3241556/CJYHongkong Rp 727.668.430 BV-4983022/CJYMalaysia Rp 2.837.112.703 Ika Suryani22 Mar 2021Gudang JayaTransaksi Makro
15
GCHAGudang Cahaya28 Sep 2022Dito NugrohoJG-9287182/GHRPNIndia Rp 703.182.272 EP-9217870/GCHAHongkong Rp 175.084.782 Lina Dewi22 Jul 2021Gudang CahayaTransaksi Mikro
16
CJYGudang Jaya27 Apr 2021Siti RahayuJG-4612170/GCHAIndia Rp 112.642.599 BV-1754469/GMGMRIndia Rp 2.782.449.296 Lina Dewi05 Sep 2022Gudang MakmurTransaksi Makro
17
GHRPNGudang Harapan31 Jan 2021Lina DewiEP-1432989/CJYBrunei Rp 2.891.254.979 BV-4007775/CJYSingapore Rp 1.772.617.451 Adi Pratama31 Mar 2022Gudang JayaTransaksi Makro
18
GSGudang Sentosa15 Mar 2023Ika SuryaniEP-5867007/GMGMRBrunei Rp 2.617.008.179 JG-1319208/GCHASingapore Rp 802.125.625 Dito Nugroho01 Feb 2022Gudang CahayaTransaksi Menengah
19
GMGMRGudang Makmur10 Jan 2021Rini SetiawanJG-3285641/GSIndia Rp 1.788.513.315 JG-8718962/CJYMalaysia Rp 943.637.230 Rini Setiawan27 Mei 2023Gudang JayaTransaksi Menengah
20
14 Nov 2022Ika SuryaniEP-5299017/GHRPNIndia Rp 2.769.813.875 EP-6479439/GCHABrunei Rp 728.169.704 Ika Suryani06 Des 2021Gudang CahayaTransaksi Menengah
21
4Berdasarkan Total Nilai Barang, tentukan Jenis Transaksi sebagai berikut dengan menggunakan rumus VLOOKUP (tidak diperbolehkan menggunakan IF Bertingkat)26 Nov 2022Lina DewiJG-5476782/GSMalaysia Rp 441.098.124 JG-1981233/CJYBrunei Rp 2.229.210.452 Bagus Kurniawan19 Feb 2023Gudang JayaTransaksi Makro
22
07 Feb 2023Bagus KurniawanBV-3336320/GSIndia Rp 1.134.383.245 JG-7307011/GCHAIndia Rp 2.756.098.170 Rini Setiawan15 Apr 2023Gudang CahayaTransaksi Makro
23
Minimal NilaiJenis Transaksi04 Sep 2022Adi PratamaJG-1367856/GCHAHongkong Rp 649.635.357 EP-4800088/GSBrunei Rp 597.004.358 Dito Nugroho13 Nov 2022Gudang SentosaTransaksi Menengah
24
Rp0Transaksi Mikro09 Feb 2022Bagus KurniawanJG-4462280/GHRPNBrunei Rp 559.230.251 BV-6109444/GSHongkong Rp 2.109.206.166 Bagus Kurniawan25 Nov 2021Gudang SentosaTransaksi Makro
25
Rp500.000.000Transaksi Menengah20 Mei 2023Siti RahayuJG-4547964/GCHAIndia Rp 1.895.087.381 JG-1303811/GCHAMalaysia Rp 2.969.239.840 Bagus Kurniawan28 Des 2021Gudang CahayaTransaksi Makro
26
Rp1.500.000.000Transaksi Makro08 Sep 2022Siti RahayuJG-8137602/CJYMalaysia Rp 980.150.048 EP-6863988/GMGMRBrunei Rp 777.081.365 Dito Nugroho31 Des 2021Gudang MakmurTransaksi Menengah
27
16 Mar 2023Adi PratamaBV-9218394/GSBrunei Rp 1.041.451.827 EP-4923930/GMGMRMalaysia Rp 2.319.825.031 Ika Suryani04 Des 2022Gudang MakmurTransaksi Makro
28
5Berikan warna Hijau satu baris (tidak hanya satu kolom) untuk Total Nilai Barang minimal Rp1.000.000.000 pada area kolom N8 hingga T27
*warna hijaunya bebas, warna hijau tua atau muda diperbolehkan		21 Apr 2021Dito NugrohoBV-2824182/GHRPNIndia Rp 141.973.704
29
17 Jul 2021Siti RahayuEP-4950383/GSSingapore Rp 2.931.024.210
30
07 Nov 2021Rini SetiawanJG-5382423/GMGMRMalaysia Rp 1.054.952.743
31
21 Apr 2021Ika SuryaniJG-7483688/CJYMalaysia Rp 1.309.009.249
32
11 Jan 2022Rini SetiawanJG-8796328/CJYHongkong Rp 2.326.331.674
33
30 Jan 2023Rini SetiawanBV-8957092/GCHAHongkong Rp 1.882.843.912
34
13 Apr 2023Adi PratamaBV-9235402/GHRPNHongkong Rp 600.415.760
35
13 Jul 2022Lina DewiJG-6939041/GSHongkong Rp 1.074.805.520
36
28 Mei 2021Siti RahayuEP-4429924/CJYSingapore Rp 2.625.897.570
37
09 Jun 2021Rini SetiawanBV-9928803/GSMalaysia Rp 1.610.427.338
38
15 Agu 2022Dito NugrohoEP-6281801/GHRPNMalaysia Rp 800.666.467
39
25 Jul 2021Ika SuryaniEP-3815934/GHRPNMalaysia Rp 2.210.286.878
40
29 Des 2022Rini SetiawanJG-2432637/CJYHongkong Rp 1.583.644.623
41
21 Okt 2021Ika SuryaniBV-2912260/CJYBrunei Rp 1.523.162.756
42
27 Agu 2021Dito NugrohoJG-9105472/GHRPNIndia Rp 842.465.032
43
27 Jan 2023Adi PratamaEP-3920039/GHRPNSingapore Rp 282.062.017
44
02 Jun 2021Dito NugrohoEP-9467451/CJYBrunei Rp 2.232.884.782
45
10 Jul 2021Ika SuryaniBV-1308203/CJYSingapore Rp 2.160.266.259
46
30 Mei 2022Dito NugrohoJG-3258472/GSIndia Rp 2.808.410.874
47
22 Mar 2021Ika SuryaniBV-4983022/CJYMalaysia Rp 2.837.112.703
48
22 Jul 2021Lina DewiEP-9217870/GCHAHongkong Rp 175.084.782
49
10 Mar 2022Ika SuryaniJG-6546638/CJYIndia Rp 2.289.866.578
50
05 Okt 2022Adi PratamaEP-8939030/GSBrunei Rp 466.156.420
51
07 Apr 2023Siti RahayuEP-8767690/GSHongkong Rp 1.869.377.684
52
02 Jan 2021Bagus KurniawanBV-1044401/GMGMRMalaysia Rp 2.425.880.953
53
31 Mar 2023Siti RahayuBV-9057378/GCHABrunei Rp 2.911.345.820
54
22 Jan 2023Lina DewiEP-7704868/GSBrunei Rp 2.571.167.547
55
23 Feb 2023Dito NugrohoJG-1618460/GHRPNBrunei Rp 750.573.284
56
29 Jan 2021Bagus KurniawanEP-9656625/GSSingapore Rp 1.933.786.691
57
18 Mar 2021Rini SetiawanEP-4399882/GHRPNIndia Rp 2.536.897.073
58
14 Mar 2022Bagus KurniawanBV-9988454/GCHABrunei Rp 2.686.245.047
59
27 Agu 2022Bagus KurniawanBV-3975835/GSIndia Rp 572.739.422
60
12 Sep 2021Dito NugrohoEP-6111069/GHRPNSingapore Rp 2.257.157.499
61
21 Jun 2021Rini SetiawanBV-3878080/GMGMRIndia Rp 2.928.173.554
62
22 Sep 2022Siti RahayuBV-3470993/GMGMRSingapore Rp 1.994.512.551
63
05 Mei 2023Adi PratamaJG-6018918/GCHASingapore Rp 2.878.379.070
64
05 Jan 2021Lina DewiEP-5587511/CJYMalaysia Rp 876.926.515
65
01 Jan 2022Rini SetiawanJG-4959710/CJYHongkong Rp 660.774.842
66
01 Feb 2023Dito NugrohoJG-5354025/GMGMRBrunei Rp 1.561.545.965
67
12 Des 2021Dito NugrohoJG-2035199/GCHABrunei Rp 2.268.468.686
68
12 Jun 2021Siti RahayuBV-3030510/GMGMRIndia Rp 362.730.559
69
17 Nov 2021Lina DewiBV-3313319/GMGMRBrunei Rp 687.319.705
70
04 Mar 2023Ika SuryaniBV-7802305/GSBrunei Rp 1.940.036.865
71
19 Okt 2021Lina DewiEP-1866598/GSSingapore Rp 1.368.604.906
72
25 Des 2022Rini SetiawanEP-7798902/GMGMRIndia Rp 857.385.466
73
13 Sep 2022Lina DewiJG-5961003/GMGMRSingapore Rp 314.562.308
74
17 Feb 2023Dito NugrohoJG-3136027/CJYBrunei Rp 2.500.618.769
75
04 Feb 2023Dito NugrohoBV-1227670/GSMalaysia Rp 928.750.055
76
22 Feb 2021Lina DewiJG-6865952/GHRPNHongkong Rp 2.799.421.109
77
10 Sep 2022Adi PratamaEP-1300544/CJYHongkong Rp 461.750.428
78
14 Feb 2021Bagus KurniawanBV-3134381/CJYIndia Rp 252.842.284
79
13 Jun 2022Lina DewiJG-1992373/GSBrunei Rp 597.957.776
80
22 Jul 2022Bagus KurniawanBV-4410201/GHRPNSingapore Rp 180.691.705
81
29 Jul 2021Rini SetiawanBV-1505916/GSMalaysia Rp 400.021.205
82
20 Mei 2023Adi PratamaBV-7978401/GHRPNSingapore Rp 2.088.282.100
83
07 Sep 2021Lina DewiJG-2909785/GCHABrunei Rp 718.416.292
84
25 Sep 2021Bagus KurniawanEP-7672546/GHRPNBrunei Rp 2.733.311.499
85
06 Jun 2021Rini SetiawanJG-9023755/GMGMRIndia Rp 2.344.983.387
86
09 Sep 2022Dito NugrohoEP-8912624/CJYIndia Rp 1.736.629.910
87
04 Jan 2023Rini SetiawanBV-5897021/GHRPNHongkong Rp 1.829.406.764
88
11 Des 2022Lina DewiEP-4025563/GMGMRSingapore Rp 287.309.538
89
15 Okt 2021Siti RahayuEP-4790672/GCHAMalaysia Rp 520.395.908
90
05 Apr 2021Adi PratamaJG-5292294/GSMalaysia Rp 2.504.460.353
91
10 Mar 2021Siti RahayuBV-6615017/GHRPNSingapore Rp 1.147.844.206
92
21 Mar 2021Siti RahayuEP-9905643/GCHAIndia Rp 1.042.586.119
93
03 Jan 2021Dito NugrohoEP-4141194/GHRPNHongkong Rp 2.035.909.618
94
10 Jul 2021Adi PratamaBV-3651944/CJYHongkong Rp 2.003.306.200
95
28 Mar 2022Siti RahayuBV-4467310/GSMalaysia Rp 1.188.368.375
96
01 Feb 2023Dito NugrohoEP-3642955/GSMalaysia Rp 2.930.851.062
97
06 Apr 2021Siti RahayuEP-6950703/CJYMalaysia Rp 634.278.471
98
07 Mar 2023Bagus KurniawanBV-2706959/GHRPNHongkong Rp 272.476.901
99
18 Apr 2021Lina DewiEP-5233150/CJYMalaysia Rp 498.264.156
100
01 Jul 2021Dito NugrohoEP-8206679/GCHAMalaysia Rp 2.742.083.906