DISKON MERDEKA ATAU CASHBACK Rp 730.000

Dapatkan Diskon Training Hut RI ke 73 sebesar Rp 730 ribu di Purnama Academy - Semua Topik !

PUBLIC TRAINING - PURNAMA ACADEMY

Kami Bekerjasama dengan hotel bintang di 4 kota Bandung-Jakarta-Bali-Cikarang untuk memberikan kenyamanan peserta public training

REQUEST FOR INHOUSE TRAINING

Inhouse Training adalah pilihan paling tepat untuk jumlah peserta perusahaan yang banyak dengan mengutamakan efisiensi biaya training.

PORTFOLIO : INHOUSE TRAINING ANDROID - PLN MALUKU

Inhouse Training Android Application Development di PT. PLN Wilayah Maluku selama 4 hari

PORTFOLIO : INHOUSE TRAINING MAGENTO - INFOTECH JAKARTA

Inhouse Training Magento E-Commerce berdurasi 7 hari dibagi 2 sesi Fundamental dan Advanced.

Friday, April 27, 2018

TRAINING MYSQL FOR DATABASE ADMINISTRATORS





Syllabus MySQL For Database Administrators


Class Type : Training
Duration  : 5 Days (09.00 – 16.00)

Training Description :


Pelatihan MySQL for Database Administrator ini adalah program pondasi bagi para DBA mysql. Training mengajarkan para administrator database  dan pengembang cara menggunakan basis data yang powerfull ini, selain itu juga peserta megetahui tugas tugas seorang DBA secara mendetail.

Prerequisites :


- Telah menggunakan MySQL secara aktif

Topic Includes  :


Introduction
Describing MySQL
Listing MySQL Products and Professional Services
Describing MySQL Enterprise Subscription Currently
Supported Operating Systems
Describing MySQL Certification Program
Listing Available MySQL Courses
Describing Installation of MySQL
Describing Installation of world Database

MySQL Architecture Client/Server Architecture
MySQL Architecture
Overview How MySQL Uses Disk Space
How MySQL Uses Memory
The MySQL Plug-In Interface

The MySQL Server
Types of MySQL Distributions
Starting and Stopping MySQL on Windows Starting and Stopping MySQL on Linux Upgrading MySQL
Managing Multiple Servers

Configuring the MySQL Server
MySQL Configuration Dynamic Server Variables Server SQL Modes
Log and Status Files Binary Logging

MySQL Clients
Overview of Administrative Clients
Invoking MySQL Client Programs Using the mysql Client
The mysqladmin Client
MySQL Connectors Third-Party APIs


Overview of Data Types
Data Types
Numeric Data Types Character
String Data Types
Binary String Data Types
Temporal Data Types NULLs
Column Attributes

Metadata
Metadata Access Methods
The INFORMATION_SCHEMA Database/Schema Using SHOW and DESCRIBE
The mysqlshow Command

Storage Engines
Storage Engine Overview
MyISAM, InnoDB, and MEMORY Storage Engines Other Storage Engines
Choosing Appropriate Storage Engines Using Multiple Storage Engines Storage Engine Comparison Chart

Partitioning
Overview of Partitioning and reasons for using Partitioning Creating a Partitioned Table
Obtaining Partition Information Modifying and Removing Partitions
Partition Modification Performance Effects Partition Pruning
Storage Engine Partition Information Partitioning and Locking and Limitations

Transactions and Locking
Transactions
Transaction Control statements Isolation Levels
Locking

Security and User Management
Security Risks Security Measures Privileges
Access Levels, including: 1 - User Accounts, 2 – Databases, 3 – Tables, 4 – Columns, 5 - Stored Routines User Account Maintenance
Client Access Control Using Secure Connections

Table Maintenance
Table Maintenance
SQL Statements for maintenance operations Client and Utility Programs for table maintenance

Table Maintenance per Storage Engine

Exporting and Importing Data
Exporting and Importing Data
Exporting and Importing Data Using SQL Import Data with the SQL scripts

Programming with MySQL
Defining, Executing and Examining Stored Routines Stored Routines and Execution Security
Defining, Creating, and Deleting Triggers Trigger Restrictions and Privileges Defining Events
Schedule Events
DBA's Use of MySQL Programming Backup Stored Routines

Views
What is a view? Creating Views Updatable Views Managing Views

