Excel programming : your visual blueprint for creating interactive spreadsheets /
A great guide to Excel programming that is perfect for visual learners and takes you beyond Excel basics! This book is the perfect reference for Excel users who want to delve deeper into the application to create powerful and dynamic programs. From creating macros to customizing dialog boxes, this s...
Clasificación: | Libro Electrónico |
---|---|
Autor principal: | |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
Indianapolis, IN :
Wiley Pub.,
©2010.
|
Edición: | 3rd ed. |
Colección: | Visual blueprint.
|
Temas: | |
Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Using macros and form controls
- Using the Visual Basic Editor
- Introducing Visual Basic for Applications
- Introducing the Excel object model
- Understanding arrays
- Controlling program flow
- Using Excel worksheet functions
- Debugging macros
- Working with workbooks and files
- Working with worksheets
- Defining ranges
- Working with lists
- Creating dialog boxes and customizing the ribbon
- Working with charts
- Working with pivottables
- Automating procedures with Excel events
- Building add-ins
- Understanding XML
- Appendix. VBA quick reference.