Excel programming

Description

Content: FRIDAY.PART I-Friday Evening.SESSION 1-Microsoft Excel Programming-Why and How.SESSION 2-The VBA Code Editor.SESSION 3-The Excel Object Model.SESSION 4-Syntax and Data in VBA.SATURDAY.PART II-Saturday Morning.SESSION 5-Operators.SESSION 6-Control Constructs.SESSION 7-Procedures and Modules.SESSION 8-Working with Dates and Times.SESSION 9-Working with Text.SESSION 10-Using Ranges and Selections.PART III-Saturday Afternoon.SESSION 11-Working with Columns, Rows, and Cells.SESSION 12-Programming with Custom Formulas.SESSION 13-Programming with Excel's Built-In Functions.SESSION 14-Formatting a Worksheet.SESSION 15-Find and Replace Operations.SESSION 16-Creating Custom Toolbars.PART IV-Saturday Evening.SESSION 17-Introduction to Charts.SESSION 18-Advanced Charting Techniques.SESSION 19-Creating Custom Dialog Boxes with User Forms.SESSION 20-Controls for User Forms.SUNDAY.PART V-Sunday Morning.SESSION 21-Advanced User Form Techniques.SESSION 22-A User Form Example.SESSION 23-Working with Events.SESSION 24-Security Considerations.SESSION 25-Debugging and Distributing an Application.SESSION 26-Defining and Using Custom Classes.PART VI-Sunday Afternoon.SESSION 27-Handling Runtime Errors.SESSION 28-Database Tasks.SESSION 29-Creating Add-Ins.SESSION 30-Adding Online Help to Your Application.Appendix A-Answers to Part Reviews.Appendix B-What's on the Web Site.Index.