VBA and macros Microsoft Excel 2010 / Bill Jelen, Tracy Syrstad.
Material type:
Computer fileSeries: Computer | MrExcel libraryPublication details: New Delhi Pearson Education c2012.Description: 630p. PBISBN: - 9781282852136
- 005.54 JEB V book
- 005.54 JEB V book
| Item type | Current library | Call number | Status | Notes | Date due | Barcode | Item holds | |
|---|---|---|---|---|---|---|---|---|
Books
|
Suresh Gyan Vihar University Library | 005.54 JEB V (Browse shelf(Opens below)) | Available | DE | J109 |
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
eBook access via Internet. ANU/ANV.
There are no comments on this title.
