{"product_id":"excel-2013-power-programming-with-vba-isbn-9781118490396","title":"Excel 2013 Power Programming with VBA","description":"\u003cp\u003e\u003cb\u003eMaximize your Excel 2013 experience using VBA application development\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, \"Mr. Spreadsheet\" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.\u003c\/p\u003e \u003cp\u003eFeaturing a complete introduction to Visual Basic for Applications and fully updated for the latest features of Excel 2013, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eOffers an analysis of Excel application development and a complete introduction to VBA\u003c\/li\u003e \u003cli\u003eFeatures invaluable advice from \"Mr. Spreadsheet\" himself, bestselling author John Walkenbach, who demonstrates all the techniques you need to create Excel applications, both large and small\u003c\/li\u003e \u003cli\u003eCovers navigating the Excel interface, formatting worksheets, interacting with other Office applications, working with collaboration tools, and using sample workbooks and John Walkenbach's award-winning Power Utility Pak to help enhance your Excel skills\u003c\/li\u003e \u003cli\u003eProvides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you wont find anywhere else\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003eExcel 2013 Power Programming with VBA\u003c\/i\u003e is packed with procedures, tips, and ideas for achieving Excel excellence with VBA.\u003c\/p\u003e \u003cp\u003eIntroduction 1\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I: Some Essential Background\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Excel in a Nutshell 11\u003c\/p\u003e \u003cp\u003eChapter 2: Formula Tricks and Techniques 39\u003c\/p\u003e \u003cp\u003eChapter 3: Understanding Excel Files 75\u003c\/p\u003e \u003cp\u003eChapter 4: Essentials of Spreadsheet Application Development 97\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II: Understanding Visual Basic for Applications\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 5: Introducing Visual Basic for Applications 119\u003c\/p\u003e \u003cp\u003eChapter 6: VBA Programming Fundamentals 177\u003c\/p\u003e \u003cp\u003eChapter 7: Working with VBA Sub Procedures 227\u003c\/p\u003e \u003cp\u003eChapter 8: Creating Function Procedures 269\u003c\/p\u003e \u003cp\u003eChapter 9: VBA Programming Examples and Techniques 317\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III: Working with UserForms\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 10: Custom Dialog Box Alternatives 395\u003c\/p\u003e \u003cp\u003eChapter 11: Introducing UserForms 417\u003c\/p\u003e \u003cp\u003eChapter 12: UserForm Examples 453\u003c\/p\u003e \u003cp\u003eChapter 13: Advanced UserForm Techniques 491\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV: Advanced Programming Techniques\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 14: Developing Excel Utilities with VBA 543\u003c\/p\u003e \u003cp\u003eChapter 15: Working with Pivot Tables 565\u003c\/p\u003e \u003cp\u003eChapter 16: Working with Charts 583\u003c\/p\u003e \u003cp\u003eChapter 17: Understanding Excel’s Events 645\u003c\/p\u003e \u003cp\u003eChapter 18: Interacting with Other Applications 685\u003c\/p\u003e \u003cp\u003eChapter 19: Creating and Using Add-Ins 711\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V: Developing Applications\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 20: Working with the Ribbon 743\u003c\/p\u003e \u003cp\u003eChapter 21: Working with Shortcut Menus 779\u003c\/p\u003e \u003cp\u003eChapter 22: Providing Help for Your Applications 801\u003c\/p\u003e \u003cp\u003eChapter 23: Developing User-Oriented Applications. 821\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI: Other Topics\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 24: Compatibility Issues 837\u003c\/p\u003e \u003cp\u003eChapter 25: Manipulating Files with VBA 851\u003c\/p\u003e \u003cp\u003eChapter 26: Manipulating Visual Basic Components 885\u003c\/p\u003e \u003cp\u003eChapter 27: Understanding Class Modules 911\u003c\/p\u003e \u003cp\u003eChapter 28: Working with Colors 927\u003c\/p\u003e \u003cp\u003eChapter 29: Frequently Asked Questions about Excel Programming 953\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VII: Appendixes\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAppendix A: VBA Statements and Functions Reference 989\u003c\/p\u003e \u003cp\u003eAppendix B: VBA Error Codes 999\u003c\/p\u003e \u003cp\u003eAppendix C: This Book’s Website 1003\u003c\/p\u003e \u003cp\u003eIndex 1019\u003c\/p\u003e \u003cp\u003e\u003cb\u003eJohn Walkenbach\u003c\/b\u003e, arguably the foremost authority on Excel, has written 50+ books, including multiple editions of the bestselling \u003ci\u003eExcel Bible\u003c\/i\u003e and \u003ci\u003eExcel Formulas,\u003c\/i\u003e as well as more than 300 articles for publications such as \u003ci\u003ePC World, InfoWorld\u003c\/i\u003e, and \u003ci\u003eWindows.\u003c\/i\u003e He created the award-winning Power Utility Pak and provides Excel information and insight at www.spreadsheetpage.com.\u003c\/p\u003e  \u003cp\u003e\u003cb\u003e\u003ci\u003eLearn to extend Excel 2013 with VBA programming\u003c\/i\u003e\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhether your job or your curiosity impels you to learn how to develop programs that automate and enhance Excel, you'll find no better teacher than John Walkenbach. This book provides a complete introduction to Visual Basic for Applications and shows you exactly how to create the custom dialog boxes known as UserForms. Then it takes you into advanced programming techniques, such as developing utilities and using VBA to work with PivotTables and charts.\u003c\/p\u003e \u003cp\u003eYou'll also learn to create user-oriented applications, modify shortcut menus, and provide online help for your applications. If you know your way around Excel and are ready to take your skills to the next level, this book is for you.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e\u003ci\u003eLet Mr. Spreadsheet show you how to:\u003c\/i\u003e\u003c\/b\u003e\u003c\/p\u003e \u003cul\u003e \u003cli\u003e\u003cb\u003eDevelop VBA subroutines and functions\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eCreate custom UserForms and dialog boxes\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eUse VBA to create add-ins, PivotTables, and charts\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eCreate procedures that execute automatically when events occur\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eWork with class modules and color\u003c\/b\u003e\u003c\/li\u003e \u003c\/ul\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989181645029,"sku":"NP9781118490396","price":55.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781118490396.jpg?v=1761783114","url":"https:\/\/k12savings.com\/es\/products\/excel-2013-power-programming-with-vba-isbn-9781118490396","provider":"K12savings","version":"1.0","type":"link"}