Backup and Recovery Planning for Recovery Backup Backup Tools Overview Making Raw Backups
Making Logical (Text) Backups Backup Log and Status Files Replication as an Aid to Backup Backup Method Comparison Data Recovery

Introduction to Performance Tuning Using EXPLAIN to Analyze Queries General Table Optimizations
Setting and Interpreting MySQL Server Variables

Introduction to High Availability
MySQL Replication



Training MySQL Fundamental 1


Syllabus MySQL Fundamental 1



Class Type : Training
Duration  : 4 Days (09.00 – 16.00)

Training Description :


Pelatihan MySQL Fundamental adalah langkah pertama dalam menguasai MySQL, sebuah database open source paling populer di dunia. melalui training ini pemahaman Anda akan mysql akan semakin kuat dan juga kemampuan Anda mempraktikan penggunaan basis data relasional, bahasa SQL, dan MySQL Server erta tool kelengkapan penunjang akan semaki lebih baik

Prerequisites :

-          Pengetahuan dasar tentang database

Introduction to MySQL
MySQL Overview
What is MySQL Cloud Service
What it means to provision a MySQL Cloud Service instance
How an instance of MySQL Cloud Service differs from having an on-premises instance
How MySQL course content covers material that applies whether you run MySQL locally or in MySQL Cloud Service

MySQL Server and Client MySQL Client/Server Model MySQL Connectors
Installation of the MySQL server Setting the root Password
Starting and stopping the MySQL server Using the mysql client
MySQL Workbench

Database Basics
Basics of Relational Databases Spreadsheet Versus Database Entities and Relationships
Relationship Categories
SQL Language and MySQL SQL data definition language
SQL data manipulation language

Designing Your Database
Database Modeling Keys
Normalization Database Design
Viewing and Evaluating a Database

Data Types
Data Types as Part of Database Design Numeric Data Types
Temporal Data Types String Data Types
Character Set and Collation Support Data Type Considerations
The Meaning of NULL

Creating Databases and Tables
Creating a Database Creating a Table
Showing How a Table Was Created Column Options
Table Options
Indexes, Keys, and Constraints

Modifying Databases and Tables
Deleting databases and tables
Creating a New Table Using an Existing Table
Confirming the Creation of a New Table

Copying an Existing Table Structure
Creating a Temporary Table
Adding, removing and modifying table columns
Adding, removing and modifying Indexes

Querying Table Data
The SELECT Statement
Creating Views
Querying Data from an Application
Exporting and Importing a Delimited
File Troubleshooting: Authorization Levels

Modifying Table Data
Manipulating Data Inserting records
Replacing existing records
Updating existing records
Deleting records
Exporting and importing a script
Multistatement Transactions
Modifying Data from an Application

Functions
Functions in MySQL Expressions Using Functions
String Functions
Date and time functions
Numeric Functions
Aggregate Functions
Spaces in Function Names

Joining Tables
Querying Multiple Tables Joining Tables with SELECT Inner Joins
Outer Joins
Table Name Aliases


TRAINING MYSQL CLUSTER

MySQL Cluster


Syllabus


Class Type : Training
Duration : 5 Days (09.00 – 16.00)

Training Description :

Setelah mengambil kursus ini, Anda akan dapat melakukan evaluasi pemanfaatan MySQL Cluster dalam aplikasi Anda, dan merancang topologi cluster yang aman untuk  tujuan skalabilitas dan ketersediaan yang culup tinggi. Anda juga akan memiliki skill pengetahuan  untuk memantau dan mengoptimalkan kinerja kluster yang ada dan memecahkan masalah masalah yang muncul. Anda juga dapat mereplikasi antara kluster yang dipisahkan oleh fungsi atau letak geografis.

Prerequisites :
- Pengetahuan tentang perintah perintah dasar Linux/Unix
- Pengetahuan tentang konsep database
- Pengetahuan tentang Jaringan Komputer
- Telah menggunakan MySQL

Topic Includes  :

Introduction to MySQL Cluster 
MySQL Overview, Products,
Services Websites and Other Documentation Key Benefits and Use Cases
Node types

Installing MySQL Cluster
Hardware, Software, and Network Requirements Choosing and Installing Cluster Distributions Installing and Configuring Cluster Nodes  MySQL Cluster Auto-Installer
Starting a Cluster with a Basic Configuration Upgrading a Cluster

