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
22 Advanced Userform Techniques
25 Customizing the Ribbon to Run Macros
27 An Introduction to Creating Apps for Office