VBA and macros Microsoft Excel 2010
AUTOMATE REPORTS BUILD FUNCTIONS VISUALIZE DATA WRITE FAST, RELIABLE SCRIPTS Microsoft Excel 2010 VBA AND MACROS: SAVE TIME AND SUPERCHARGE EXCEL 2010 WITH VBA AND MACROS! Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then lear...
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | eBook |
| Language: | English |
| Published: |
[Place of publication not identified]
Que Pub.
2010
|
| Series: | MrExcel library
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- 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