1 Unleashing the Power of Excel with VBA
2 This Sounds Like BASIC, So Why Doesn’t It Look Familiar?
6 Creating and Manipulating Names in VBA
9 Creating Classes 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 2016
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
23 The Windows Application Programming Interface (API)
25 Customizing the Ribbon to Run Macros
27 An Introduction to Creating Office Add-ins