Normal view MARC view ISBD view
Tipo: materialTypeLabelLibro - General
Ubicación Física: 005.3 / J48

Excel 2013 VBA and Macros /

Autor: Jelen, Bill.
Otros Autores: Syrstad, Tracy.
Pié de imprenta: Indianapolis : Pearson Education, 2013.
Descripción: 612 p. 18 x 23 cm.
ISBN: 9780789748614.
Tema(s):
Contenido: Introduction. Unleash the Power of Excel with VBA. This sounds Like BASIC, so why doesn't look familiar? Refering ranges. Looping and flow control. R1C1-Style formulas. Create and manipulate names in VBA. Event programming. Arrays. Creating classes, records, and collections. User forms: an introduction. Data mining with advanced filter. Using VBA to create pivot tables. Excel Power. Sample user-defined functions. Creating charts. Data visualizations and conditional formatting. Dashboarding with sparklines in Excel 2013. Reading from and writing to the web. Text file processing. Automating word. Using access as a back end to enhance multiuser access to data. Advanced user form techniques. Windows API. Handling errors. Customizing the Ribbon to run Macros. Creating Add-Ins. An introduction to creating Apps for office. What is new Excel 2013 and what has changed. .

Tags from this library: No tags from this library for this title. Log in to add tags.
    average rating: 0.0 (0 votes)
Item type Current location Collection Call number Copy number Status Date due Barcode
Libro - General Libro - General Biblioteca UCATOLICA
Carrera 13
Colección General 005.3 / J48 (Browse shelf) Ej. 1 Available (Acceso Libre) 55026
Libro - General Libro - General Biblioteca UCATOLICA
Carrera 13
Colección General 005.3 / J48 (Browse shelf) Ej. 2 Available (Acceso Libre) 55027

Introduction. Unleash the Power of Excel with VBA. This sounds Like BASIC, so why doesn't look familiar? Refering ranges. Looping and flow control. R1C1-Style formulas. Create and manipulate names in VBA. Event programming. Arrays. Creating classes, records, and collections. User forms: an introduction. Data mining with advanced filter. Using VBA to create pivot tables. Excel Power. Sample user-defined functions. Creating charts. Data visualizations and conditional formatting. Dashboarding with sparklines in Excel 2013. Reading from and writing to the web. Text file processing. Automating word. Using access as a back end to enhance multiuser access to data. Advanced user form techniques. Windows API. Handling errors. Customizing the Ribbon to run Macros. Creating Add-Ins. An introduction to creating Apps for office. What is new Excel 2013 and what has changed. .

Sistemas

There are no comments for this item.

Log in to your account to post a comment.
Universidad Católica de Colombia
La Universidad Católica de Colombia es una Institución de Educación Superior sujeta a inspección y vigilancia por el Ministerio de Educación, reconocida mediante Resolución Número 2271 de julio 7 de 1970 del Ministerio de Justicia.
Universidad Católica de Colombia © Copyright 2017
Universidad Católica de Colombia • PBX: (57 1) 3 27 73 00 - (57 1) 3 27 73 33
Bogotá, Avenida Caracas # 46 -72, sede Las Torres • Bogotá, Carrera 13 # 47 – 30, Sede 4​ • Bogotá, Diagonal 46 A # 15 B – 10, sede El Claustro
Bogotá, Carrera 13 # 47 – 49, sede Carrera 13