Excel Programming Weekend Crash Course (eBook)
456 Seiten
John Wiley & Sons (Verlag)
978-0-7645-5575-6 (ISBN)
* Book is designed to teach the core concepts of Excel over aweekend or in just fifteen hours, with each session being thirtyminutes
* 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 datamanipulation in Excel quickly, so they can handle real-worldprojects
* A how-to guide to using Excel's programmability to createcustom data-processing and analysis solutions
* Covers security, debugging, and error handling
* Companion Web site includes sample files, projects, and testenginewith self-assessment exam
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.
FRIDAY.
PART I--Friday Evening.
SESSION 1-Microsoft Excel Programming--Why andHow.
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-InFunctions.
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 UserForms.
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.
| Erscheint lt. Verlag | 6.5.2004 |
|---|---|
| Reihe/Serie | Weekend Crash Course |
| Sprache | englisch |
| Themenwelt | Informatik ► Office Programme ► Excel |
| Schlagworte | Computer-Ratgeber • Computer Science • End-User Computing • Excel • Informatik • Microsoft Excel • Programmierung • Programmierung / Visual Basic • Programming / Visual Basic • Visual BASIC |
| ISBN-10 | 0-7645-5575-8 / 0764555758 |
| ISBN-13 | 978-0-7645-5575-6 / 9780764555756 |
| Haben Sie eine Frage zum Produkt? |
PDF (Adobe DRM)Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine
Geräteliste und zusätzliche Hinweise
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
