Freelance Certified IT Trainer Bandung

Freelance IT Trainer, Pengajar Komputer, Inhouse Trainer, Management Trainer , Hery Purnama

Hery Purnama 081.223344.506 , Trainer Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer, Inhouse Training Certified IT Trainer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun sebagai IT Trainer & IT Consultant

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, RDBMS Concept, PHP , Ajax JQUERY, Yii Framework, Code Igniter, PHP SMS Gateway, Photoshop, CorelDraw, UML, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

Training Topics :

  • Google Application Integration Toolbox  for web developer
    Building Integrated Map Website with PHP MySQL and Google Map API V.3
    Web Integration with Facebook API developer toolbox
    Web Development with CMS WordPress
    Web Development with PHP Yii Framework
    Web Development with PHP CodeIgniter
    Project Management Methodologies  With Microsoft Project 2010
    SEO and Internet Marketing
    RDBMS – Database Concept
    ITIL V.3 Foundation
    Building Database Application with Microsoft Access 2010
    Microsoft Access 2010 VBA Macro programming
    MYSQL Server DBA Fundamental
    Object Manipulation with Adobe Photoshop CS
    CorelDraw X6 for Marketing and Promotion
    Google Sketchup 3D for Building Interior
    Building Flash Animation with SWISHMAX
    Building PHP MySQL – AJAX Web Application with Adobe Dreamweaver CS
    Building  ASP.Net Application with IronSpeed Designer
    Building PHP MySQL Web Application with CodeCharge Studio
    Mobile Application Development for Android with Jquery Mobile, MySQL & Phonegap
    HTML 5 for Mobile Application Development
    Microsoft Office 2010 (WORD, EXCEL, POWERPOINT)
    Microsoft Excel Visual Basic for Application (VBA-Macro)
    Networking Essential
    Installing, Configuring and Administering Windows Server 2008
    Installing, Configuring and Administering UBUNTU
    Installing and Configuring Exchange Server 2008
    CISCO Router
    Application Programming with VB.NET
    Web and Application programming with ASP.NET
    Web and Application programming with PHP – MYSQL
    Building Rich Internet Application  with PHP and Sencha ExtJs
    Building web application with PHP MySQL & AJAX Jquery
    Building Event Scheduler System with PHP AJAX and SMS Gateway
    Computer for Secretary and Admin Staff (Networking  Essential, MS. Outlook, Document Security and sharing, MS. Office Integration, File Archive and data backup – Recovery, etc.)
    Kerio Winroute Firewall
    SQL Server 2008 Database Design & DBA Fundamental

