hlookvlookup
DESCRIPTION
a very easy to learn tutorial about how to do or create an excel document using hlookup or vlookup formula. This simple way will make sure you have an excellent quality of document. It's not free, so you have to purchase it. Give me money man!TRANSCRIPT
DAFTAR GAJI KARYAWAN HORIZONTALPT. JARVIS
No Nama Karyawan Gol GAJI POKOK TUNJANGAN1 Muhammad Fakhrial IIIA 1000000 3000002 Nokvan Setyo Dwi Yahya IIIB 1200000 4000003 Dhimas Kafiyatillah Arroyan IIIA 1000000 3000004 Rafi Al-Mutawakil IIIC 1400000 5000005 Pratama Iqbal Firmansyah IIA 700000 2000006 Refangga Lalang Raynalfi IIIA 1000000 3000007 Irfan Riza Putra IIIB 1200000 4000008 Ibnu Rizky Ratnanta IIA 700000 2000009 Hakim Subekti IIIB 1200000 400000
10 Baharuddin Ilmi IIIA 1000000 300000
DAFTAR GAJI KARYAWAN VERTIKALPT. JARVIS
No Nama Karyawan Gol GAJI POKOK TUNJANGAN1 Muhammad Fakhrial IIIA 1000000 3000002 Nokvan Setyo Dwi Yahya IIIB 1200000 4000003 Dhimas Kafiyatillah Arroyan IIIA 1000000 3000004 Rafi Al-Mutawakil IIIC 1400000 5000005 Pratama Iqbal Firmansyah IIA 700000 2000006 Refangga Lalang Raynalfi IIIA 1000000 3000007 Irfan Riza Putra IIIB 1200000 4000008 Ibnu Rizky Ratnanta IIA 700000 2000009 Hakim Subekti IIIB 1200000 400000
10 Baharuddin Ilmi IIIA 1000000 300000
Gaji Bersih TABEL GAJI KARYAWAN HORIZONTAL1300000 GOL IIA IIIA IIIB IIIC1600000 GAJI 700000 1000000 1200000 14000001300000 TUNJ 200000 300000 400000 5000001900000
900000 TABEL GAJI KARYAWAN VERTIKAL1300000 GOL GAJI TUNJANGAN1600000 IIA 700000 200000
900000 IIIA 1000000 3000001600000 IIIB 1200000 4000001300000 IIC 1400000 500000
Nama : Febryan Asa PerdanaKelas : X MIA C / 11
Gaji Bersih1300000160000013000001900000
90000013000001600000
90000016000001300000