The Curriculum

Friday

Evening: 4 Sessions, 2 Hours

* Microsoft® Excel and Programming–Why and How
* The VBA Code Editor
* The Excel Object Model
* Syntax and Data in VBA

Saturday

Morning: 6 Sessions, 3 Hours

* Operators
* Control Constructs
* Procedures and Modules
* Working with Dates and Times
* Working with Text
* Using Ranges and Selections

Afternoon: 6 Sessions, 3 Hours

* Working with Columns, Rows, and Cells
* Programming with Custom Formulas
* Programming with Excel's Built-In Functions
* Formatting a Worksheet
* Find and Replace Operations
* Creating Custom Toolbars

Saturday, cont.

Evening: 4 Sessions, 2 Hours

* Introduction to Charts
* Advanced Charting Techniques
* Creating Custom Dialog Boxes with User Forms
* Controls for User Forms

Sunday

Morning: 6 Sessions, 3 Hours

* Advanced User Form Techniques
* A User Form Example
* Working with Events
* Security Considerations
* Debugging and Distributing an Application
* Defining and Using Custom Classes

Afternoon: 4 Sessions, 2 Hours

* Handling Runtime Errors
* Database Tasks
* Creating Add-Ins
* Adding Online Help to Your Application

URL:
http://rapidshare.com/files/32893453/Excel_Programming_Weekend_Crash_Course.rar

pass:xihadd@warez-bb.org

Dear visitor, you went to the site as unregistered user. We encourage you to register or enter the site under your name.