Normal view MARC view ISBD view

Excel 2019 power programming with VBA / by Michael Alexander and Dick Kusleika, previously by John Walkenbach

By: Alexander, Michael.
Contributor(s): Kusleika, Dick.
Publisher: Indianapolis, I.N. : John Wiley & Sons, 2019Description: xl, 742 p. : ill; electronic resource.ISBN: 9781119514923.Subject(s): Accounting software | Excel | Data management | Information technologyOnline resources: Download as an eBook
Contents:
INTRODUCTION TO EXCEL VBA: Essentials of spreadsheet application development -- Introducing Visual Basic for applications -- VBA programming fundamentals -- Working with VBA sub procedures -- Creating function procedures -- Understanding Excel's events -- VBA programming examples and techniques. ADVANCED VBA TECHNIQUES: Working with pivot tables -- Working with charts -- Interacting with other applications -- Working with external data and files. WORKING WITH USERFORMS: Leveraging custom dialog boxes -- Introducing UserForms -- Looking at UserForm examples -- Implementing advanced UserForm techniques. DEVELOPING EXCEL APPLICATIONS: Creating and using add-ins -- Working with the ribbon -- Working with shortcut menus -- Providing help for your applications -- Leveraging class modules -- Understanding compatibility issues. APPENDIX: Appendix: VBA statements and functions reference.
Summary: Offers a complete introduction to Excel 2019 Visual Basic for Applications (VBA). Reveals how to leverage VBA to improve Excel programming skills. Offers tips, tricks and best practices and describes the interface, file formats, and the enhanced interactivity with other Office applications. Includes leverage templates and worksheets.
Item type Home library Call number URL Status Notes Date due Item reserves
EBook EBook International
EBL Ebook (Browse shelf) Link to resource eBook Available as an ebook here
Total holds: 0

INTRODUCTION TO EXCEL VBA: Essentials of spreadsheet application development -- Introducing Visual Basic for applications -- VBA programming fundamentals -- Working with VBA sub procedures -- Creating function procedures -- Understanding Excel's events -- VBA programming examples and techniques. ADVANCED VBA TECHNIQUES: Working with pivot tables -- Working with charts -- Interacting with other applications -- Working with external data and files. WORKING WITH USERFORMS: Leveraging custom dialog boxes -- Introducing UserForms -- Looking at UserForm examples -- Implementing advanced UserForm techniques. DEVELOPING EXCEL APPLICATIONS: Creating and using add-ins -- Working with the ribbon -- Working with shortcut menus -- Providing help for your applications -- Leveraging class modules -- Understanding compatibility issues. APPENDIX: Appendix: VBA statements and functions reference.

Offers a complete introduction to Excel 2019 Visual Basic for Applications (VBA). Reveals how to leverage VBA to improve Excel programming skills. Offers tips, tricks and best practices and describes the interface, file formats, and the enhanced interactivity with other Office applications. Includes leverage templates and worksheets.

© 2017 Chartered Accountants Australia and New Zealand ABN 50 084 642 571 (CA ANZ).
Formed in Australia. Members of CA ANZ are not liable for the debts and liabilities of CA ANZ

Powered by Koha

Powered by Koha