Jelen, Bill
VBA and Macros: Microsoft Excel 2010 Bill Jelen y Tracy Syrstad. - 1a ed. - MrExcel 2010 - 630 p. Contiene: Imágenes 23 cm.
Contiene: Introduction; Unleash the power of excel with VBA; This sounds like basic, so why doesn´t it look familiar?; Referring to ranges; User-defined functions; Looping an flow control; R1C1- Style formulas; What is new in excel 2010 and what has changed; Create and manipulate names in VBA; Event programming; Userforms: an introduction; Creating charts; Data mining with advanced filter; Using VBA to create pivot tables; Excel power; Data visualizations and conditional formatting; Reading from and writing to the web; Dashboarding with sparklines in excel 2010; Automating word; Array; Text file processing; Using Access as a back end to back enhance multiuser acess to data; Creating classes, records, and collections; Advanced userforms techniques; Windows API; Handling errors; Customizing the ribbon to run macros; Creating add-ins.
978-0-7897-4314-5
Excel
Microsoft
Informática
JelV / 005.3
VBA and Macros: Microsoft Excel 2010 Bill Jelen y Tracy Syrstad. - 1a ed. - MrExcel 2010 - 630 p. Contiene: Imágenes 23 cm.
Contiene: Introduction; Unleash the power of excel with VBA; This sounds like basic, so why doesn´t it look familiar?; Referring to ranges; User-defined functions; Looping an flow control; R1C1- Style formulas; What is new in excel 2010 and what has changed; Create and manipulate names in VBA; Event programming; Userforms: an introduction; Creating charts; Data mining with advanced filter; Using VBA to create pivot tables; Excel power; Data visualizations and conditional formatting; Reading from and writing to the web; Dashboarding with sparklines in excel 2010; Automating word; Array; Text file processing; Using Access as a back end to back enhance multiuser acess to data; Creating classes, records, and collections; Advanced userforms techniques; Windows API; Handling errors; Customizing the ribbon to run macros; Creating add-ins.
978-0-7897-4314-5
Excel
Microsoft
Informática
JelV / 005.3