Sale!

Excel Programming Weekend Crash Course 1st Edition by Peter G Aitken ISBN 0764540629 9780764540622

Original price was: $50.00.Current price is: $35.00.

Excel Programming Weekend Crash Course 1st ed Edition Peter G. Aitken Digital Instant Download

Author(s): Peter G. Aitken
ISBN(s): 9780764540622, 0764540629
Edition: 1st ed
File Details: PDF, 11.08 MB
Year: 2003
Language: english
SKU: EB-972546 Category: Tag:

Excel Programming Weekend Crash Course 1st Edition by Peter G Aitken – Ebook PDF Instant Download/Delivery: 0764540629, 9780764540622
Full download Excel Programming Weekend Crash Course 1st Edition after payment

Product details:

ISBN 10: 0764540629
ISBN 13: 9780764540622
Author: Peter G Aitken

The book is a how-to guide and tutorial that focuses on a specific topic: how to use Excel?s programmability to create custom data processing and analysis solutions. It provides readers with a clear-cut, structured approach to learning Excel programming. Emphasis on practical solutions and real-world examples, rather than on background and theory, helps the reader to develop programming skills quickly. The author?s clean and concise writing style, coupled with his extensive experience with Excel programming, help the reader to understand and utilize difficult concepts without delay.

Excel Programming Weekend Crash Course 1st Table of contents:

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.

People also search for Excel Programming Weekend Crash Course 1st:

excel crash course 2022
    
excel crash course for beginners
    
excel crash course for engineers
    
excel crash courses
    
excel crash course free

Tags: Peter G Aitken, Excel Programming, Crash Course