Pelatihan VBA for Microsoft Excel

Alamat Kantor

Jalan Raya Tajem, Dukuh Pokoh Baru, Perum Kampung Asri 2 No B2, RT 2 / RW 19,
Kelurahan Wedomartani, Kec. Ngemplak, Kab. Sleman,
Daerah Istimewa Yogyakarta, 55584. Telp : (0274) 4530527

Pelatihan VBA for Microsoft Excel

VBA for Microsoft Excel
Description
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.
COURSE OUTLINE

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

Jadwal Pelatihan Berdiklat Training 2019 :

  • 15 sd 16 Januari 2019
  • 29 sd 30 Januari 2019
  • 12 sd 13 Februari 2019
  • 26 sd 27 Februari 2019
  • 5 sd 6 Maret 2019
  • 19 sd 20 Maret 2019
  • 9 sd 10 April 2019
  • 23 sd 24 April 2019
  • 7 sd 9 Mei 2019
  • 21 sd 22 Mei 2019
  • 12 sd 13 Juni 2019
  • 25 sd 26 Juni 2019
  • 9 sd 10 Juli 2019
  • 23 sd 24 Juli 2019
  • 13 sd 14 Agustus 2019
  • 27 sd 28 Agustus 2019
  • 10 sd 11 September 2019
  • 24 sd 25 September 2019
  • 8 sd 9 Oktober 2019
  • 22 sd 23 Oktober 2019
  • 5 sd 6 November 2019
  • 21 sd 20 November 2019
  • 3 sd 4 Desember 2019
  • 17 sd 18 Desember 2019

Catatan : Jadwal dapat menyesuaikan dengan kebutuhan anda.

Biaya dan Lokasi Pelatihan :

  • Jakarta : Hotel Amaris Kemang, Amaris Tendean,Trinity Hotel, Ibis Budget | Biaya Pelatihan : Rp. 7.500.000 / peserta(Minimal 2 Peserta).
  • Bandung : Hotel Santika, Hay Hotel,Ibis Style, Novotel Hotel, Golden Flower Hotel, 1O1 Hotel, Grand Tjokro Hotel, Tune Hotel, Four Point by Sheraton Hotel | Biaya Pelatihan : Rp. Rp. 7.000.000 / peserta(Minimal 2 Peserta).
  • Yogyakarta : Hotel NEO+ Awana, Cordela Hotel,Ibis Style, Boutique Hotel, Cavinton Hotel, Mutiara Hotel, Dafam Malioboro Hotel, Prima Inn Hotel | Biaya Pelatihan : Rp. 6.500.000 / peserta(Minimal 2 Peserta).
  • Surabaya : Novotel Hotel, Ibis Center Hotel, HARRIS Hotel, Favehotel, Alana Hotel | Biaya Pelatihan : Rp. 6.800.000 / peserta (Minimal 2 Peserta).
  • Malang : Amaris Hotel, The 1O1 Hotel, Ibis Style Hotel, El Hotel, Whiz Prime Hotel | Biaya Pelatihan : Rp. 6.800.000 / peserta (Minimal 2 Peserta).
  • Bali : Ibis Kuta, Fontana Hotel, HARRIS Hotel & Conventions | Biaya Pelatihan : Rp. 6.500.000 / peserta (Minimal 3 Peserta).
  • Lombok : Favehotel, Novotel Lombok, D Praya Hotel | Biaya Pelatihan : Rp. 7.000.000 / peserta (Minimal 3 Peserta).

Catatan : Biaya diatas belum termasuk akomodasi/penginapan. Apabila ada pertayaan mengenai materi, biaya, lokasi, jadwal dan penawaran lainnya, hubungi kami di nomor 0823-2382-3308 atau 0853-2672-5665 .

Fasilitas Pelatihan di Berdiklat Training :

  1. Penjemputan dari Hotel/Bandara/Stasiun/Terminal.
  2. Training Kit (Dokumentasi photo, Blocknote, ATK, Flashdisk, dll).
  3. Transportasi Peserta ke tempat pelatihan.
  4. 2x Coffe Break & 1 Lunch (Makan Siang).
  5. Training Room Full AC and Multimedia.
  6. Free Bag or Bagpackers (Tas Training).
  7. Softfile Foto Training
  8. Sertifikat Pelatihan.
  9. Souvenir Exclusive.
Ikuti Kami :

Be the first to comment

Leave a Reply

Alamat email Anda tidak akan dipublikasikan.


*