Pesawat Hercules jatuh di Medan, ikut berduka

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 – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

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

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

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

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Training Android di hotel bandung

Kegiatan mengajar Android mobile apps. Development di hotel malaka bandung

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

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

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

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

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

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

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

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

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

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

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Danau Maninjau sumbar

Selfi di danau maninjau sumbar, memanfaatkan jeda hari libur saat mengajar di semen padang sumbar

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Sunset at danau singkarak sumbar in ramadhan

Sambil menunggu berbuka puasa, menikmati indahnya sunset di danau singkarak bersama rekan rekan dari semen padang

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Penetapan Hari Libur besar dan libur bersama 2016

Menko PMK Puan Maharani didampingi Menag, Menteri PAN-RB, dan Menaker mengumumkan penetapan hari libur nasional dan cuti bersama 2016, di kantor Kementerian PMK

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

by http://inhousetrainer.net

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Inhouse Trainer di Bali, Bandung, Jakarta, Medan, Padang, Samarinda, Makasar

Hery Purnama 081.223344.506 ,Trainer  MS Project ,Excel VBA Macro, Dashboard PowerPivot , PowerView, Autocad Android, Phonegap, ITIL, COBIT, Google Map API, Sketchup3D , Autocad, Sencha ExtJS Oracle DBA, SQL Server DBA, MySQL DBA,ASP.Net, Laravel, MS Access VBA, Primavera P6, MS Project,PHP Jquery, Yii framework, CodeIgniter  : Call/SMS/WA : 081.223344.506 | PinBB : 7DC633AA | Email / YM : inhousetrainer@yahoo.com
Inhouse Training di Bandung Jakarta Bali Sumatera Kalimantan Sulawesi

Visit : http://inhousetrainer.net , http://freelance-it-trainer.blogspot.com

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Trainer di Bandung Jakarta Bali Sumatera Kalimantan Sulawesi

Hery Purnama 081.223344.506 ,Trainer  MS Project ,Excel VBA Macro, Dashboard PowerPivot , PowerView, Autocad Android, Phonegap, ITIL, COBIT, Google Map API, Sketchup3D , Autocad, Sencha ExtJS Oracle DBA, SQL Server DBA, MySQL DBA,ASP.Net, Laravel, MS Access VBA, Primavera P6, MS Project,PHP Jquery, Yii framework, CodeIgniter  : Call/SMS/WA : 081.223344.506 | PinBB : 7DC633AA | Email / YM : inhousetrainer@yahoo.com
Inhouse Training di Bandung Jakarta Bali Sumatera Kalimantan Sulawesi

Visit : http://inhousetrainer.net , http://freelance-it-trainer.blogspot.com

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Trip to puncak lawang sumatera barat

Berkunjung ke taman wisata puncak lawang sumatera barat bersama relasi dari PT. SEMEN PADANG , what a wonderfull place

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

IT Trainer, Freelance

Inhouse Trainer – Excel Macro, Android, ITIL, COBIT, Primavera, MS Project, Oracle, PM, ExtJS, etc

Hery Purnama 081.223344.506 – Freelance Trainer , Excel VBA Macro, Android, Phonegap, ITIL, COBIT, Google Map API, Sketchup3D , MS Project, Sencha ExtJS, Oracle DBA, SQL Server DBA, MySQL DBA, MS. Access VBA, Primavera P6, MS Project,Jquery, Yii, CodeIgniter. CIW, OCA, ITILF, TOGAF, Certified Trainer For Inquiry : Call/SMS/WA : 081.223344.506 | PinBB : 7DC633AA | Email / YM : inhousetrainer@yahoo.com | FB : inhousetrainer | TW : inhousetrainer
Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

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

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Dear Angeline di surga

Hi little angel ,malaikat kecil yang cantik apa kabarmu disana Sayang? Kakak yakin Kini kau telah bahagia bersamaNya, menari, menyanyi dan tertawa tanpa ada gundah dan perih lagi yang kau rasakan tak seperti saat kau masih menghiasi dunia yang fana ini, keluguan, kepolosan dan ceriamu seakan tak berarti di sekitar orang yang hatinya penuh kebencian dan keserakahan

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

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

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

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

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

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT