Microsoft Office Excel 2007 Power Programming with VBA View Larger Image | John Walkenbach
Wiley, Paperback, Bk&CD edition, Published April 2007, 1056 pages, ISBN 0470044012 | List Price: $49.99
Our Price: $30.95
You Save: $19.04 (38% Off)
| | | Availability: In-Stock |
Read an excerpt:
Chapter 1: Excel 2007: Where it Came From
Excerpt provided courtesy of John Wiley & Sons Inc. Copyright © John Wiley & Sons Inc. Written permission from the publisher is required for any use of this material.
|
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - Excel 2003 VBA Programmer's Reference; John Green, et al, $25.50, 36% Off!
- Ubuntu Linux Toolbox: 1000+ Commands for Ubuntu and Debian Power Users; Christopher Negus, et al, $15.95, 36% Off!
- Microsoft Office Excel 2007 Bible; John Walkenbach, $25.50, 36% Off!
- Excel 2007 VBA Programmer's Reference; John Green, et al, $25.50, 36% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
* 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.
Table of Contents
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.
About the Author
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.
|
