PT. HM. SAMPOERNA, Tbk. - Pasuruan Jawa Timur

INHOUSE TRAINING VBA MACRO PROGRAMMING

PT. PLN PERSERO MALUKU / MALUKU UTARA

INHOUSE TRAINING I.S GOVERNANCE

O-Shop, SCTV, Infotech (Jakarta)

PUBLIC TRAINING MAGENTO ADVANCED

PT. ASKRINDO - JAKARTA

PUBLIC TRAINING PMP PMBOK EXAM PREPARATION

Bank Fama International - Bandung

INHOUSE TRAINING CYBERSECURITY AWARENESS PROGRAM

Tuesday, June 30, 2015

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.

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

Kegiatan mengajar Android mobile apps. Development di hotel malaka 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

Danau Maninjau sumbar

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

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

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

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

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

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

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

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

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

Terima kasih kepada 15 peserta PT Angkasa Pura II Bandara Soeta bekerjasama dengan sciencom dengan topik inhouse Autcad 2d/3D
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