Advanced VBA - Microsoft Excel 2007

2 Day Course
Hands On
Code QAEX07VBAA

This course has been retired. Please view currently available User Microsoft Office Training Courses.

Modules

Hide all

Excel 2007 Object Model (4 topics)

  • The Excel Component Object Model
  • Using Methods and Events
  • Object Variables and Binding
  • Creating User Defined Types and Classes

Working with the Range Object (5 topics)

  • Range Objects Defined
  • Referencing Ranges using VBA
  • Dynamic Range Handling
  • Copying or Moving Range Data
  • Creating Array Variables

Working With Data in Excel (5 topics)

  • Data Types v Formatting
  • Validating Data
  • Filtering and Sorting Data with VBA
  • Using Database Functions
  • Excel Tables

Presenting Data in Excel (3 topics)

  • Apply Conditional Formatting with VBA
  • Working with Charts
  • Pivot Tables

Importing Data into Excel (3 topics)

  • Creating Connections
  • Managing Connections
  • Excel and ADO

Working with the Excel Interface (4 topics)

  • Excel Interface Options
  • Controlling the Excel Interface
  • Using Events
  • Creating Excel Add-Ins

Managing Files and Folders from Excel (5 topics)

  • FileSystemObject
  • Managing Folders from Excel
  • File Management Tasks using Excel
  • Working with File Properties and Attributes from Excel
  • Reading a Text File from Excel

Prerequisites

  • Before attending this course, delegates should have attended the QAVBA07INT course or have equivalent VBA knowledge
  • Experience of recording and writing simple macros
  • Please note this course is not suitable for Excel 2007 users who have no VBA knowledge

Course PDF

Print

Sections