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
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
CHAPTER 18 Reading from the web using M and VBA
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 26 Creating Excel add-ins
CHAPTER 27 An introduction to creating Office add-ins