01860nam a2200289 a 4500 vtls000056545 KUKTEM 20251125093156.0 111202t2010 inua f 001 0 eng d 9780789743145 (pbk.) 0789743140 (pbk.) 201302041655 Fida 201211291002 jamie 201211290956 jamie 201210021550 asmadi 201112021137 sri UMP HF5548.4.M523 J456 2010 Jelen, Bill VBA and macros : Microsoft Excel 2010 / Bill Jelen, Tracy Syrstad Indianapolis, Ind. : Que Pub, 2010 xviii, 630 p. : ill. ; 24 cm. MrExcel library 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 Business Computer programs Electronic spreadsheets Syrstad, Tracy MrExcel library 0 0 0 0 20000 20000 2019-09-04 122.45 0 HF5548.4.M523 J456 2010 0000067024 2019-09-04 00:00:00 1 122.45 2019-09-04 OPEN VIRTUA40 62112 62118 VTLSSORT0080*0200*0201*0400*0900*1000*2450*2600*3000*4900*5000*5050*6500*6501*7000*8300*9992