| Jadwal Kegiatan Pelatihan |
| Tanggal posting 29-Aug-24 21:19 wib. dilihat sebanyak 0
kali
|
| Jadwal Kegiatan Pelatihan Excel VBA Macro Training di Jalan Bengawan Bandung Bulan September 2024 |
| Rp
-Hubungi Whatsapp-
( 3 Days (09.00-16.00) )
|
|
| Posting oleh : Purnama Academy , Whatsapp. 08380838**** |
|
|
|
| Jadwal Kegiatan Pelatihan , Jawa Barat
|
|
|
| |
|
|
| |
jadwalkegiatan.com
|
| |
|
|
|
| |
|
|
| |
 Detail dan Status Jadwal Kegiatan Sampai Dengan November 2024 |
| Waktu Pelaksanaan |
3 Days (09.00-16.00) |
| Biaya |
Rp
-Hubungi Whatsapp- |
| Keterangan |
Update Terbaru di bulan September 2024 , Pelatihan di Jalan Bengawan . purnamaacademy, Whatsapp 083808380001.
Duration: 3 Days
Time: 09:00 - 16:00
Venue: Purnama Academy IT Training Center
Contact: For more details, please contact Sales Admin via WhatsApp at 0838-0838-0001.
________________________________________
Day 1: Introduction to Excel VBA
09:00 - 10:30
• Overview of Excel VBA
o Introduction to VBA and its capabilities in Excel
o Understanding the Excel object model
o Macro recording basics: Creating and running simple macros
10:30 - 10:45
• Break
10:45 - 12:00
• The VBA Editor
o Navigating the Visual Basic for Applications (VBA) editor
o Understanding modules, procedures, and functions
o Working with the Immediate, Watch, and Locals windows
12:00 - 13:00
• Lunch Break
13:00 - 14:30
• Variables, Data Types, and Constants
o Declaring and using variables
o Understanding data types and their importance
o Working with constants
14:30 - 14:45
• Break
14:45 - 16:00
• Control Structures
o If...Then...Else statements
o Select Case statements
o Looping with For...Next, Do...Loop, and While...Wend
________________________________________
Day 2: Working with Excel Objects and Events
09:00 - 10:30
• Understanding Excel Objects
o Working with the Application, Workbook, Worksheet, and Range objects
o Manipulating cells, ranges, and worksheets with VBA
o Creating and formatting charts using VBA
10:30 - 10:45
• Break
10:45 - 12:00
• Events and Event Handling
o Understanding event-driven programming
o Workbook and worksheet events
o Creating event procedures to automate tasks
12:00 - 13:00
• Lunch Break
13:00 - 14:30
• User Forms and Controls
o Designing and creating user forms
o Adding controls such as buttons, text boxes, and combo boxes
o Handling user input and form events
14:30 - 14:45
• Break
14:45 - 16:00
• Error Handling and Debugging
o Error types and handling techniques (On Error statements)
o Debugging tools and methods
o Using breakpoints, stepping through code, and the Watch window
________________________________________
Day 3: Advanced VBA Techniques and Automation
09:00 - 10:30
• Working with External Data
o Importing and exporting data with VBA
o Connecting to databases and web services
o Automating data retrieval and reporting
10:30 - 10:45
• Break
10:45 - 12:00
• Advanced Procedures and Functions
o Creating and using custom functions
o Passing arguments and returning values
o Modular programming techniques
12:00 - 13:00
• Lunch Break
13:00 - 14:30
• Automation Projects and Case Studies
o Participants will work on a project to automate tasks in Excel using VBA
o Case studies on common automation scenarios in business
14:30 - 14:45
• Break
14:45 - 16:00
• Final Review and Q&A Session
o Review of key concepts
o Q&A session
o Best practices for developing and maintaining VBA macros in Excel
|
| |
|
|
| Kontak Kegiatan |
| Nama Kontak |
Purnama Academy |
| Kontak HP / Whatsapp |
08380838****
|
| Lokasi / Venue Kegiatan |
Jalan Bengawan |
| |
Jawa Barat, Bandung |
| |
|
| Peta Lokasi Kontak |
|
 |
Perbesar Peta !
Detail peta sesuai alamat lokasi yang tertera di iklan 'Jadwal Kegiatan Pelatihan Excel VBA Macro Training di Jalan Bengawan Bandung Bulan September 2024 ' . Di-generate otomatis oleh google map Api update bulan November 2024 .
Informasi selengkapnya silahkan hubungi langsung pemilik iklan kegiatan |
| |
|
|
| |
|
|
| |
|
|
|
|
|
