Haapy New Year 2016

Training SOP

Microsoft Visual Basic Programming for Ms. Excel

Home/ITProgramming/Microsoft Visual Basic Programming for Ms. Excel

Microsoft Visual Basic Programming for Ms. Excel

Rp3.500.000,00

Request & Inqueries

 

Category:

Product Description

Duration: 3 Days

Course Content

This 3-day instructor-led course provides students with the knowledge and skills to use Microsoft Visual Basic for Applications to control Microsoft Excel programmatically. The course serves as an introduction to programming using the Visual Basic programming language.

Prerequisites
An intermediate level of experience using Microsoft Excel. Familiarity with PivotTables is helpful, but not required. No prior programming experience is necessary.

Who Should Attend
Microsoft Visual Basic is intended for experienced Excel users who are interested in creating code to automate tasks in Excel.

Course Objective

After completing Microsoft Visual Basic , students will be able to:

  • Record and edit macros.
  • Use the Visual Basic Editor.
  • Create and call sub and function procedures.
  • Understand objects, properties, methods, and events.
  • Use the Object Browser.
  • Work with variables and understand data types.
  • Use intrinsic functions.
  • Work with control-of-flow structures.
  • Design User Forms and work with controls.
  • Control PivotTables programmatically.
  • Use debugging tools.
  • Add error handling to code.

Course Outline

  • Module 1: Getting Started : This module explains how to record and run macros.
  • Module 2: Working with Procedures and Functions :This module explains how to create modules, sub procedures, and function procedures.
  • Module 3: Understanding Objects : This module explains Excel objects and object properties, methods, and events.
  • Module 4: Using Expressions, Variables, and Intrinsic Functions :This module explains how to name, declare, assign values to, and use variables.
  • Module 5: Controlling Program Execution : This module explains how to use decision structures to control program flow.
  • Module 6: Working with Forms and Controls : This module explains how to create a UserForm.
  • Module 7: Working with the PivotTable Object : This module explains how to work with PivotTable objects using VBA code.
  • Module 8: Debugging Code : This module explains the debugging tools in the Visual Basic Editor and their use.
  • Module 9: Handling Errors : This module explains how to trap errors and write an error handling routine.

 

Lokasi Training

IT Learning Center
Permata Kuningan bld 17th floor, Jl. Kuningan Mulia Kav. 9
HR. Rasuna Said, Jakarta Selatan – Indonesia

Hubungi kami untuk informasi lebih detail

Jakarta
Sonia Priyanka
Email : [email protected]
WA : 0856 6406 4244

Surabaya
Dwi Aliyah
Email : [email protected]
WA : 0822 4414 7658

Atau dapat mengisi form Inquiry & Information dengan mengklik tombol dibawah ini.

Reviews

There are no reviews yet.

Be the first to review “Microsoft Visual Basic Programming for Ms. Excel”