Pelatihan VBA for Microsoft Excel
VBA for Microsoft Excel Training
Description Pelatihan VBA for Microsoft Excel
Microsoft Excel with Visual Basic for Applications incorporates a whole new way of automating applications called Automation. Visual Basic acts as general-purpose language that is independent of the application. Even thought Excel host Visual Basic. Visual Basic does not have any special “hooks” into Excel’s internals. Rather, Excel exposes is capabilities to Visual
Basic by mean of a special set of command called an object library. Visual Basic talks to Excel’s object library.
Outline Pelatihan VBA for Microsoft Excel
RECORDING A MACRO
• Recording A Macro (To Format Currency)
• Running The Macro
• Assign A Shortcut Key To The Macro
• Looking at The Macro
• Recording Another Macro (To Merge Cells
Vertically)
• Eliminate Innecessary Lines From The Macro
EDITING A RECORDED MACRO
• Recording A Macro To Remove Gridlines
• Run The Macro From The Visual Basic Editor
• Toogle The Value Of A Property With A Macro
VARIABLES
• Statements Used To Declare Variables
• User-Defined Types
SUB PROCEDURS
• Qualities of Sub Procedures
• Calling Sub Procedures from The Same Workbook
• Calling Sub Procedures from Another Workbook
FUNCTION PROCEDURES
• Qualities Of Function Procedures
• User-Defined Functions
USER INPUT
• Named Arguments
• Msgbox Function
• Inputbox Function
• Inputbox Method
• Using Built-In Microsoft Excel Dialog Boxes
CONDITIONAL BRANCHING
• If … Then … Else Statement
• Select Case Statement LOOPING
• Do … Loop Statement
• For … Next Statement
OBJECT
• Properties
• Methods
• Object Architecture
• Referencing Objects
• Working With Objects
COLLECTIONS
• Set Of Related Objects
• Important Collections
• Add and Close A Workbook
• Use Autolist To Learn Constant Values
• Declare Variables To Enable Auto Lists
• Enhancing Recorded Selections
• Simplify Select Groups
• Exploring Ranges and Its Property
CHART OBJECTS
• Record A Macro That Creates A Chart
• Modify the Macro That Creates A Chart
• Refer To an Existing Embedded Chart
• Record A Macro That Modifies Chart
HANDLING ERRORS
• Error Statements and Functions
• Statement / Function
• Creating an error Handler
• Setting an Error Trap
• Writing an Error-Handling Routine
• Exciting the Routine
• Other Ways To Handle Errors
CREATING THE FORM’S USER INTERFACE
• Create The Form
• Adding Frame And Option Buttons
• Add Check Box And Text Box
• Initialise The Text Box
• Add Command Buttons
• Create A Macro To Switch Views
• Dynamically Hide Columns
• Implement Option Buttons
• Implement A Check Box
• Print The Report
Peserta
Peserta dapat diikuti oleh semua yang tertarik pada bidang ini. Selain itu juga dapat diikuti oleh semua yang ingin mengatahui dan mendalami tentang bidang ini.
Instruktur
Instruktur dalam Pelatihan dan Training ini akan dibawakan oleh seorang yang ahli dalam bidang ini.
Metode
1. Presentasi
2. Diskusi antar peserta
3. Studi kasus
4. Simulasi
5. Evaluasi
6. Konsultasi dengan instruktur
Jadwal Pelatihan Jogja Media Training 2020 :
5-7 Januari 2021 | 12-14 Januari 2021 | 26-28 Januari 2021
2-4 Februari 2021 | 16-18 Februari 2021 | 23-25 Februari 2021
2-4 Maret 2021 | 16-18 Maret 2021
6-8 April 2021 | 13-15 April 2021 | 27-29 April 2021
4-6 Mei 2021 | 18-20 Mei 2021
2-4 Juni 2021 | 15-17 Juni 2021
6-8 Juli 2021 | 27-29 Juli 2021
10-12 Agustus 2021 | 24-26 Agustus 2021
14-16 September 2021 | 28-30 September 2021
12-14 Oktober 2021 | 26-28 Oktober 2021
2-4 November 2021 | 16-18 November 2021 | 23-25 November 2021
7-9 Desember 2021 | 14-16 Desember 2021 | 21-23 Desember 2021 | 28-30 Desember 2021
Catatan : Jadwal tersebut dapat disesuaikan dengan kebutuhan calon peserta
Lokasi Pelatihan :
- Yogyakarta, Hotel Dafam Malioboro
- Jakarta, Hotel Amaris Tendean
- Bandung, Hotel Golden Flower
- Bali, Hotel Ibis Kuta
Investasi Pelatihan Tahun 2019 ini :
- Investasi pelatihan selama tiga hari tersebut menyesuaikan dengan jumlah peserta (on call). *Please feel free to contact us.
- Apabila perusahaan membutuhkan paket in house training, anggaran investasi pelatihan dapat menyesuaikan dengan anggaran perusahaan.
Fasilitas Training :
- FREE Airport pickup service (Gratis Antar jemput Hotel/Bandara/Stasiun/Terminal)
- Module / Handout
- FREE Flashdisk
- Sertifikat
- FREE Bag or bagpackers (Tas Training)
- Training Kit (Dokumentasi photo, Blocknote, ATK, etc)
- 2xCoffe Break & 1 Lunch, Dinner
- FREE Souvenir Exclusive
- Training room full AC and Multimedia