top of page

Microsoft Excel 2013 VBA

Overview / Course Outline

In this course, participants will examine the Visual Basic for Applications Environment and create custom procedures to enhance the functionality of Excel.

 

  1. Getting Started

  2. Working with Procedures and Functions

  3. Understanding Objects

  4. Using Expressions, Variables, and Intrinsic Functions

  5. Controlling Program Execution

  6. Working with Forms and Controls

  7. Working with the PivotTable Object

  8. Debugging Code

  9. Handling Errors

Pre-requisite

To ensure success, youshould be familiar with Microsoft Excel 2013 and able to edit and perform analysis using Excel 2013 advanced features such as What-If Analysis.Simple programming logic appreciation will be of great help to understand and follow lesson but not essential.

Duration

3 Days, 9.00am to 5.30pm

Request for full course flyer or discuss your requirement with us now!

Thank you for your enquiry. We will response to you within 24 hours.

bottom of page