MySQL Cluster Architecture 
The NDB storage engine Clustered tables
SQL and NoSQL API nodes Data Nodes and Node Groups Partitions and Replicas Checkpoints and the Redo Log Redundancy and Resilience

Configuring MySQL Cluster
MySQL Cluster Configuration Files
Basic Configuration Options: NodeId and HostName Management Node Configuration
Data Node Configuration
Configuring Multi-Threaded Data Nodes Cluster Program Startup Options
Viewing Cluster Configuration Information

Designing a MySQL Cluster
Design Guidelines Sizing Memory Usage
In-Memory and Disk Data Storage Configuring Disk Data Storage
Designing Clusters for Scale and High Availability Cluster Configuration Examples

Maintaining a MySQL Cluster
Modifying Table Structure
Accessing the Cluster with Command-Line Tools Single-User Mode
Backing Up a Cluster
Restoring a Cluster from Backup

Securing MySQL Cluster 
Securing MySQL Cluster
Configuring Connection Security
Configuring Firewall Rules Data Security
MySQL Server Node Security

MySQL Cluster Manager
Installing MySQL Cluster Manager Agent and Clients
Sites, Clusters, Hosts, Processes, Packages, and Configuration Attributes Creating Managed Clusters
Importing a Configuration from an Unmanaged Cluster Viewing Information About Your Sites and Clusters Maintaining Your Sites and Clusters

Replicating Between MySQL Clusters 
Replication in MySQL Cluster Transaction Ordering and Epochs Configuring Replication
Starting, Stopping, and Resetting Replication Backups Using Replication Tables Replication Resilience
Replication Information Repositories
Multi-Master Replication and Conflict Resolution

Monitoring MySQL Cluster 
Introduction to Monitoring Monitoring with the ndb_mgm Client Using the Cluster Log
ndbinfo Database Status Variables
MySQL Enterprise Monitor

Troubleshooting MySQL Cluster Problems
Starting to Troubleshoot Heartbeats Configuration Problems Disk Activity Problems
Application Design Problems

Optimizing MySQL Cluster Performance
Performance Concepts
Identifying Queries for Optimization Optimizing with Indexes
Using EXPLAIN
Adaptive Query Localization Distribution Awareness
The Process of Optimizing and Benchmarking

MySQL Cluster Environments
MySQL Cluster and Virtualization
Node Deployment in Cloud Environments Connecting to a Cluster with SQL and NoSQL APIs
Comparing MySQL Cluster with Other High-Availability Solutions


#mysqlculstertraining #pelatihandatabase #mysql #clusterdatabase #trainingjakarta #bandung #bali

Sunday, April 22, 2018

PUBLIC TRAINING ANDROID APPLICATIONS DEVELOPMENT WITH PHONEGAP AND JQUERY MOBILE DI BANDUNG




Kegiatan PUBLIC TRAINING ANDROID APPLICATIONS DEVELOPMENT WITH PHONEGAP AND JQUERY MOBILE yang berlangsung di hotel Malaka - Jl. Halimun 36 BANDUNG diiukti oleh 2 peserta dari PT. Kayan Putra Utama Coal (KPUC) Samarinda Kalimantan Timur, dimana materi yang diberikan kepada peserta fokus pada penggunaan Javascript Framework Phonegap dan dibantu juga dengan Jquery Mobile serta Ajax Jquery dalam mengembangkan aplikasi mobile untuk Android. Adapun materi yang diberikan meliputi


  • Building your first jQuery Mobile app
  • Understanding the page architecture
  • Using page transitions and dialog widgets
  • Working with forms and controls
  • Creating toolbars
  • Working with list views
  • Using jQuery Mobile's content formatting features
  • Adding events to detect and respond to changes
  • Configuring and customizing jQuery Mobile
  • Phonegap Desktop Installation
  • Phonegap Build
  • HTML 5 key features
  • HTML 5 local storage
  • Connecting to MySQL Database with JSONP Ajax Jquery
  • Generate Android Sign Key
  • How to upload into google playstore
Demikian dan semoga memberikan manfaat buat para tim developer dari KPUC Samarinda




INHOUSE TRAINING SQL SERVER DBA AND ASP.NET FUNDAMENTAL DI PT. GANSA TECHNO - BANDUNG



