TY  - DATA
AU  - Jelen,Bill
AU  - Syrstad,Tracy
ED  - Safari Books Online.
TI  - VBA and macros: Microsoft Excel 2010 
T2  - MrExcel library
SN  - 9781282852136
AV  - 005.54 JEB V book
U1  - 005.54 JEB V 
PY  - 2012///
CY  - New Delhi
PB  - Pearson Education
KW  - Microsoft Excel (Computer file)
KW  - Microsoft Visual Basic for applications
KW  - Business
KW  - Computer programs
KW  - Electronic spreadsheets
N1  - Includes index; 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 and flow control -- R1C1-style formulas -- What's 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 -- Arrays -- Text file processing -- Using Access as a back end to enhance multi-user access to data -- Creating classes, records, and collections -- Advanced userform techniques -- Windows API -- Handling errors -- Customizing the ribbon to run macros -- Creating add-ins; DE
UR  - https://virtual.anu.edu.au/login/?url=https://www.safaribooksonline.com/library/view/title/9780789744142/?ar
ER  -