Get up to speed on Excel programming in a weekend! The big day is Monday. Thats when you get to show off what you know about Excel programming. The problem is, you're not really up to speed. Maybe its been a while since you programmed Excel to create custom data processing solutions. Perhaps youve just discovered Excels adaptability. Or maybe you just like a challenge. In any event, weve got a solution for you Excel Programming Weekend Crash Course. Open the book Friday evening and on Sunday afternoon, after completing 30 fast, focused sessions, you'll be able to dive right in and start programming and automating Excel. Its as simple as that.
The Curriculum Friday Evening: 4 Sessions, 2 Hours Microsoft Excel and ProgrammingWhy 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
Get up to speed on Excel programming in a weekend! The big day is Monday. Thats when you get to show off what you know about Excel programming. The problem is, you're not really up to speed. Maybe its been a while since you programmed Excel to create custom data processing solutions. Perhaps youve just discovered Excels adaptability. Or maybe you just like a challenge. In any event, weve got a solution for you Excel Programming Weekend Crash Course. Open the book Friday evening and on Sunday afternoon, after completing 30 fast, focused sessions, you'll be able to dive right in and start programming and automating Excel. Its as simple as that.
The Curriculum Friday Evening: 4 Sessions, 2 Hours Microsoft Excel and ProgrammingWhy 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
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.
Peter G. Aitken has been writing about computers and programming for over 10 years, with some 30 books as well as hundreds of magazine and trade publication articles to his credit. His recent book titles include Visual Basic .NET Programming with Peter Aitken, Office XP Development with VBA, XML the Microsoft Way, Windows Script Host, and Teach Yourself Visual Basic .NET Internet Programming in 21 Days. For several years he was a Contributing Editor at Visual Developer Magazine where he wrote a popular Visual Basic column. He is a regular contributor to Microsoft OfficePro magazine and the DevX Web site. Peter is the proprietor of PGA Consulting, providing custom application and Internet development to business, academia, and government since 1994.
|
Ask a Question About this Product More... |
|
