| Jadwal Kegiatan Pelatihan |
| Tanggal posting 19-Nov-24 21:40 wib. dilihat sebanyak 4
kali
|
| Jadwal Kegiatan Pelatihan Excel VBA Macro Training di Jalan Bengawan Bandung - Purnama Academy |
| 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 |
Info Terbaru bulan November 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
*** Other Topics : Microsoft Excel VBA Macro, Power Query, QGIS, IBM Cognos, PHP Web Development, Microsoft Project, Power BI, Python Programming, Oracle, Magento, Primavera P6, JSON, Angular, JQuery, Tableau visit www.purnamaAcademy.com atau whatsapp 0838-0838-0001 | Posting Date : Tuesday, 19-November-2024, 16:40 |
| |
|
|
| 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 - Purnama Academy ' . Di-generate otomatis oleh google map Api update bulan November 2024 .
Informasi selengkapnya silahkan hubungi langsung pemilik iklan kegiatan |
| |
|
|
| |
|
|
| |
|
|
|
|
|
