VBA for Microsoft Excel

Training VBA for Microsoft Excel

Training VBA for Microsoft Excel

Microsoft Excel dengan Visual Basic for Applications menggabungkan cara baru mengotomatisasi aplikasi yang disebut Otomasi. Visual Basic bertindak sebagai bahasa tujuan umum yang independen dari aplikasi. Bahkan berpikir Excel menjadi tuan rumah Visual Basic. Visual Basic tidak memiliki “kait” khusus ke dalam internal Excel. Sebaliknya, Excel memperlihatkan kemampuan untuk Visual Basic melalui serangkaian perintah khusus yang disebut perpustakaan objek. Pembicaraan Visual Basic ke perpustakaan objek Excel.

Materi pelatihan VBA for Microsoft Excel ?

  1. RECORDING A MACRO
    a.Recording A Macro (To Format Currency)
    b.Running The Macro
    c.Assign A Shortcut Key To The Macro
    d.Looking at The Macro
    e.Recording Another Macro (To Merge Cells Vertically)
    f.liminate Innecessary Lines From The Macro
  2. EDITING A RECORDED MACRO
    a.Recording A Macro To Remove Gridlines
    b.Run The Macro From The Visual Basic Editor
    c.Toogle The Value Of A Property With A Macro
  3. VARIABLES
    a.Statements Used To Declare Variables
    b.User-Defined Types
  4. SUB PROCEDURS
    a.Qualities of Sub Procedures
    b.Calling Sub Procedures from The Same Workbook
    c.Calling Sub Procedures from Another Workbook
  5. FUNCTION PROCEDURES
    a.Qualities Of Function Procedures
    b.User-Defined Functions
  6. USER INPUT
    a.Named Arguments
    b.Msgbox Function
    c.Inputbox Function
    d.Inputbox Method
    e.Using Built-In Microsoft Excel Dialog Boxes
  7. CONDITIONAL BRANCHING
    a.If … Then … Else Statement
    b.Select Case Statement LOOPING
    c.Do … Loop Statement
    d.For … Next Statement
  8. OBJECT
    a.Properties
    b.Methods
    c.Object Architecture
    d.Referencing Objects
    e.Working With Objects
  9. COLLECTIONS
    a.Set Of Related Objects
    b.Important Collections
    c.Add and Close A Workbook
    d.Use Autolist To Learn Constant Values
    e.Declare Variables To Enable Auto Lists
    f.Enhancing Recorded Selections
    g.Simplify Select Groups
    h.Exploring Ranges and Its Propert
  10. CHART OBJECTS
    a.Record A Macro That Creates A Chart
    b.Modify the Macro That Creates A Chart
    c.Refer To an Existing Embedded Chart
    d.Record A Macro That Modifies Chart
  11. HANDLING ERRORS
    a.Error Statements and Functions
    b.Statement / Function
    c.Creating an error Handler
    d.Setting an Error Trap
    e.Writing an Error-Handling Routine
    f.Exciting the Routine
    g.Other Ways To Handle Errors
  12. CREATING THE FORM’S USER INTERFACE
    a.Create The Form
    b.Adding Frame And Option Buttons
    c.Add Check Box And Text Box
    d.Initialise The Text Box
    e.Add Command Buttons
    f.Create A Macro To Switch Views
    g.Dynamically Hide Columns
    h.Implement Option Buttons
    i.Implement A Check Box
    j.Print The Repor

Metode PelatihanJadwal/Agenda Pelatihan
- Presentasi
- Diskusi
- Case Study
- Simulation
- Evaluation (Pre and Post Test)
- Kunjungan/Praktek (Menyesuaikan/tentative)
- 2 sd 4 Januari 2019
- 13 sd 15 Februari 2019
- 27 sd 29 Maret 2019
- 17 sd 19 April 2019
- 7 sd 9 Mei 2019
- 12 sd 14 Juni 2019
- 17 sd 19 Juli 2019
- 14 sd 16 Agustus 2019
- 12 sd 14 September 2019
- 16 sd 18 Oktober 2019
- 21 sd 23 November 2019
- 26 sd 28 Desember 2019

Lokasi & InvestasiFasilitas
- Yogyakarta (6.500.000 IDR / participant)
- Jakarta (6.500.000 IDR / participant)
- Bandung (6.500.000 IDR / participant)
- Bali (7.500.000 IDR / participant)
- Surabaya (6.000.000 IDR / participant)
- Malang (7.000.000 IDR / participant)
- Batam (7.500.000 IDR / participant)
- Lombok(7.500.000 IDR / participant)
- FREE Airport pickup service (Gratis Antar jemput Hotel/Bandara/Stasiun/Terminal)
- FREE TransporsiPeserta ke tempat pelatihan .
- Module atau Handout
- FREE Flashdisk
- Sertifikat
- FREE Bag or bagpackers (Tas Training)
- Training Kit (Dokumentasi photo, Blocknote, ATK, etc)
- 2x Coffe Break & 1 Lunch, Dinner
- FREE Souvenir Exclusive
- Training room full AC and Multimedia

Catatan :

Hotel untuk pelatihan ada beberapa pilihan seperti Hotel Ibis, Hotel Aston, Hotel Amaris, Hotel Cavinton, Hotel Hyatt, Hotel Grand Aston, Novotel, Hotel Harris, Hotel 101, Hotel Grand Mercure,Ritz Carlton, Hotel Ibis Style dan masih banyak pilihan menarik lainnya.

Apabila perusahaan membutuhkan paket in house training anggaran investasi pelatihan dapat menyesuaikan dengan anggaran perusahaan. Dapatkan harga spesial untuk pengiriman minimal 3 peserta dari perusahaan yang sama.

Informasi lebih lanjut :

Tlp./ WA : 0813-9174-4490 || Email : info@diklat-indonesia.com

0 comments on “Training VBA for Microsoft ExcelAdd yours →

Tinggalkan Balasan

Alamat email Anda tidak akan dipublikasikan. Ruas yang wajib ditandai *