Excel PowerView Trainer Jakarta, Bandung, Bogor, Makasar, Medan, Balikpapan, Banjarmasin, Indonesia

Hery Purnama, 081223344506, Trainer for training Excel 2013 powerPivot and PowerView.

Membangun dashboard analisis dengan tampilan yang menarik serta sistem permodelan data dari beberapa sumber dapat terselesaikan dengan memanfaatkan fitur Excel PowerPivot dan PowerView.

Untuk undangan mengajar topik tersebut hubungi

HERY PURNAMA
MCDBA, CPMP, PMP, ITILF, CISA

Tel/WA : 081-223344-506
PinBB : 7DC633AA
www.inhousetrainer.net
http://freelance-it-trainer.blogspot.com
inhousetrainer@yahoo.com

Freelance IT Trainer :
EXCEL VBA MACRO, ITIL, COBIT, PRINCE2, TOGAF, PMBOK, PMO, ITPM, AUTOCAD, CATIA 3D, GOOGLE SKETCHUP, ORACLE, SQL SERVER, MYSQL DBA, MS.ACCESS, PHP, JQUERY, SENCHA EXTJS, ANDROID STUDIO, PHONEGAP/CORDOVA, ANGULARJS, SMS GATEWAY, GOOGLE MAP API,  ASP/VB.NET, CODEIGNITER, YII, ZEND, LARAVEL, MAGENTO, SEO, JAVA, MS. PROJECT, PRIMAVERA P6, EXCEL POWERPIVOT/ POWERVIEW, etc.

Hometown : Bandung Jawa Barat

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