Jump to content

Michael Alexander - Excel 2019 Power Programming with VBA


tetox

Recommended Posts

Hidden Content

    Give reaction to this post to see the hidden content.

Book: Excel 2019 Power Programming with VBA
Author(s): Michael Alexander, d*ck Kusleika
Publisher: Wiley
Tags: Excel, VBA Techniques, Spreadsheets.
Year: 1st Edition (April 22, 2019)
Print Length: 784 pages
Format: EPUB
Language: English
ISBN-10: 1119514924
ISBN-13: 9781119514923
Size: 28 MB (RAR)

Book Description
Maximize your Excel experience with VBA
Excel 2019 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2019. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features.

Understanding how to leverage VBA to improve your Excel programming skills can enhance the quality of deliverables that you produce—and can help you take your career to the next level.

Explore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniques

Contents:

  • Cover
  • Introduction
  •     Topics Covered
  •     What You Need to Know
  •     What You Need to Have
  •     Conventions Used in This Book
  •     What the Icons Mean
  •     How This Book Is Organized
  •     How to Use This Book
  •     What's on the Website
  • Part I: Introduction to Excel VBA
  •     CHAPTER 1: Essentials of Spreadsheet Application Development
  •     CHAPTER 2: Introducing Visual Basic for Applications
  •     CHAPTER 3: VBA Programming Fundamentals
  •     CHAPTER 4: Working with VBA Sub Procedures
  •     CHAPTER 5: Creating Function Procedures
  •     CHAPTER 6: Understanding Excel's Events
  •     CHAPTER 7: VBA Programming Examples and Techniques
  • Part II: Advanced VBA Techniques
  •     CHAPTER 8: Working with Pivot Tables
  •     CHAPTER 9: Working with Charts
  •     CHAPTER 10: Interacting with Other Applications
  •     CHAPTER 11: Working with External Data and Files
  • Part III: Working with UserForms
  •     CHAPTER 12: Leveraging Custom Dialog Boxes
  •     CHAPTER 13: Introducing UserForms
  •     CHAPTER 14: Looking at UserForm Examples
  •     CHAPTER 15: Implementing Advanced UserForm Techniques
  • Part IV: Developing Excel Applications
  •     CHAPTER 16: Creating and Using Add-Ins
  •     CHAPTER 17: Working with the Ribbon
  •     CHAPTER 18: Working with Shortcut Menus
  •     CHAPTER 19: Providing Help for Your Applications
  •     CHAPTER 20: Leveraging Class Modules
  •     CHAPTER 21: Understanding Compatibility Issues
  • Part V: Appendix: VBA Statements and Functions Reference
  • Index
  • End User License Agreement

Hidden Content

    Give reaction to this post to see the hidden content.

Thanks to BitBook.

Edited by Bad Karma
Dead links removed
  • Like 1
Link to comment

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
×
×
  • Create New...