Pelatihan VBA for Microsoft Excel

Office

Gedung Yayasan Darul Marfu
Jalan H. Zainuddin No. 43, Radio Dalam
Kebayoran Baru, Jakarta Selatan, 12140

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 terupdate di tahun 2016 adalah sebagai berikut:
•    05 – 07 Januari 2016
•    03  – 05 Februari 2016
•    22 – 24 Maret 2016
•    12 – 14 April 2016
•    02 – 04 & 09 – 11 Mei 2016
•    01 – 03 Juni 2016
•    19 – 21 Juli 2016
•    15 – 16 Agustus 2016
•    07 – 09 September 2016
•    11 – 13 Oktober 2016
•    15 – 17 November 2016
•    07 – 09 & 21 – 23 Desember 2016

*Jadwal tersebut dapat disesuaikan dengan kebutuhan calon peserta

Lokasi Pelatihan Visual Basic for Applications :
•    Yogyakarta, Hotel Dafam Malioboro (6.000.000 IDR / participant)
•    Jakarta, Hotel Amaris Tendean (6.500.000 IDR / participant)
•    Bandung, Hotel Golden Flower (6.500.000 IDR / participant)
•    Bali, Hotel Ibis Kuta (7.500.000 IDR / participant)

Investasi Pelatihan Visual Basic for Applications  tahun 2016 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.

🙂

Jadwal Pelatihan berdiklat.com :

  • 24 sd 26 Januari 2017
  • 14 sd 16 Februari 2017
  • 29 sd 31 Maret 2017
  • 11 sd 13 April 2017
  • 8 sd 10 Mei 2017 and 22 sd 24 Mei 2017
  • 6 sd 8 Juni 2017
  • 18 sd 20 Juli 2017
  • 14 sd 16 Agustus 2017
  • 18 sd 20 September 2017
  • 10 sd 12 Oktober 2017
  • 7 d 9 November 2017
  • 4 sd 6 Desember 2017 and 26 sd 28 Desember 2017

*Jadwal tersebut dapat disesuaikan dengan kebutuhan calon peserta

 

Lokasi dan investasi Pelatihan:

  • Yogyakarta, Hotel Dafam Malioboro (6.500.000 IDR / participant)
  • Jakarta, Hotel Amaris Tendean (6.500.000 IDR / participant)
  • Bandung, Hotel Golden Flower (6.500.000 IDR / participant)
  • Bali, Hotel Ibis Kuta (7.500.000 IDR / participant)
  • Surabaya, Hotel Amaris (6.000.000 IDR / participant)
  • Lombok, Hotel Jayakarta(7.500.000 IDR / participant)
  • Apabila perusahaan membutuhkan paket in house training, anggaran investasi pelatihan dapat menyesuaikan dengan anggaran perusahaan.

 

Informasi Pelatihan :

Mobile Phone Number : 0852 9095 1223

email : admin@berdiklat.com / berdiklat@gmail.com/ berdiklattraining@gmail.com

🙂

Atau silahkan mengisi Formulir di bawah ini :

 

Be the first to comment

Leave a Reply

Alamat email Anda tidak akan dipublikasikan.


*