Skip to main content

Training Excel VBA Macro Progamming

EXCEL VBA MACRO PROGRAMMING
www.purnamaacademy.com , Hotline (Call/SMS/WA) :  0838-0838-0001

Syllabus Overview
Training Ini akan membahas cara meningkatkan kinerja excel dalam hal otomatisasi, distribusi, pengamanan dengan mempelajari bahasa pemograman Visual Basic for Application (VBA Macro) yang sudah ada di dalam Software Microsoft Excel, peserta juga memahami object hirarki dalam excel dan mengetahui cara melakukan distribusi macro dengan membuat addins sendiri


Class Type : Training
Duration : 3 Days (09.00 – 17.00)
Venue / Price : www.purnamaacademy.com 
Registration : www.purnamaacademy.com   (Save up to 20% for Early Bird Registration !)

Description :
Microsoft® Excel Macro adalah sebuah tool yang dapat membuat pekerjaan menjadi lebih mudah untuk ditangani, di share, dan dibaca. Fungsi utama  bahasa Makro untuk mengefesienkan langkah dalam pembuatan report di MS Excel hingga cukup dengan satu klik saja.  Visual Basic Application merupakan bahasa yang powerful untuk mempermudah proses kerja dari awalnya terdiri beberapa langkah menjadi cukup satu langkah saja. Sekarang Anda tidak lagi frustrasi dalam membuat dokumen, reports, kalkulasi dan juga project.
Secara garis besar peserta dalam training Macro and VBA for Excel course akan belajar mengenai :
1.       Pengenalan Konsep Macro and VBA
2.       Record, Store and Run a Macro
3.       Procedure, Functions, Event Programming Handling Errors
4.       Object Form dalam Macro

Topics include:

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


*  Participants must have good deep knowledge in Excel to follow this training !

Participants :  (IT Staff, Data Analyst, Desktop Programmer, Public  )

Speaker  : Purnama Academy Trainer

#trainingexcelmacro  #excelvbamacro #belajartutorial  #silabustraining #tempattraining  #pelatihan #jakarta  #bandung  #bali  #surabaya #makasar #jadwaltraining




Comments

Post a Comment

Silahkan isi komentar atau iklan baris Anda, Jangan lupa visit social media kami di FB/Twitter/Instagram @alamatclick

Popular posts from this blog

Smoke Test

Smoke Testing Explanation In computer programming and software testing, smoke testing (also confidence testing, sanity testing, build verification test (BVT) and build acceptance test) is preliminary testing to reveal simple failures severe enough to, for example, reject a prospective software release SMOKE TESTING, also known as "Build Verification Testing", is a type of software testing that comprises of a non-exhaustive set of tests that aim at ensuring that the most important functions work. The result of this testing is used to decide if a build is stable enough to proceed with further testing. The term 'smoke testing', it is said, came to software testing from a similar type of hardware testing, in which the device passed the test if it did not catch fire (or smoked) the first time it was turned on. Smoke Testing Elaboration Smoke testing covers most of the major functions of the software but none of them in depth. The result of t...
Post a Comment
Detail Alamat »

How to Pass ISACA CGEIT Certification Exam Dumps Practice Test

ISACA CGEIT certification is mainly targeted to those candidates who want to build their future in IT Governance domain. CGEIT exam can provide those within an information technology related governance field with great benefits, both with potential employers, and unlock a network of like-minded individuals. ISACA's Certified in the Governance of Enterprise IT (CGEIT) exam certification is framework agnostic and the only IT governance certification for the individual. CGEIT can put you in the role of a trusted advisor to your enterprise. CGEITs maintain an adequate level of current knowledge and proficiency in the field of information systems audit, control and security. The technical skill requirement of CGEIT is that the candidate has relevant professional work experience supporting organizational enterprise information technology. CGEIT is a vendor-neutral enterprise IT governance certification which can help take your career to new heights. Free Exam Practice Question and Answer...
Post a Comment
Detail Alamat »

TRAINING ENTERPRISE ARCHITECTURE DEVELOPMENT WITH TOGAF-BANDUNG

TRAINING ENTERPRISE ARCHITECTURE DEVELOPMENT WITH TOGAF By Purnama Academy - Training Center January 21, 2018  No comments ENTERPRISE ARCHITECTURE DEVELOPMENT WITH TOGAF Syllabus Overview TOGAF®, introduced by The Open Group, is a proven enterprise architecture methodology and framework used by the world's leading organizations to improve business efficiency. It is an enterprise architecture standard, ensuring consistent standards, methods, and communication among enterprise architecture professionals, so that we can conduct our enterprise architecture work in a better way, including: ·         An iterative process model supported by best practices ·         A re-usable set of existing architecture assets ·         Methods and tools for the planning, development, implementation, and maintenance of an enterprise architecture Togaf Core Concepts : Business Architect...
Post a Comment
Detail Alamat »