Monday, April 23, 2018

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

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

By Admin April 23, 2018  No comments



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.
Categories: , , , , ,

0 comments:

Post a Comment

Terima kasih telah mengunjungi halaman website kami, Jika ada pertanyaan terkait informasi di Atas silahkan isi Comment Box di bawah ini, Tim kami akan merespon komentar/ pertanyaan Anda paling lambat 2 x 24 Jam

Untuk respon cepat silahkan hubungi 0838-0838-0001 (Call/Whatsapp)

Regards,

Management,
www.purnamaacademy.com

IT Management and Certifications

  • TRAINING ITIL V.4 FOUNDATION (IT INFRASTRUCTURE LIBRARY)
  • TRAINING TOGAF (THE OPEN GROUP ARCHITECTURE FRAMEWORK) PART 1 & PART 2
  • TRAINING ARCHIMATE (ENTERPRISE ARCHITECTURE MODELING LANGUAGE)
  • TRAINING PMP/ CAPM (PMBOK - PROJECT MANAGEMENT BODY OF KNOWLEDGE)
  • TRAINING PMO (PROJECT MANAGEMENT OFFICE)
  • TRAINING CTFL - ISTQB (CERTIFIED TESTER FOUNDATION LEVEL - INTERNATIONAL SOFTWARE TESTING QUALIFICATION BOARD)
  • TRAINING SQA (SOFTWARE QUALITY ASSURANCE)
  • TRAINING PRINCE2 (PROJECTS IN CONTROLLED ENVIRONMENTS)
  • TRAINING RDBMS CONCEPT
  • TRAINING DATA MANAGEMENT BODY OF KNOWLEDGE (DMBOK)
  • TRAINING SAD UML (SYSTEM ANALYSIS DESIGN WITH UML 2.0)
  • TRAINING CBAP - BUSINESS ANALYSIS WITH BABOK V.2
  • TRAINING SEO & DIGITAL MARKETING
  • TRAINING E-FILLING WITH EDMS (ELECTRONIC DOCUMENT MANAGEMENT SYSTEM)
  • TRAINING ISO/IEC 27001:2022 (INFORMATION SECURITY MANAGEMENT SYSTEMS - ISMS)
  • TRAINING ISO/IEC 20000-1:2018 (INFORMATION TECHNOLOGY SERVICE MANAGEMENT)
  • TRAINING ISO/IEC 38500:2008 (CORPORATE GOVERNANCE OF INFORMATION TECHNOLOGY)
  • TRAINING ISO/IEC 90003:2014 (SOFTWARE ENGINEERING)
  • TRAINING ISO 31000 : RISK MANAGEMENT
  • TRAINING COSO ENTERPRISE RISK MANAGEMENT
  • TRAINING ISO 28000:2007 (SUPPLY CHAIN SECURITY MANAGEMENT)
  • TRAINING ISO 22301:2019, SECURITY AND RESILIENCE – BUSINESS CONTINUITY MANAGEMENT SYSTEMS
  • TRAINING INDEKS KAMI V.4.2 (INDEKS KEAMANAN INFORMASI) – BSSN
  • TRAINING SIX SIGMA FOUNDATION (GREEN BELT)
  • TRAINING IIOT (INDUSTRIAL 4.0 INTERNET OF THINGS)
  • TRAINING MANAGERIAL SKILLS AND LEADERSHIP
  • TRAINING KMS - KNOWLEDGE MANAGEMENT SYSTEM
  • TRAINING ELMS – ELECTRONIC LEARNING MANAGEMENT SYSTEM
  • TRAINING DEVOPS/ DEVSECOPS
  • TRAINING CISA (CERTIFIED INFORMATION SYSTEMS AUDITOR)
  • TRAINING CCISO (CERTIFIED CHIEF INFORMATION SECURITY OFFICER)
  • TRAINING CISM (CERTIFIED INFORMATION SECURITY MANAGER)
  • TRAINING CISSP (CERTIFIED INFORMATION SYSTEMS SECURITY PROFESSIONAL)
  • TRAINING CDPSE (CERTIFIED DATA PRIVACY SOLUTION ENGINEER)
  • TRAINING CGEIT (CERTIFIED IN THE GOVERNANCE OF ENTERPRISE INFORMATION TECHNOLOGY)
  • TRAINING CRISC (CERTIFIED IN RISK AND INFORMATION SYSTEMS CONTROL)
  • TRAINING SCRUM MASTER AND PRODUCT OWNER
  • TRAINING SECURING & AUDITING MICROSERVICES APPLICATIONS
  • TRAINING COBIT 2019 FOUNDATION
  • TRAINING COBIT 2019 DESIGN & IMPLEMENTATION
  • TRAINING ITIL V4 FOUNDATION
  • TRAINING CSM - CERTIFIED SCRUM MASTER
  • TRAINING CERTIFIED INFORMATION PRIVACY PROFESSIONAL (CIPP)
  • TRAINING ITAM – (IT ASSET MANAGEMENT)
  • TRAINING DATA STORYTELLING (INFOGRAFIS)
  • TRAINING EFFECTIVE WRITING SKILLS
  • TRAINING OPERATIONS - CAPACITY MANAGEMENT
  • TRAINING HDFCNA - HDF CERTIFIED NIFI ARCHITECT
  • TRAINING ICT DOCUMENT MANAGEMENT
  • TRAINING TECHNICAL WRITING FOR SOFTWARE DEVELOPMENT
  • TRAINING MODERN ICT OPERATIONS MANAGEMENT
  • TRAINING IT RISK MANAGEMENT
  • TRAINING IT HELPDESK MANAGEMENT
  • TRAINING PAYMENT CARD INDUSTRY DATA SECURITY STANDARD - PCI DSS 4.0 LEAD AUDITOR
  • TRAINING PROJECT MANAGEMENT WITH AGILE (SCRUM, RAD, KANBAN, VMODEL)
  • TRAINING UI/UX DESIGN
  • TRAINING COMPTIA SECURITY+

Top Topics