Microsoft Excel 2016 Power Programming with VBA

Name: Microsoft Excel 2016 Power Programming with VBA
Author: John Walkenbach

Paperback Engels 2016 9781119067726

Verwachte levertijd ongeveer 8 werkdagen

60,35

In winkelwagen

Samenvatting

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

ISBN13:9781119067726

Trefwoorden:financiële rapportage, financiële verslaglegging, Spreadsheets, Programmeren, Microsoft, VBA (Visual Basic for Application), Excel 2016, Microsoft Excel 2016

Taal:Engels

Bindwijze:paperback

Aantal pagina's:729

Uitgever:Wiley Computing

Druk:1

Verschijningsdatum:30-3-2016

Hoofdrubriek:IT-management / ICT

ISSN:

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Schrijf een recensie

Geef uw waardering

Zeer goed Goed Voldoende Matig Slecht

Inhoudsopgave

Introduction

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