Microsoft Excel 2003 Programming Inside Out

Preliminaries

• What's New in Excel 2003

• Exploring Excel

Visual Basic for Applications

• Exploring Visual Basic for Applications

• VBA Programming Starter Kit

• Creating Sub and Function Procedures

The Excel Object Model

• The Application Object

• Workbooks and Worksheets

• Ranges and Cells

Advanced VBA

• Manipulating Data with VBA

• Formatting Excel Objects

• Creating Add-Ins and COM Add-Ins

• Understanding and Using Events

• Manipulating Files

• Developing Class Modules

Manipulating Excel Objects

• Charts

• PivotTables and PivotCharts

• Command Bars

• Customizing Dialog Boxes

• Creating User Forms

• Creating Advanced User Forms

Excel and the Outside World: Collaborating Made Easy

• Excel and Other Office Applications

• Excel and the Structured Query Language

• Introducing ADO

• Excel Query Program

• Excel and the Web

• Excel and the Extensible Markup Language (XML)