Contents at a Glance
1 Unleash the Power of Excel with VBA
2 This Sounds Like BASIC, So Why Doesn’t It Look Familiar?
6 Create and Manipulate Names in VBA
9 Creating Classes, Records, and Collections
11 Data Mining with Advanced Filter
12 Using VBA to Create Pivot Tables
14 Sample User-Defined Functions
16 Data Visualizations and Conditional Formatting
17 Dashboarding with Sparklines in Excel 2013
18 Reading from and Writing to the Web
21 Using Access as a Back End to Enhance Multiuser Access to Data
Get Excel® 2013 VBA and Macros now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.