TY  - BOOK
AU  - Jelen, Bill
TI  - VBA and Macros: Microsoft Excel 2010
SN  - 978-0-7897-4314-5
U1  - JelV 
PY  - 2010///
PB  - MrExcel 
KW  - Excel
KW  - Microsoft
KW  - Informática
N1  - 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.
ER  -