Microsoft Excel 2016 Power Programming with VBA
Paperback Engels 2016 1e druk 9781119067726Samenvatting
Become a power user with VBA
Take your Excel skills to the next level by harnessing the power of the VBA language. This comprehensive resource will help you automate data processes and develop full featured Excel programs. Fully updated for the newest release of Excel, this one-of-a-kind resource presents everything you need to develop both large and small Excel applications.
This book was designed with you in mind, giving you straight facts without hype or unnecessary explanations. This book offers tips, tricks and practical examples complete with all the code and sample templates you need to start your journey from humble data analyst to Excel programming pro.
Let Mr. Spreadsheet show you how to:
- Go beyond recording simple macros
- Dynamically manipulate workbooks and worksheets
- Automate pivot table and chart features
- Manage external data and wrangle external files
- Send emails directly from Excel
- Create your own Excel Ribbon interface
- Develop and distribute your own Excel Add-ins
Visit the companion website to find files used as examples in the book.
Specificaties
Lezersrecensies
Inhoudsopgave
Part I: Introduction to Excel VBA
1. Essentials of Spreadsheet Application Development
2. Introducing Visual Basic for Applications
3. VBA Programming Fundamentals
4. Working with VBA Sub Procedures
5. Creating Function Procedures
6. Understanding Excel’s Events
7. VBA Programming Examples and Techniques
Part II: Advanced VBA Techniques
8. Working with Pivot Tables
9. Working with Charts
10. Interacting with Other Applications
11. Working with External Data and Files
Part III: Working with UserForms
12. Leveraging Custom Dialog Boxes
13. Introducing UserForms
14. UserForm Examples
15. Advanced UserForm Techniques
Part IV: Developing Excel Applications
16. Creating and Using Add-Ins
17. Working with the Ribbon
18. Working with Shortcut Menus
19. Providing Help for Your Applications
20. Leveraging Class Modules
21. Understanding Compatibility Issues
Part V: Appendix
Appendix A: VBA Statements and Function Reference
Index
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan
