latihan excel

2
REKAPITULASI GAJI CV KERJA SIANG No Bagian Gaji Pokok Tunjangan 1 Fitry Editing 1 ### Rp 100,000.00 2 Iska Editing 1 ### Rp 100,000.00 3 Trisno Setter 2 ### Rp 200,000.00 4 Ary Kabag 3 ### Rp 400,000.00 5 Gatik Marketing 5 ### Rp 400,000.00 6 Puji Admin 3 ### Rp 400,000.00 7 Santi Setter 2 ### Rp 200,000.00 8 Nita Setter 5 ### Rp 400,000.00 9 Handa Setter 4 ### Rp 400,000.00 10 Erni Setter 4 ### Rp 400,000.00 11 Nina Setter 2 ### Rp 200,000.00 12 Zuni Setter 2 ### Rp 200,000.00 Nama Karyawan Masa kerja

Upload: haripurnomo

Post on 09-Nov-2015

4 views

Category:

Documents


1 download

DESCRIPTION

contoh latihan excel untuk dipelajari

TRANSCRIPT

premi tanda tanyaREKAPITULASI GAJI KARYAWANCV KERJA SIANG MALAMNoNama KaryawanBagianMasa kerjaGaji PokokTunjanganLemburAbsenPremiTotal GajiJamRp1FitryEditing1Rp1,500,000.00Rp100,000.0024Rp120,000.000Rp100,000.00Rp1,820,000.002IskaEditing1Rp1,500,000.00Rp100,000.0036Rp180,000.000Rp100,000.00Rp1,880,000.003TrisnoSetter2Rp1,250,000.00Rp200,000.0056Rp280,000.000Rp100,000.00Rp1,830,000.004AryKabag3Rp2,500,000.00Rp400,000.002Rp10,000.000Rp100,000.00Rp3,010,000.005GatikMarketing5Rp2,500,000.00Rp400,000.002Rp10,000.000Rp100,000.00Rp3,010,000.006PujiAdmin3Rp1,750,000.00Rp400,000.0035Rp175,000.000Rp100,000.00Rp2,425,000.007SantiSetter2Rp1,250,000.00Rp200,000.0056Rp280,000.000Rp100,000.00Rp1,830,000.008NitaSetter5Rp1,250,000.00Rp400,000.002Rp10,000.003Rp100,000.00Rp1,760,000.009HandaSetter4Rp1,250,000.00Rp400,000.009Rp45,000.002Rp100,000.00Rp1,795,000.0010ErniSetter4Rp1,250,000.00Rp400,000.0060Rp300,000.000Rp100,000.00Rp2,050,000.0011NinaSetter2Rp1,250,000.00Rp200,000.0020Rp100,000.000Rp100,000.00Rp1,650,000.0012ZuniSetter2Rp1,250,000.00Rp200,000.0056Rp280,000.001Rp100,000.00Rp1,830,000.00