Excel Programming Weekend Crash Course (E-Book) von Peter G. Aitken

PART IFriday Evening.

SESSION 1Microsoft Excel ProgrammingWhy and How.

SESSION 2The VBA Code Editor.

SESSION 3The Excel Object Model.

SESSION 4Syntax and Data in VBA.

SATURDAY.

PART IISaturday Morning.

SESSION 5Operators.

SESSION 6Control Constructs.

SESSION 7Procedures and Modules.

SESSION 8Working with Dates and Times.

SESSION 9Working with Text.

SESSION 10Using Ranges and Selections.

PART IIISaturday Afternoon.

SESSION 11Working with Columns, Rows, and Cells.

SESSION 12Programming with Custom Formulas.

SESSION 13Programming with Excels Built-In Functions.

SESSION 14Formatting a Worksheet.

SESSION 15Find and Replace Operations.

SESSION 16Creating Custom Toolbars.

PART IVSaturday Evening.

SESSION 17Introduction to Charts.

SESSION 18Advanced Charting Techniques.

SESSION 19Creating Custom Dialog Boxes with User Forms.

SESSION 20Controls for User Forms.

SUNDAY.

PART VSunday Morning.

SESSION 21Advanced User Form Techniques.

SESSION 22A User Form Example.

SESSION 23Working with Events.

SESSION 24Security Considerations.

SESSION 25Debugging and Distributing an Application.

SESSION 26Defining and Using Custom Classes.

PART VISunday Afternoon.

SESSION 27Handling Runtime Errors.

SESSION 28Database Tasks.

SESSION 29Creating Add-Ins.

SESSION 30Adding Online Help to Your Application.

Appendix AAnswers to Part Reviews.

Appendix BWhats on the Web Site.

Index.

• Thirty clearly defined lessons take the reader from understanding the parts of an Excel application into building applications to work with data, formulas, charts, and the enhanced XML capabilities of the new Excel "X"
• Book is designed to teach the core concepts of Excel over a weekend or in just fifteen hours, with each session being thirty minutes
• Applicable to Excel 2000, Excel 2002, and the latest release, Excel 2003
• Helps Excel power users in fields such as accounting, finance, operations management, and market research to begin automating data manipulation in Excel quickly, so they can handle real-world projects
• A how-to guide to using Excel's programmability to create custom data-processing and analysis solutions
• Covers security, debugging, and error handling
• Companion Web site includes sample files, projects, and test enginewith self-assessment exam