Seiring dengan kejadian jatuhnya pesawat Hercules TNI AU C130 di medan yang mengakibatkan jatuhnya korban jiwa di bulan suci ramadhan ini, maka perkenankan saya Hery Purnama mengucapkan Turut berduka cita dan mendoakan agar para korban jiwa diberi tempat yang terbaik di sisinya dan dihapuskan dosa dosanya, serta untuk keluarga yang ditinggalkan diberikan ketabahan dan keikhlasan. AMIN ya Allah.
Hery Purnama Trainer , Pengajar , Instruktur excel , vba , cobit , python , dmbok, babok, laravel, oracle, java, ms project, primavera big data di bandung , jakarta , surabaya , semarang , yogya , medan, lampung, makasar, indonesia | Visit www.inhousetrainer.net | WA 081-223344-506
Tuesday, June 30, 2015
Sunday, June 28, 2015
Training Ms. PROJECT di PT. DENKO ENGINEERING Bekasi
Inhouse training Project Management Methodology with MS. PROJECT di PT.DENKO bekasi
Semoga bermanfaat,
HERY PURNAMA
INHOUSE TRAINER
Training Android di PT. KRA Balikpapan
Inhouse training Mobile Apps. Development for Android di PT.KOMATSU REMANUFACTURING ASIA Balikpapan.
Semoga bermanfaat,
HERY PURNAMA
INHOUSE TRAINER
Training Android di hotel bandung
Makan malam di nelayan seafood restaurant medan
Jamuan Dinner penutupan kelas inhouse training MS Project di PT. DUNGO REKSA MEDAN , makan malam di nelayan seafood medan
Training autocad 2D/3D di angkasa pura
Inhouse training autocad 2D/3D di PT. Angkasa Pura II bandara soekarno hatta.
Semoga bermanfaat,
HERY PURNAMA
INHOUSE TRAINER
Training Excel VBA Macro batch 3 , KPUC Samarinda
Inhouse training excel vba macro at Kayan Putra Utama Coal Samarinda , batch 3.
Semoga bermanfaat,
HERY PURNAMA
INHOUSE TRAINER
Training MS Project at PT. HUTAMA KARYA
Inhouse training Project Management Methodology with MS Project at PT. HUTAMA KARYA Jakarta
Semoga bermanfaat
HERY PURNAMA
INHOUSE TRAINER
Training excel dashboard, with vba macro, powerpivot, powerview di PT semen padang
Batch 1, inhouse training excel dashboard with vba macro, power pivot, powerview at PT.Semen Padang SumBar
Semoga bermanfaat
Regards,
Hery Purnama
INHOUSE TRAINER
Sunset at danau singkarak sumbar in ramadhan
Sambil menunggu berbuka puasa, menikmati indahnya sunset di danau singkarak bersama rekan rekan dari semen padang
Penetapan Hari Libur besar dan libur bersama 2016
Berikut daftar 15 Hari libur nasional 2016:
1. 1 Januari Tahun Baru 2016 Masehi
2. 8 Februari Tahun Baru Imlek 2567 Kongzili
3. 9 Maret Hari Raya Nyepi Tahun Baru Saka 1938
4. 25 Maret Wafat Isa Al-Masih
5. 1 Mei Hari Buruh Internasional
6. 5 Mei Kenaikan Yesus Kristus
7. 6 Mei Isra Mi'raj Nabi Muhammad SAW
8. 22 Mei Hari Raya Waisak 2560
9. 6-7 Juli Hari Raya Idulfitri 1437 Hijriah
10. 17 Agustus Hari Kemerdekaan Republik Indonesia
11. 12 September Hari Raya Iduladha 1437 Hijriah
12. 2 Oktober Tahun Baru Islam 1438 Hijriah
13. 12 Desember Maulid Nabi Muhammad SAW
14. 25 Desember Hari Raya Natal
Hari cuti bersama 2016:
1. 4,5 dan 8 Juli Hari Raya Idulfitri 1437 Hijriah
2. 26 Desember Hari Raya Natal
Inhouse Trainer di Bali, Bandung, Jakarta, Medan, Padang, Samarinda, Makasar
Inhouse Training di Bandung Jakarta Bali Sumatera Kalimantan Sulawesi
Trainer di Bandung Jakarta Bali Sumatera Kalimantan Sulawesi
Inhouse Training di Bandung Jakarta Bali Sumatera Kalimantan Sulawesi
Friday, June 26, 2015
Trip to puncak lawang sumatera barat
Berkunjung ke taman wisata puncak lawang sumatera barat bersama relasi dari PT. SEMEN PADANG , what a wonderfull place
IT Trainer, Freelance
Inhouse Trainer - Excel Macro, Android, ITIL, COBIT, Primavera, MS Project, Oracle, PM, ExtJS, etc
Excel looking group interval or frequency (formula an VBA Macro)
Excel Formula to looking group of interval data | ||||
=IF(AND(IF(ISNUMBER(A1)=FALSE,0,A1)<=80,A2>80),-1,0) | ||||
Total minutes | Status dengan formula | Group | ||
85 | -1 | ==> | Group 1 | |
30 | 0 | |||
89 | -1 | ==> | Group 2 | |
89 | 0 | |||
80 | 0 | |||
30 | 0 | |||
89 | -1 | ==> | Group 3 | |
89 | 0 | |||
30 | 0 | |||
60 | 0 | |||
89 | -1 | ==> | Group 4 | |
99 | 0 | |||
89 | 0 | |||
86 | 0 | |||
80 | 0 | |||
60 | 0 | |||
89 | -1 | ==> | Group 5 | |
81 | 0 | |||
60 | 0 | |||
89 | -1 | ==> | Group 6 | |
81 | 0 | |||
There are six (6) group of data interval which has value > 80 |
I'm creating vba function as well to looking the Group Frequency in Excel
Function cariinterval(sel1 As String, sel2 As Single) As Single
Dim vsel1 As Single
If IsNumeric(sel1) = False Then
vsel1 = 0
Else
vsel1 = sel1
End If
If vsel1 <= 80 And sel2 > 80 Then
cariinterval = -1
Else
cariinterval = 0
End If
End Function
Sunday, June 21, 2015
Dear Angeline di surga
Kepergianmu angel bukan tiada arti sayang, Tuhan pasti sangat menyayangimu hingga kau dipanggil lebih cepat dari kami semua dan sepertinya Tuhan ingin senyum dan ceria tawamu menghiasi surganya, disanalah tempat terbaikmu, istana yang indah yang akan menghibur dan menjagamu selamanya, kami semua mendoakanmu selalu malaikat kecil yang cantik. Tak ada keraguan di hati bahwa Surga adalah tempatmu kini angel
Salam,
kak Hery - bandung
Wednesday, June 17, 2015
Trainer excel dashboard, powerpivot , powerview
HERY PURNAMA 081223344506 , freelance inhouse trainer excel 2013 dashboard, powerpivot, powerview, powerquery, power BI , business intelegence
Http://inhousetrainer.net
Hery Purnama
Excel expert
Excel vba Macro Dashboard training
Terima kasih kepada PT. KAYAN PUTRA UTAMA COAL samarinda atas undangan mengajar excel vba macro batch 3 ,semoga bermanfaat.
Hery Purnama
Freelance Trainer
http://inhousetrainer.net
081223344506
Monday, June 15, 2015
Training excel dashboard with macro, pivot table, pivot chart and powerpivot
HERY PURNAMA 081223344506, inhouse trainer for training excel advanced dashboard with macro, pivot table, pivot chart and powerpivot
Excel advanced dashboard trainer for location bandung, jakarta, semarang, surabaya, bali, makasar, maluku, menado, samarinda, balikpapan, medan, palembang and any other cities in indonesia.
Optimizing your excel skill level to.increase your productivity by learning excel dashboard with macro, pivot table , pivot chart and powerpivot
For inquiry please contact :
Hery Purnama
Phone/WA/SMS : 081223344506
PinBB : 7DC633AA
Info@inhousetrainer.net
Http://inhousetrainer.net
Http://freelance-it-trainer.blogspot.com
Thursday, June 11, 2015
Training excel advanced pivot table and powerpivot di bandung
Trainer Freelance untuk training excel pivot and powerpivot , Hery Purnama 081223344506 , info@inhousetrainer.net
Topik lain : excel vba macro , excel dashboard, excel pivot and power pivot, ms project, primavera, autocad, itil 2011, cobit 5, togaf, sqa, php zend, yii, codeigniter, sencha extjs, android development, java, ms.access, oracle dba, mysql dba, sqlserver dba, asp/vb.net , jquery ajax, cms wordpress, drupal, joomla, google sketchup 3d, google map api v.3, RDBMS database concept, SEO internet marketing, google develope web toolkit, html 5, corel for advertisement, photoshop, 3D maya, Swishmax, flash, adobe indesign, fireworks, jquery mobile, phonegap , etc. just call hery purnama 081223344506 , pin bb 7dc633aa
For trainer inquiry at any city in indonesia : jakarta, bandung, semarang, yogya, surabaya, bali, lombok, papua, maluku, sulawesi, makasar, balikpapan, kalimantan, medan, batam please contact hery purnama certified trainer on 081223344506, http://inhousetrainer.net
Training google sketchup 3d di jakarta
Trainer Freelance untuk training google sketchup 3d , Hery Purnama 081223344506 , info@inhousetrainer.net
Topik lain : excel vba macro , ms project, primavera, autocad, itil 2011, cobit 5, togaf, sqa, php zend, yii, codeigniter, sencha extjs, android development, java, ms.access, oracle dba, mysql dba, sqlserver dba, asp/vb.net , jquery ajax, cms wordpress, drupal, joomla, google sketchup 3d, google map api v.3, RDBMS database concept, SEO internet marketing, google develope web toolkit, html 5, corel for advertisement, photoshop, 3D maya, Swishmax, flash, adobe indesign, fireworks, jquery mobile, phonegap , etc. just call hery purnama 081223344506 , pin bb 7dc633aa
For trainer inquiry at any city in indonesia : jakarta, bandung, semarang, yogya, surabaya, bali, lombok, papua, maluku, sulawesi, makasar, balikpapan, kalimantan, medan, batam please contact hery purnama certified trainer on 081223344506, http://inhousetrainer.net
Training Autocad 2D and 3D modeling di sciencom
semoga manfaat
Salam,
Hery Purnama
Freelance IT Trainer
http://inhousetrainer.net
http://freelance-it-trainer.blogspot.com
081.223344.506
info@inhousetrainer.net
Training PHP Mysql di edutrain jakarta
Terima Kasih kepada peserta dari ACS , atas partisipasinya dalam kegitan training PHP mysql di Edutrain Jakarta , semoga bermanfaat
SALAM,
HERY PURNAMA
081223344506
Sunday, June 7, 2015
Training MS Project di PT.Dungo Reksa Medan
Terima kasih kepada PT. Dungo Reksa medan atas undangan mengajar Project Management Methodelogy with MS Project selama 3 hari, semoga bermanfaat.
Supported by SISINDOTEK.com, IT Training and Solution Provider Bandung,
By Hery Purnama
Inhouse IT Trainer
081223344506