Durasi : 4 hari

• Introduction
  • Macro Introduction and Recording Macro
  • VBA Introduction and Exploring Visual Basic Editor
  • Variables, Arrays, Constants and Data Types
  • Modules, Functions and Subroutines
  • Decisions and Looping
  • Strings, Built-In Functions and Message Boxes
  • Operators
  • Debugging
  • Errors, Handling Errors and Error Functions
  • Dialogs
  • Common Dialog Control
  • Command Bars and Buttons

• Excel Object Models
  • Excel Object Model
  • Objects, Properties and Methods
  • Exploring Object Browser
  • Object Hierarchy
  • Recording Macros

• Excel Object Model – Main Objects
  • Application Object
  • Workbook Object
  • Windows Object
  • Worksheet Object
  • Range Object

• Using Excel to Do Interaction with Other Office Application
  • Interaction with Microsoft Outlook
  • Driving Excel from Other Office Application

• Excel VBA Advanced Technique
  • Working with Charts and Graphs
  • Working with Series Collection Object
  • Exporting a Chart as Picture File
  • Using Macro Recording
  • Working with Databases
  • ODBC Links
  • Using ADO

• API Calls
  • API Call Basics
  • Using API Call

• Class Modules
  • Inserting Class module
  • Create an Object
  • Creating a Collection
  • Using PNames Collection

• Working with XML Files
  • XML Document Basics
  • How does XML Relate to VBA
  • XML Map Basics
  • Customizing XML Map
  • Importing and Exporting Data
  • Manipulating XML Files Programmatically

• Ribbon
  • Creating a Ribbon Customization
  • Using Custom UI Editor
  • Creating Code for Your Custom Buttons
  • Images
  • Using VBA Code with the Ribbon
  • More on Ribbon

• Pivot Tables
  • Creating a Simple Pivot Table from the Front End of Excel
  • Creating Pivot Table Using VBA
  • Using VBA with Pivot Table
  • Advanced VBA for Pivot Tables
  • Points to Bear in Mind on Pivot Tables