Excel 2007 Power Programming with VBA
John Wiley & Sons Ltd (Verlag)
978-0-470-04401-8 (ISBN)
- Titel ist leider vergriffen;
keine Neuauflage - Artikel merken
* This book is a single reference that's indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere* Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won't find anywhere else* John Walkenbach, aka "Mr. Spreadsheet," is one of the world's leading authorities on Excel* Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features* Includes a valuable CD-ROM with templates and worksheets from the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
John Walkenbach, arguably the foremost authority on Excel, has written hundreds of articles and created the award-winning Power Utility Pak. His 40-plus books include Excel 2007 Bible, Excel 2007 Formulas, and John Walkenbach's Favorite Excel Tips & Tricks, all published by Wiley. Visit his popular Spreadsheet Page at www.j-walk.com/ss.
Preface. PART I: SOME ESSENTIAL BACKGROUND. Chapter 1: Excel 2007: Where It Came From. Chapter 2: Excel in a Nutshell. Chapter 3: Formula, Tricks and Techniques. Chapter 4: Understanding Excel's Files. PART II: EXCEL APPLICATION DEVELOPMENT. Chapter 5: What Is a Spreadsheet Application? Chapter 6: Essentials of Spreadsheet Application Development. PART III: UNDERSTANDING VISUAL BASIC FOR APPLICATIONS. Chapter 7: Introducing Visual Basic for Applications. Chapter 8: VBA Programming Fundamentals. Chapter 9: Working with VBA Sub Procedures. Chapter 10: Creating Function Procedures. Chapter 11: VBA Programming Examples and Techniques. PART IV: WORKING WITH USERFORMS. Chapter 12: Custom Dialog Box Alternatives. Chapter 13: Introducing UserForms. Chapter 14: UserForm Examples. Chapter 15: Advanced UserForm Techniques. PART V: ADVANCED PROGRAMMING TECHNIQUES. Chapter 16: Developing Excel Utilities with VBA. Chapter 17: Working withy Pivot Tables. Chapter 18: Working with Charts. Chapter 19: Understanding Excel's Events. Chapter 20: Interacting with Other Applications. Chapter 21: Creating and Using Add-Ins. PART VI: DEVELOPING APPLICATIONS. Chapter 22: Working with the Ribbon. Chapter 23: Working with Shortcut Menus. Chapter 24: Providing Help for Your Applications. Chapter 25: Developing User-Oriented Applications. PART VII: OTHER TOPICS. Chapter 26: Compatibility Issues. Chapter 27: Manipulating Files with VBA. Chapter 28: Manipulating Visual Basic Components. Chapter 29: Understanding Class Modules. Chapter 30: Working with Colors. Chapter 31: Frequently Asked Questions about Excel Programming. PART VIII: APPENDIXES. Appendix A: Excel Resources Online Appendix B: VBA Statements and Functions Reference. Appendix C: VBA Error Codes. Appendix D: What's on the CD-ROM. Index.
| Erscheint lt. Verlag | 17.4.2007 |
|---|---|
| Reihe/Serie | Mr. Spreadsheet′s Bookshelf |
| Verlagsort | Chichester |
| Sprache | englisch |
| Maße | 193 x 233 mm |
| Gewicht | 1482 g |
| Themenwelt | Informatik ► Office Programme ► Excel |
| ISBN-10 | 0-470-04401-2 / 0470044012 |
| ISBN-13 | 978-0-470-04401-8 / 9780470044018 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
aus dem Bereich
