CHAPTER 1 Unleashing the power of Excel with VBA
CHAPTER 2 This sounds like BASIC, so why doesn’t it look familiar?
CHAPTER 4 Looping and flow control
CHAPTER 6 Creating and manipulating names in VBA
CHAPTER 9 Creating classes and collections
CHAPTER 10 Userforms: An introduction
CHAPTER 11 Data mining with Advanced Filter
CHAPTER 12 Using VBA to create pivot tables
CHAPTER 14 Sample user-defined functions
CHAPTER 16 Data visualizations and conditional formatting
CHAPTER 17 Dashboarding with sparklines in Excel 2019
CHAPTER 18 Reading from and writing to the web
CHAPTER 19 Text file processing
CHAPTER 21 Using Access as a back end to enhance multiuser access to data
CHAPTER 22 Advanced userform techniques
CHAPTER 23 The Windows Application Programming Interface (API)
CHAPTER 25 Customizing the ribbon to run macros
CHAPTER 27 An introduction to creating Office add-ins