Kegiatan INHOUSE TRAINING SQL SERVER DBA AND ASP.NET FUNDAMENTAL DI PT. GANSA TECHNO  yang berlokasi di Kopo BANDUNG , training berlangsung selama 3 hari dan diikuti oleh 10 staff dan manajemen dari beberapa unit / cabang yang ada di indonesia. Training ini berfokus pengenalan kegiatan  Database Administration di SQL Server dan mengenal pembuatan aplikasi berbasis web dengan ASP.net

Besar harapan agar training SQL SERVER DBA AND ASP.NET FUNDAMENTAL DI PT. GANSA TECHNO dapat memberikan pemahaman dan wawasan lebih luas kepada peserta terkait teknologi database SQL Server dan ASP.Net  yang saat ini sudah ada di dalam perusahaan.

INHOUSE TRAINING LIBREOFFICE CALC DI BANK FAMA INTERNASIONAL - BANDUNG



Kegiatan INHOUSE TRAINING LIBRE OFFICE CALC DI BANK FAMA INTERNASIONAL - BANDUNG berlangsung selama 3 hari dan diikuti oleh 25 peserta lintas unit dari Jakarta dan Bandung. Open Office Calc adalah salah satu aplikasi opensource yang merupakan bagian dari Software Open Office Libre, aplikasi ini merupakan aplikasi yang serupa dengan spreedsheet MS. Excel di produk Microsoft Office dan saat ini sudah menjadi alternatif bagi perusahaan yang sedang mengimplementasikan teknologi Open Source di perusahaannya dengan tujuan kemanan dan efisiensi. Fitur fitur yang ada di dalam libreoffice calc buatan Apache ini tidak kalah canggihnya dengan yang tersedia di MS. Excel fasilitas fasilitas pendukung tingkat lanjut seperti Pivot Table dan Macro pun tersedia. beberapa nilai plus juga bisa didapatkan dalam hal formating dan ketersedian beberapa function yang saat ini bahkan belum tersedia di Microsoft Excel .

Adapun materi Libre Office Calc yang diberikan kepada peserta dari Bank Fama anatara lain :


3.1 Styles
3.2 Printing with Calc
3.2.1 Printing a spreadsheet
3.2.2 Selecting sheets to print
3.2.3 Adjusting the print range
3.2.4 Page breaks
3.2.5 Headers and footers
3.3 Formula and functions
3.3.1 About formulas
3.3.2 Simple functions (SUM, AVERAGE, MIN, MAX, COUNT, WHEN)
3.3.3 Statistical functions
3.3.4 Time and date functions
3.3.5 Text functions
3.3.6 Math functions
3.3.7 Logical functions
3.3.8 Information functions
3.3.9 Advanced spreadsheet functions
3.3.10 Standard errors
3.4 Sorting data
3.4.1 Using spreadsheet as database
3.4.2 Ascending or descending order
3.4.3 Advanced sorting options
3.5 Filtering data
3.5.1 Using autofilter
3.5.2 Setting up manual filter
3.5.3 Advanced filters
3.5.4 Defining filters
3.6 Creating charts
3.6.1 Using the AutoFormat Chart dialog
3.6.2 Chart types
3.6.3 Appearance of a chart
3.6.4 Modifying the data area of a chart
3.6.5 Changing line colors
3.6.6 Modifying axes scales
3.7 Solver
3.7.1 Using Solver
3.7.2 Groups and goals
3.8 Goal seek
3.9 Scenarios
3.10 Error Detective
3.11. Linking data
3.11.1 Why use multiple sheets?
3.11.2 Referencing other sheets
3.11.3 Referencing other Calc documents
3.11.4 Referencing to external data sources
3.11.5 Relative, mixed, absolute references
3.12 Validity
3.13 Subtotals
3.14 Grouping and schema

Besar harapan melalui training LibreOffice Calc ini manajemen Bank Fama dapat mencapai target yang diharapkan dalam mengadopsi dan mengimplementasikan teknologi  open source Bank Fama secara menyeluruh


INHOUSE TRAINING EXCEL VBA MACRO DI PT. TUGU PRATAMA INDONESIA - JAKARTA




PT. TUGU PRATAMA INDONESIA beralamat di Wisma Tugu I, Jl. H.R. Rasuna Said, Kav C 8-9,  Karet, Jakarta Selatan, DKI Jakarta,  12920 , perusahaan ini bergerak di bidang Asuransi spesifik dalam kegiatan investasi pertambangan. Kegiatan inhouse yang bekerjasama dengan PT. Tugu Pratama Indonesia terkait topik Microsoft Excel VBA Macro dan berlangsung selama 3 hari diikuti oleh 17 peserta dari lintas departemen, dimana fokus materi yang ditargetkan adalah membuat file file kerja excel semakin otomatis terutama dalam kegiatan data manajemen

