Jelen, Bill

Excel 2013 VBA and Macros / Bill Jelen and Tracy Syrstad - 612 p. 18 x 23 cm. 2 ejemplares

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. .



Excel 2013 [Programa para computador]
Hoja electrónica [Programa para computador]
Microsoft Excel 2013 [Programa para computador]
Programación [Computadores electrónicos]
Visual Basic [Lenguaje de programación computadores]

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