My Clients:

  • PT. Sampoerna Tbk – Bandung
  • PT. Asuransi AXA Indonesia – Jakarta
  • Icon Plus (Icon PLN – jakarta)
  • Bank Ekonomi – Jakarta
  • PT PLN (Persero) PUSHARLIS UWP III
  • PT. Karenindo Citra Utama – Jakarta
  • ITENAS – Bandung
  • Universitas Bina Nusantara (BINUS – Jakarta)
  • Bank Jabar Banten (BJB)
  • AMDOCS – Jakarta
  • PT. Elnusa, Tbk.
  • PT. Sarana Multigriya Finansial / SMF (Persero)
  • PT. Pertamina Geothermal Energy (Thamrin – Jakarta)
  • PT. Indonesia Asahan Alumunium (INALUM- Medan)
  • UIN SUSKA – Riau
  • Rumah Sakit AWALBROS Bekasi
  • Universitas Andalas
  • Politeknik ACEH
  • Pusinfowas BPKP – Jakarta
  • Asuransi Takaful – Jakarta
  • PT. Freeport , Tbk – Tembagapura Papua
  • PT. Gerbang Sinergi Prima – Bandung
  • PT PLN (PERSERO) UIP TRANSMISI ISJ – jakarta
  • PT. CG Power System Indonesia – Bogor
  • PT. Pertamina (Persero) – Jakarta
  • Bank CIMB Niaga –  Jakarta
  • Ikatan Mahasiswa Teknik Metalurgi ITB – Bandung
  • PT. Pupuk Kijang – Cikampek
  • PT. Pertamina (Persero – Jakarta)
  • Bakrie Telecom Jakarta
  • SMKN 2 Garut
  • PT BES Kelapa Gading Jakarta
  • PT. Telkomsel – Jakarta
  • PT. Hutama Karya Persero (Bandung)
  • PT. Seascape Survey Indonesia
  • PT. Pupuk Kaltim
  • Dana Pensiun Pupuk Kaltim
  • PT. Sarinah (Persero)
  • PT. Weda Bay Nickel (Halmahera)
  • Taq-Taq Operating Company Ltd (Kurdhistan – Irak)
  • EMP MALACCA STRAIT SA – Jakarta
  • Bank BTPN Jakarta
  • PT. Sarana Multi Infrastruktur (Persero)
  • PT. Medco Energi – Jakarta
  • PT. ANTAM, Tbk.
  • Unversitas Islam Indonesia (Teknik Informatika)
  • Institut Teknologi Telkom Bandung
  • Politeknik Negeri Malang
  • PT. KPEI
  • DPPKAD Kabupaten Gresik
  • PT PJB UPHB
  • PT. Krakatau Steel


    Building Integrated Map Website with PHP MySQL and Google Map API V.3
    (Inhouse ICON PLN Jakarta)
    icon PLN inhouse sisindotek
    Inhouse Training ini membahas tentang bagaimana membuat peta digital interaktif dan dinamis dengan informasi yang koordinat / LatLong yang tersimpan di database lalu ditampilkan secara dinamis menggunakan Google MAP API V.3 , beberapa metode yang dipelajari seperti Single Marker, Multiple Marker, Polyline, Geofence, Geocode, Direction, Single Marker, Multiple marker Custom Marker , Polyline dan lainnya.
     
    Microsoft Excel Advance for Business, Accounting & Management (Bank BJB – 4 Angkatan)
    Bank BJB inhouse sisindotek
    Kegiatan inhouse training dengan Bank BJB sebanyak 4 angkatan dengan total peserta 26 orang membahas pemanfaat excel dengan tingkatan yang lebih tinggi berupa pemanfaatn formula, function baik yang sudah umum ataupun yang tidak umum untuk membuat kemudahaan dalam pengelolaan data buat kebutuhan bisnis, Akuntansi ataupun manajemen.
     
    Building Event Scheduller Application with PHP and SMS Gateway (PLN)
    Training ini kembali diikuti oleh klien exclusive group dari PT PLN (PERSERO) UIP TRANSMISI ISJ, training ini membahas cara
    membuat aplikasi Event Scheduller dengan PHP, MySQL dan SMS gateway sebagai notification systemnya
     
    Mobile Application development for Android using Jquery Mobile and Phonegap (Bakrie Telecom)
    Inhouse Training membahas pemanfaat framework JQM dan phonegap dipadukan dengan PHP Ajax untuk membuat aplikasi berbasis Android dengan mudah
     
    Project Management Methodologies with MS Project (Inhouse Training INALUM Medan)
    Inhouse Training Project Management with MS. Project bersama staff dari PT. Indonesia Asahan Alumunium (INALUM) , Training membahas konsep Project Management dan implementasinya ke dalam software MS. Project 2010, termasuk dalam pembahasan adalah Project Management Lifecycle, Cost, Budget dan metodologi seperti PERT, CPM, PDM dan juga Earned Value Concept (SV, CV, CPI, SPI, BCWS, BCWP, ACWP dll.
     
    Excel VBA Macro (Inhouse training PGE Indonesia)
    Training Excel VBA Macro Programming bersama staff dari PT. Pertamina Geothermal Energy – Jakarta, Training ini membahas pemograman
    di Excel untuk melakukan otomatisasi dan pengembangan kinerja excel untuk memenuhi kebutuhan yang lebih kompleks
     
    ITIL v3 Foundation (Exclusive Group)
    Training ITIL v.3 Foundation yang diselenggarakan di Hotel Bintang 4 (DeJava Hotel , PVJ Bandung) diikuti oleh 3 peserta dari staff PUSINFOWAS BPKP jakarta
    Training ini bertujuan memahami konsep dari pengelolaan IT berbasis layanan (IT Service Management) berdasarkan framework IT Infrastructure Library (ITIL) versi 3. Beserta tambahan skenario studi kasusnya dan implementasi menggunakan ITSM software simulation serta simulasi persiapan ujian ITIL
     
    Excel VBA Macro (Exclusive Group)
    Training Microsoft Excel Visual Basic for Application (VBA – Macro) bersama 7 peserta dari PT. Freeport , Tbk (Exclusive Group) yang terbagi atas 3 gelombang / Periode
    Training ini membahas Pengenalan dan pemanfaatan Macro dan pemograman VBA untuk menyempurnakan dan memaksimalkan penggunaan Microsoft Excel lebih diatas penggunaan standard pada umumnya. pengenalan objek Excel dan VBA memanipulasi objek, penggunaan control , active x , array, looping , membuat function merupakan beberapa materi yang diberikan dalam pelatihan ini. Dikarenakan paket exclusive group maka training ini juga khusus membahas kasus khusus PT Freeport untuk diterapkan di bagian planner PT Freeport sesuai kebutuhan pekerjaan.
     
    Building Integrated Map Website with PHP MySQL & Google MAP API V.3
    Training Building Integrated Map Website with PHP and Google Map API V.3 diikuti oleh peserta Exclusive Group dari PT PLN (PERSERO) UIP TRANSMISI ISJ
    Training ini membahas tentang bagaimana membuat peta digital interaktif dan dinamis dengan informasi yang koordinat / LatLong yang tersimpan di database lalu ditampilkan secara dinamis menggunakan Google MAP API V.3 , beberapa metode yang dipelajari seperti Single Marker, Multiple Marker, Polyline, Geofence, Geocode, Direction, Custom Marker dan lainnya.
     
    Inhouse Training Microsoft Excel VBA Macro
    Inhouse Training Microsoft Excel Visual Basic for Application (VBA – Macro) bersama 15 peserta dari Ikatan Mahasiswa Teknik Metalurgi ITB Bandung
    Training ini membahas Pengenalan dan pemanfaatan Macro dan pemograman VBA untuk menyempurnakan dan memaksimalkan penggunaan Microsoft Excel lebih diatas penggunaan standard pada umumnya. pengenalan objek Excel dan VBA memanipulasi objek, penggunaan control , active x , array, looping , membuat function merupakan beberapa materi yang diberikan dalam pelatihan ini.
     
    Exclusive Group Training Project Management Methodologies with MS. Project 2010 PT.ANTAM

    Pelatihan Project Management Methodologies with MS. Project 2010 bersama 6 peserta Exclusive Group dari PT. ANTAM, Tbk. (Aneka Tambang) Sulawesi Tenggara
    Training ini membahas konsep Project Management beserta metodologi yang diimplementasikan menggunakan MS. Project , pembahasan teori berupa Konsep CPM, PDM, Earned Value (BCWS, SV, CV, SPI dll) Juga dibahas untuk memberi bekal mendalam perihal Project Management.
    disertai pembahasan studi kasus
    Kurva S
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

Android JQuery Mobile , Introduction

 JQueryMobile (JQM)

(Mengenal Jquery Mobile Framework )

jQuery Mobile is built on top of the jQuery library, which makes it easy to learn if you already know jQuery.

It uses HTML5, CSS3, JavaScript and AJAX to accomplish its work for laying out pages with minimal scripting.
Why Use jQuery Mobile?

jQuery Mobile takes the “write less, do more” to a new level: It automatically design web pages with an attractive and “easy-to-use” look, that will work the same way on all mobile devices.

Note     Instead of writing one application for each mobile device or OS:

    Android and Blackberry is written in Java

    iOS is written in Objective C

    Windows Phone is written in C# and .net, etc.

jQuery Mobile solves this problem, as it only uses HTML, CSS and JavaScript, which is standard for all mobile web browsers!

Best Reading Experience

Even though jQuery Mobile works on all mobile devices, it may have some compatibility issues on desktop computers (due to limited CSS3 support).

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, Prevent Case Sensitive with Ucase function

Ucase Function

 (Menangani case sensitif dengan function Ucase Excel VBA)

The Ucase function can compare text in a range of cells, allowing us to write a macro that compares text case-insensitively.

Here is one that displays a message box if it encounters any cell in A1:A10 of the active sheet containing any case variation of the word CAT.

The code.
To insert the code, press Alt/Option-F11, select Insert → Module, and paste the following:

Sub CompareText( )
Dim rCell As Range

    For Each rCell In Range(“A1:A10”)
    If UCase(rCell) = “CAT” Then
        MsgBox rCell.Address & ” has ” & rCell & ” in it”
    End If
    Next rCell
End Sub

Exit the VBE and return to Excel and save your workbook.

To run the macro, select Developer → Macros (pre-2007, Tools → Macro → Macros…), select CompareText from the list, and click Run. So if you had the word CAT (uppercase) in cells A1:A9 and the word cat (lowercase) in A10, the macro would display a message box for each instance of the word “cat,” regardless of what case it is entered in.

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 , Variable Tutorial

Variables in Excel VBA

(Mengenal dan menggunakan Variable di Excel VBA)

Integer    |   String    |   Double    |   Boolean

This tutorial teaches you how to declare, initialize and display a variable in Excel VBA. Letting Excel VBA know you are using a variable is called declaring a variable. Initializing simply means assigning a beginning (initial) value to a variable.

Place a command button on your worksheet and add the code lines below. To execute the code lines, click the command button on the sheet.

Integer

Integer variables are used to store whole numbers.
Dim x As Integer
x = 6
Range(“A1”).Value = x

Explanation: the first code line declares a variable with name x of type Integer. Next, we initialize x with value 6. Finally, we write the value of x to cell A1.

String

String variables are used to store text.

Code:
Dim book As String
book = “bible”
Range(“A1”).Value = book

Explanation: the first code line declares a variable with name book of type String. Next, we initialize book with the text bible. Always use apostrophes to initialize String variables. Finally, we write the text of the variable book to cell A1.

Double

A variable of type Double is more accurate than a variable of type Integer and can also store numbers after the comma.

Code:
Dim x As Integer
x = 5.5
MsgBox “value is ” & x

Result is Not Accurate Enough

But that is not the right value! We initialized the variable with value 5.5 and we get the value 6. What we need is a variable of type Double.

Code:
Dim x As Double
x = 5.5
MsgBox “value is ” & x

Note: Long variables have even larger capacity. Always use variables of the right type. As a result, errors are easier to find and your code will run faster.

Boolean

Use a Boolean variable to hold the value True or False.

Code:
Dim continue As Boolean
continue = True

If continue = True Then MsgBox “Boolean variables are cool”

Explanation: the first code line declares a variable with name continue of type Boolean. Next, we initialize continue with the value True. Finally, we use the Boolean variable to only display a MsgBox if the variable holds the value True.

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 , Range Object, Cells, Rows, Columns, Copy , count Tutorial

Range Object Refferences

(Mengenal Object Range di Excel VBA Macro)

Range Examples | Cells | Declare a Range Object | Select | Rows | Columns | Copy/Paste | Clear | Count
The Range object, which is the representation of a cell (or cells) on your worksheet, is the most important object of Excel VBA. This chapter gives an overview of the properties and methods of the Range object. Properties are something which an object has (they describe the object), while methods do something (they perform an action with an object).
Range Examples

Place a command button on your worksheet and add the following code line:
Range(“B3”).Value = 2

Excel VBA Range Example

Code:
Range(“A1:A4”).Value = 5

Range Example

Code:
Range(“A1:A2,B3:C4”).Value = 10

Cells

Instead of Range, you can also use Cells. Using Cells is particularly useful when you want to loop through ranges.

Code:
Cells(3, 2).Value = 2

Cells in Excel VBA

Explanation: Excel VBA enters the value 2 into the cell at the intersection of row 3 and column 2.

Code:
Range(Cells(1, 1), Cells(4, 1)).Value = 5

Declare a Range Object

You can declare a Range object by using the keywords Dim and Set.

Code:
Dim example As Range
Set example = Range(“A1:C4”)

example.Value = 8

Select

An important method of the Range object is the Select method. The Select method simply selects a range.

Code:
Dim example As Range
Set example = Range(“A1:C4”)

example.Select

Rows

The Rows property gives access to a specific row of a range.

Code:
Dim example As Range
Set example = Range(“A1:C4”)

example.Rows(3).Select

Columns

The Columns property gives access to a specific column of a range.

Code:
Dim example As Range
Set example = Range(“A1:C4”)

example.Columns(2).Select

Copy/Paste

The Copy and Paste method are used to copy a range and to paste it somewhere else on the worksheet.

Code:
Range(“A1:A2”).Select
Selection.Copy

Range(“C3”).Select
ActiveSheet.Paste

Although this is allowed in Excel VBA, it is much better to use the code line below which does exactly the same.
Range(“C3:C4”).Value = Range(“A1:A2”).Value
 

Clear

To clear the content of an Excel range, you can use the ClearContents method.
Range(“A1”).ClearContents

or simply use:
Range(“A1”).Value = “”

Note: use the Clear method to clear the content and format of a range. Use the ClearFormats method to clear the format only.

Count

With the Count property, you can count the number of cells, rows and columns of a range.

Count Property

Note: border for illustration only.

Code:
Dim example As Range
Set example = Range(“A1:C4”)

MsgBox example.Count

Count Cells

Code:
Dim example As Range
Set example = Range(“A1:C4”)

MsgBox example.Rows.Count

Count Rows

Note: in a similar way, you can count the number of columns of a range.

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 , Loop Tutorial

Excel VBA Macro Tutorial , How to use Loop


Single Loop    |   Double Loop    |   Triple Loop    |   Do While Loop

Looping is one of the most powerful programming techniques. A loop in Excel VBA enables you to loop through a range of cells with just a few codes lines.
Single Loop

You can use a single loop to loop through a one-dimensional range of cells.

Place a command button on your worksheet and add the following code lines:

Dim i As Integer

For i = 1 To 6
    Cells(i, 1).Value = 100
Next i

Single Loop in Excel VBA

Explanation: The code lines between For and Next will be executed six times. For i = 1, Excel VBA enters the value 100 into the cell at the intersection of row 1 and column 1. When Excel VBA reaches Next i, it increases i with 1 and jumps back to the For statement. For i = 2, Excel VBA enters the value 100 into the cell at the intersection of row 2 and column 1, etc.

Note: it is good practice to always indent (tab) the code between the words For and Next. This makes your code easier to read.
Double Loop

You can use a double loop to loop through a two-dimensional range of cells.

Place a command button on your worksheet and add the following code lines:
Dim i As Integer, j As Integer

For i = 1 To 6
    For j = 1 To 2
        Cells(i, j).Value = 100
    Next j
Next i

Double Loop in Excel VBA

Explanation: For i = 1 and j = 1, Excel VBA enters the value 100 into the cell at the intersection of row 1 and column 1. When Excel VBA reaches Next j, it increases j with 1 and jumps back to the For j statement. For i = 1 and j = 2, Excel VBA enters the value 100 into the cell at the intersection of row 1 and column 2. Next, Excel VBA ignores Next j because j only runs from 1 to 2. When Excel VBA reaches Next i, it increases i with 1 and jumps back to the For i statement. For i = 2 and j = 1, Excel VBA enters the value 100 into the cell at the intersection of row 2 and column 1, etc.
Triple Loop

You can use a triple loop to loop through two-dimensional ranges on multiple Excel worksheets.

Place a command button on your worksheet and add the following code lines:
Dim c As Integer, i As Integer, j As Integer

For c = 1 To 3
    For i = 1 To 6
        For j = 1 To 2
            Worksheets(c).Cells(i, j).Value = 100
        Next j
    Next i
Next c

Explanation: The only change made compared to the code for the double loop is that we have added one more loop and added Worksheets(c). in front of Cells to get the two-dimensional range on the first sheet for c = 1, the second sheet for c = 2 and the third sheet for c = 3. Download the Excel file to see this result.
Advertisement
Do While Loop

Besides the For Next loop, there are other loops in Excel VBA. For example, the Do While Loop. Code placed between Do While and Loop will be repeated as long as the part after Do While is true.

1. Place a command button on your worksheet and add the following code lines:
Dim i As Integer
i = 1

Do While i < 6
    Cells(i, 1).Value = 20
    i = i + 1
Loop

Do While Loop

Explanation: as long as i is lower than 6, Excel VBA enters the value 20 into the cell at the intersection of row i and column 1 and increments i by 1. In Excel VBA (and in other programming languages), the symbol ‘=’ means becomes. It does not mean equal. So i = i + 1 means i becomes i + 1. In other words: take the present value of i and add 1 to it. For example, if i = 1, i becomes 1 + 1 = 2. As a result, the value 20 will be placed into column A five times (not six because Excel VBA stops when i equals 6).

2. Enter some numbers in column A.

3. Place a command button on your worksheet and add the following code lines:
Dim i As Integer
i = 1

Do While Cells(i, 1).Value <> “”
    Cells(i, 2).Value = Cells(i, 1).Value + 10
    i = i + 1
Loop

Advanced Do While Loop

Explanation: as long as Cells(i, 1).Value is not empty (<> means not equal to), Excel VBA enters the value into the cell at the intersection of row i and column 2, that is 10 higher than the value in the cell at the intersection of row i and column 1. Excel VBA stops when i equals 7 because Cells(7, 1).Value is empty. This is a great way to loop through any number of rows on a worksheet.

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, Tutorial Create Function and Sub

Create Function and Sub

The difference between a function and a sub in Excel VBA is that a function can return a value while a sub cannot. Functions and subs become very useful as program size increases.
Function

If you want Excel VBA to perform a task that returns a result, you can use a function. Place a function into a module (In the Visual Basic Editor, click Insert, Module). For example, the function with name Area.

Function Area(x As Double, y As Double) As Double
Area = x * y

End Function

Explanation: This function has two arguments (of type Double) and a return type (the part after As also of type Double). You can use the name of the function (Area) in your code to indicate which result you want to return (here x * y).

You can now refer to this function (in other words call the function) from somewhere else in your code by simply using the name of the function and giving a value for each argument.

Place a command button on your worksheet and add the following code lines:

Dim z As Double

z = Area(3, 5) + 2

MsgBox z

Explanation: The function returns a value so you have to ‘catch’ this value in your code. You can use another variable (z) for this. Next, you can add another value to this variable (if you want). Finally, display the value using a MsgBox.

Result when you click the command button on the sheet:

Sub

If you want Excel VBA to perform some actions, you can use a sub. Place a sub into a module (In the Visual Basic Editor, click Insert, Module). For example, the sub with name Area.

Sub Area(x As Double, y As Double)

MsgBox x * y

End Sub

Explanation: This sub has two arguments (of type Double). It does not have a return type! You can refer to this sub (call the sub) from somewhere else in your code by simply using the name of the sub and giving a value for each argument.

Place a command button on your worksheet and add the following code line:

Area 3, 5

Result when you click the command button on the sheet:

Can you see the difference between the function and the sub? The function returned the value 15. We added the value 2 to this result and displayed the final result. When we called the sub we had no more control over the result (15) because a sub cannot return a value!

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, Using Date and Time, DateAdd

Tutorial Excel VBA belajar menggunakan Date and Time

Melalui module di VBE ketik script berikut

Code:

Deklarasi variable Date dengan Dim
Dim exampleDate As Date 



‘Variable diisi dengan function untuk mengambil nilai dari data tgl
exampleDate = DateValue(“Jun 19, 2010”)

‘Test dengan melihat hasilnya di Msgbox
MsgBox Year(exampleDate)

Note: Gunakan Month dan Day untuk ambil nilai bulan dan hrii

DateAdd

Digunakan untuk mendapatkan perpanjangan hari dari tanggal yang ditentukan

Code:
‘deklarasi variable
Dim firstDate As Date, secondDate As Date‘Isi variable
firstDate = DateValue(“Jun 19, 2010”)
secondDate = DateAdd(“d”, 3, firstDate)
‘test dengan msgbox
MsgBox secondDate

Note: Ganti d” ke  “m” untuk perpanjangan bulan dari tanggal ditentukan

current date and time, gunakan Now function.

Code:
MsgBox Now

Current Date Time
Hour, Minute, Second

Mendapatkan Jam(Hour), Gunakan Hour function.

Code:
MsgBox Hour(Now)

Time value untuk convert string ke Jam

Code:

MsgBox TimeValue(“9:20:01 am”)

TimeValue

Dim y As Double
y = TimeValue(“09:20:01”)
MsgBox y

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

Freelance IT Trainer, Pengajar Komputer, Inhouse Trainer, Management Trainer , Hery Purnama

Hery Purnama 081.223344.506 , Trainer Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer, Inhouse Training Certified IT Trainer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, RDBMS Concept, PHP , Ajax JQUERY, Yii Framework, Code Igniter, PHP SMS Gateway, Photoshop, CorelDraw, UML, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

Topics

  • Google Application Integration Toolbox  for web developer
    Building Integrated Map Website with PHP MySQL and Google Map API V.3
    Web Integration with Facebook API developer toolbox
    Web Development with CMS WordPress
    Web Development with PHP Yii Framework
    Web Development with PHP CodeIgniter
    Project Management Methodologies  With Microsoft Project 2010
    SEO and Internet Marketing
    RDBMS – Database Concept
    ITIL V.3 Foundation
    Building Database Application with Microsoft Access 2010
    Microsoft Access 2010 VBA Macro programming
    MYSQL Server DBA Fundamental
    Object Manipulation with Adobe Photoshop CS
    CorelDraw X6 for Marketing and Promotion
    Google Sketchup 3D for Building Interior
    Building Flash Animation with SWISHMAX
    Building PHP MySQL – AJAX Web Application with Adobe Dreamweaver CS
    Building  ASP.Net Application with IronSpeed Designer
    Building PHP MySQL Web Application with CodeCharge Studio
    Mobile Application Development for Android with Jquery Mobile, MySQL & Phonegap
    HTML 5 for Mobile Application Development
    Microsoft Office 2010 (WORD, EXCEL, POWERPOINT)
    Microsoft Excel Visual Basic for Application (VBA-Macro)
    Networking Essential
    Installing, Configuring and Administering Windows Server 2008
    Installing, Configuring and Administering UBUNTU
    Installing and Configuring Exchange Server 2008
    CISCO Router
    Application Programming with VB.NET
    Web and Application programming with ASP.NET
    Web and Application programming with PHP – MYSQL
    Building Rich Internet Application  with PHP and Sencha ExtJs
    Building web application with PHP MySQL & AJAX Jquery
    Building Event Scheduler System with PHP AJAX and SMS Gateway
    Computer for Secretary and Admin Staff (Networking  Essential, MS. Outlook, Document Security and sharing, MS. Office Integration, File Archive and data backup – Recovery, etc.)
    Kerio Winroute Firewall
    SQL Server 2008 Database Design & DBA Fundamental

My Clients:

  • PT. Sampoerna Tbk – Bandung
  • PT. Asuransi AXA Indonesia – Jakarta
  • Icon Plus (Icon PLN – jakarta)
  • Bank Ekonomi – Jakarta
  • PT PLN (Persero) PUSHARLIS UWP III
  • PT. Karenindo Citra Utama – Jakarta
  • ITENAS – Bandung
  • Universitas Bina Nusantara (BINUS – Jakarta)
  • Bank Jabar Banten (BJB)
  • AMDOCS – Jakarta
  • PT. Elnusa, Tbk.
  • PT. Sarana Multigriya Finansial / SMF (Persero)
  • PT. Pertamina Geothermal Energy (Thamrin – Jakarta)
  • PT. Indonesia Asahan Alumunium (INALUM- Medan)
  • UIN SUSKA – Riau
  • Rumah Sakit AWALBROS Bekasi
  • Universitas Andalas
  • Politeknik ACEH
  • Pusinfowas BPKP – Jakarta
  • Asuransi Takaful – Jakarta
  • PT. Freeport , Tbk – Tembagapura Papua
  • PT. Gerbang Sinergi Prima – Bandung
  • PT PLN (PERSERO) UIP TRANSMISI ISJ – jakarta
  • PT. CG Power System Indonesia – Bogor
  • PT. Pertamina (Persero) – Jakarta
  • Bank CIMB Niaga –  Jakarta
  • Ikatan Mahasiswa Teknik Metalurgi ITB – Bandung
  • PT. Pupuk Kijang – Cikampek
  • PT. Pertamina (Persero – Jakarta)
  • Bakrie Telecom Jakarta
  • SMKN 2 Garut
  • PT BES Kelapa Gading Jakarta
  • PT. Telkomsel – Jakarta
  • PT. Hutama Karya Persero (Bandung)
  • PT. Seascape Survey Indonesia
  • PT. Pupuk Kaltim
  • Dana Pensiun Pupuk Kaltim
  • PT. Sarinah (Persero)
  • PT. Weda Bay Nickel (Halmahera)
  • Taq-Taq Operating Company Ltd (Kurdhistan – Irak)
  • EMP MALACCA STRAIT SA – Jakarta
  • Bank BTPN Jakarta
  • PT. Sarana Multi Infrastruktur (Persero)
  • PT. Medco Energi – Jakarta
  • PT. ANTAM, Tbk.
  • Unversitas Islam Indonesia (Teknik Informatika)
  • Institut Teknologi Telkom Bandung
  • Politeknik Negeri Malang
  • PT. KPEI
  • DPPKAD Kabupaten Gresik
  • PT PJB UPHB
  • PT. Krakatau Steel


    Building Integrated Map Website with PHP MySQL and Google Map API V.3
    (Inhouse ICON PLN Jakarta)
    icon PLN inhouse sisindotek
    Inhouse Training ini membahas tentang bagaimana membuat peta digital interaktif dan dinamis dengan informasi yang koordinat / LatLong yang tersimpan di database lalu ditampilkan secara dinamis menggunakan Google MAP API V.3 , beberapa metode yang dipelajari seperti Single Marker, Multiple Marker, Polyline, Geofence, Geocode, Direction, Single Marker, Multiple marker Custom Marker , Polyline dan lainnya.
     
    Microsoft Excel Advance for Business, Accounting & Management (Bank BJB – 4 Angkatan)
    Bank BJB inhouse sisindotek
    Kegiatan inhouse training dengan Bank BJB sebanyak 4 angkatan dengan total peserta 26 orang membahas pemanfaat excel dengan tingkatan yang lebih tinggi berupa pemanfaatn formula, function baik yang sudah umum ataupun yang tidak umum untuk membuat kemudahaan dalam pengelolaan data buat kebutuhan bisnis, Akuntansi ataupun manajemen.
     
    Building Event Scheduller Application with PHP and SMS Gateway (PLN)
    Training ini kembali diikuti oleh klien exclusive group dari PT PLN (PERSERO) UIP TRANSMISI ISJ, training ini membahas cara
    membuat aplikasi Event Scheduller dengan PHP, MySQL dan SMS gateway sebagai notification systemnya
     
    Mobile Application development for Android using Jquery Mobile and Phonegap (Bakrie Telecom)
    Inhouse Training membahas pemanfaat framework JQM dan phonegap dipadukan dengan PHP Ajax untuk membuat aplikasi berbasis Android dengan mudah
     
    Project Management Methodologies with MS Project (Inhouse Training INALUM Medan)
    Inhouse Training Project Management with MS. Project bersama staff dari PT. Indonesia Asahan Alumunium (INALUM) , Training membahas konsep Project Management dan implementasinya ke dalam software MS. Project 2010, termasuk dalam pembahasan adalah Project Management Lifecycle, Cost, Budget dan metodologi seperti PERT, CPM, PDM dan juga Earned Value Concept (SV, CV, CPI, SPI, BCWS, BCWP, ACWP dll.
     
    Excel VBA Macro (Inhouse training PGE Indonesia)
    Training Excel VBA Macro Programming bersama staff dari PT. Pertamina Geothermal Energy – Jakarta, Training ini membahas pemograman
    di Excel untuk melakukan otomatisasi dan pengembangan kinerja excel untuk memenuhi kebutuhan yang lebih kompleks
     
    ITIL v3 Foundation (Exclusive Group)
    Training ITIL v.3 Foundation yang diselenggarakan di Hotel Bintang 4 (DeJava Hotel , PVJ Bandung) diikuti oleh 3 peserta dari staff PUSINFOWAS BPKP jakarta
    Training ini bertujuan memahami konsep dari pengelolaan IT berbasis layanan (IT Service Management) berdasarkan framework IT Infrastructure Library (ITIL) versi 3. Beserta tambahan skenario studi kasusnya dan implementasi menggunakan ITSM software simulation serta simulasi persiapan ujian ITIL
     
    Excel VBA Macro (Exclusive Group)
    Training Microsoft Excel Visual Basic for Application (VBA – Macro) bersama 7 peserta dari PT. Freeport , Tbk (Exclusive Group) yang terbagi atas 3 gelombang / Periode
    Training ini membahas Pengenalan dan pemanfaatan Macro dan pemograman VBA untuk menyempurnakan dan memaksimalkan penggunaan Microsoft Excel lebih diatas penggunaan standard pada umumnya. pengenalan objek Excel dan VBA memanipulasi objek, penggunaan control , active x , array, looping , membuat function merupakan beberapa materi yang diberikan dalam pelatihan ini. Dikarenakan paket exclusive group maka training ini juga khusus membahas kasus khusus PT Freeport untuk diterapkan di bagian planner PT Freeport sesuai kebutuhan pekerjaan.
     
    Building Integrated Map Website with PHP MySQL & Google MAP API V.3
    Training Building Integrated Map Website with PHP and Google Map API V.3 diikuti oleh peserta Exclusive Group dari PT PLN (PERSERO) UIP TRANSMISI ISJ
    Training ini membahas tentang bagaimana membuat peta digital interaktif dan dinamis dengan informasi yang koordinat / LatLong yang tersimpan di database lalu ditampilkan secara dinamis menggunakan Google MAP API V.3 , beberapa metode yang dipelajari seperti Single Marker, Multiple Marker, Polyline, Geofence, Geocode, Direction, Custom Marker dan lainnya.
     
    Inhouse Training Microsoft Excel VBA Macro
    Inhouse Training Microsoft Excel Visual Basic for Application (VBA – Macro) bersama 15 peserta dari Ikatan Mahasiswa Teknik Metalurgi ITB Bandung
    Training ini membahas Pengenalan dan pemanfaatan Macro dan pemograman VBA untuk menyempurnakan dan memaksimalkan penggunaan Microsoft Excel lebih diatas penggunaan standard pada umumnya. pengenalan objek Excel dan VBA memanipulasi objek, penggunaan control , active x , array, looping , membuat function merupakan beberapa materi yang diberikan dalam pelatihan ini.
     
    Exclusive Group Training Project Management Methodologies with MS. Project 2010 PT.ANTAM

    Pelatihan Project Management Methodologies with MS. Project 2010 bersama 6 peserta Exclusive Group dari PT. ANTAM, Tbk. (Aneka Tambang) Sulawesi Tenggara
    Training ini membahas konsep Project Management beserta metodologi yang diimplementasikan menggunakan MS. Project , pembahasan teori berupa Konsep CPM, PDM, Earned Value (BCWS, SV, CV, SPI dll) Juga dibahas untuk memberi bekal mendalam perihal Project Management.
    disertai pembahasan studi kasus
    Kurva S
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

Info Trainer, Pengajar Lepas SMS Gateway

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, RDBMS Concept, PHP , Ajax JQUERY, Yii Framework, Code Igniter, PHP SMS Gateway, Photoshop, CorelDraw, UML, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

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 , Pengajar PHP AJAX JQuery

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, RDBMS Concept, PHP , Ajax JQUERY, Yii Framework, Code Igniter, Photoshop, CorelDraw, UML, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

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, Pengajar Lepas Sencha ExtJS

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

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

Freelance IT Trainer , Pengajar RDBMS Database Concept

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, RDBMS Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

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

Freelance Trainer, Pengajar SQL Server DBA

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

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

Freelance Trainer, Pengajar Google Sktechup 3D

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

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

Freelance Trainer, Pengajar Oracle

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

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

Freelance Trainer , Pengajar MS Access

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

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

Freelance Trainer , Pengajar Google Map API

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

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 , Pengajar MS Project / Manajemen Proyek

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

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, Pengajar Komputer ITIL foundation

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

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