Adapun materi inhouse training Excel VBA Macro yang diberikan di PT. Tugu Pratama Indonesia Jakarta antara lain mencakup :

I. Persiapan
Developer Ribbon
Macro Security
Macro Enabled Workbook (.xlsm)

II. Recording Macro
Record Macro
Manage Macro
Relative References
Edit Macro

III. VBE, Module & Procedures
Mengakses VBE
Module
Procedures

IV. Object & Addressing
Object Addressing

V. Property Format
Format menggunakan .Address

VI. With … End With
Penggunaan With.. End With

VII. Formula R1C1
Penggunaan R1C1

VIII. Variable
Fase Variable
Local Variable
Public Variable
Constant Variable
Object Variable

IX. Inputbox
Penggunaan Inputbox

X. Conditional If
Penggunaan Conditional IF
UCASE/LCASE  Function

XI. User Defined Function (UDF)
Pembuatan UDF

XII. Msgbox
Penggunaan Msgbox

XIII. Anatomi Script & Project Password
Anatomi script
Project Password

XIV. Subrutin & Error Handling
Penggunaan SUBRUTIN
Penggunaan ERROR HANDLING

XV. Array & Looping
Jenis Array
Jenis Looping
For .. Next
Do... Loop
isEmpty function

XVI. Object Form & Control
Form
Toolbox
Lable
Textbox
Enabled = False
ComboBox
Command Button
TabIndex Property
Text Property
Event & Private Sub

XVII. Run Macro from Excel
Menambahkan Control Button Form di Sheet


Demikian dan semoga pelatihan Excel VBA Macro di PT Tugu Pratama Indonesia ini bisa memberikan manfaat terutama pencapaian terhadap target otomatisasi dalam hal kinerja file file excel.

INHOUSE TRAINING ANDROID APPLICATIONS DEVELOPMENT WITH PHONEGAP AND JQUERY MOBILE DI PT. KOMATSU REMANUFACTURING ASIA - BALIKPAPAN


Kegiatan Inhouse Training Android Application Development with Phonegap and Jquery Mobile ini diselenggarakan di PT. Komatsu Remanufacturing Asia (KRA) - Balikpapan, training berlangsung selama 3 hari dengan fokus pemanfaatan Javascript Framework Phonegap untuk membangun Android Application yang dikombinasikan dengan Jquery Mobile dan Ajax JQuery serta PHP JSON service. Seperti diketahui bahwa Phonegap merupakan solusi alternatif buat para web developer untuk secara instan bisa segera mengembangkan Mobile Applications tanpa berlama lama mempelajari bahasa native di setiap teknologi mobile . Phonegap memiliki kemampuan sebagai native intepreter antara bahasa javascript dengan bahasa native dan mampu men-generate output ke berbagai mobile OS platform seperti Android, IOS, Blackberry, Windows Mobile, Simbian dll.

Adapun materi pelatihan Android Application Development with Phonegap and Jquery Mobile di KRA Balikpapan meliputi  :


  • Building your first jQuery Mobile app
  • Understanding the page architecture
  • Using page transitions and dialog widgets
  • Working with forms and controls
  • Creating toolbars
  • Working with list views
  • Using jQuery Mobile's content formatting features
  • Adding events to detect and respond to changes
  • Configuring and customizing jQuery Mobile
  • Phonegap Desktop Installation
  • Phonegap Build
  • HTML 5 key features
  • HTML 5 local storage
  • Connecting to MySQL Database with JSONP Ajax Jquery
  • Generate Android Sign Key
  • How to upload into google playstore


Besar harapan bahwa pelatihan android phonegap di KRA balikpapan ini dapat memberikan manfaat buat para tim application developer dalam mengembangkan aplikasi aplikasi mobile yang mampu berintegrasi dengan sistem utama untuk mendukung bisnis perusahaan

INHOUSE TRAINING EXCEL VBA MACRO DI PT. PERTAMINA GEOTHERMAL ENERGY JAKARTA



Inhouse Training Excel VBA Macro yang bekerjasama dengn PT. Pertamina Geotherma Energy (PGE) berlangsung  di kantor PGE beralamat di Menara Cakrawala Lantai 11, Jalan M.H. Thamrin No. 9, Menteng, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta 10340 , kegiatan training Excel Macro di Pertamina Geothermal Energy ini berlangsung selama 5 hari  diikuti oleh 18 Peserta dari level staff dan manajemen serta dilaksanakan after working hour atau selepas jam kerja yaitu jam 16.00 - 20.00 agar peserta bisa fokus dalam menyerap materi dan juga kegiatan training tidak mengganggu day to day business yang sedang berjalan.

Adapun materi pelatihan Excel VBA Macro yang diberikan kepada peserta Pertamina Geotherma Energy antara lain :

 I. Persiapan
Developer Ribbon
Macro Security
Macro Enabled Workbook (.xlsm)

II. Recording Macro
Record Macro
Manage Macro
Relative References
Edit Macro

III. VBE, Module & Procedures
Mengakses VBE
Module
Procedures

IV. Object & Addressing
Object Addressing

V. Property Format
Format menggunakan .Address

VI. With … End With
Penggunaan With.. End With

VII. Formula R1C1
Penggunaan R1C1

VIII. Variable
Fase Variable
Local Variable
Public Variable
Constant Variable
Object Variable

IX. Inputbox
Penggunaan Inputbox

X. Conditional If
Penggunaan Conditional IF
UCASE/LCASE  Function

XI. User Defined Function (UDF)
Pembuatan UDF

XII. Msgbox
Penggunaan Msgbox

XIII. Anatomi Script & Project Password
Anatomi script
Project Password

XIV. Subrutin & Error Handling
Penggunaan SUBRUTIN
Penggunaan ERROR HANDLING

XV. Array & Looping
Jenis Array
Jenis Looping
For .. Next
Do... Loop
isEmpty function

XVI. Object Form & Control
Form
Toolbox
Lable
Textbox
Enabled = False
ComboBox
Command Button
TabIndex Property
Text Property
Event & Private Sub

XVII. Run Macro from Excel
Menambahkan Control Button Form di Sheet


Besar harapan materi training Excel VBA Macro ini dapat memberikan manfaat dalam hal meningkatkan kinerja file excel terkait otomatisasi yang dihadapi staff dan manajemen PT. Pertamina Geothermal Energy untuk mendukung day to day bisnisnya



INHOUSE TRAINING EXCEL VBA MACRO - PT. HM SAMPOERNA - SUKOREJO PASURUAN



Kegiatan Inhouse Training Excel VBA Macro yang berlangsung di PT. HM Sampoerna , Tbk - Plant Sukorejo Pasuruan diikuti oleh 12 peserta dari lintas departemen selama 3 hari dengan fokus pelatihan pada aspek meningkatkan kinerja file dengan memberikan otomatisasi. Adapun materi yang diberikan antara lain :

I. Persiapan
Developer Ribbon
Macro Security
Macro Enabled Workbook (.xlsm)

II. Recording Macro
Record Macro
Manage Macro
Relative References
Edit Macro

III. VBE, Module & Procedures
Mengakses VBE
Module
Procedures

IV. Object & Addressing
Object Addressing

V. Property Format
Format menggunakan .Address

VI. With … End With
Penggunaan With.. End With

VII. Formula R1C1
Penggunaan R1C1

VIII. Variable
Fase Variable
Local Variable
Public Variable
Constant Variable
Object Variable

IX. Inputbox
Penggunaan Inputbox

X. Conditional If
Penggunaan Conditional IF
UCASE/LCASE  Function

XI. User Defined Function (UDF)
Pembuatan UDF

XII. Msgbox
Penggunaan Msgbox

XIII. Anatomi Script & Project Password
Anatomi script
Project Password

XIV. Subrutin & Error Handling
Penggunaan SUBRUTIN
Penggunaan ERROR HANDLING

XV. Array & Looping
Jenis Array
Jenis Looping
For .. Next
Do... Loop
isEmpty function

XVI. Object Form & Control
Form
Toolbox
Lable
Textbox
Enabled = False
ComboBox
Command Button
TabIndex Property
Text Property
Event & Private Sub

XVII. Run Macro from Excel
Menambahkan Control Button Form di Sheet

Hasil dari pelatihan Excel VBA Macro di PT HM Sampoerna diharapkan mampu mendukung kegiatan otomatisasi di file excel untuk pelaporan atau integrasi dengan file file kerja lainnya seperti Microsoft Word dan database MS Access