PART I: EXCEL VBA PRIMER 1: Excel Macros: A Quick Start in Excel VBA Programming 2: Excel Programming Environment: A Quick Overview of its Tools and Features (VBE) 3: Excel VBA Fundamentals: A Quick Reference to Writing VBA Code 4: Excel VBA Procedures: A Quick Guide to Writing Function Procedures 5: Adding Decisions to Excel VBA Programs: A Quick Introduction to Conditional Statements 6: Adding Repeating Actions to Excel VBA Programs: A Quick Introduction to Looping Statements 7: Storing Multiple Values in Excel VBA Programs :A Quick Introduction to Working with Arrays 8: Keeping Track of Multiple Values in Excel VBA Programs: A Quick Introduction to Creating and Using Collections 9: Excel Tools for Testing and Debugging: A Quick Introduction to Testing VBA Programs PART II: MANIPULATING FILES AND FOLDERS WITH VBA 10: File and Folder Manipulation with VBA 11: File and Folder Manipulation with Windows Script Host (WSH) 12: Using Low-Level File Access PART III: CONTROLLING OTHER APPLICATIONS WITH VBA 13 Using Excel VBA to Interact with Other Applications 14: Using Excel with Microsoft Access PART IV: ENHANCING THE USER EXPERIENCE 15: Event-Driven Programming 16: Using Dialog Boxes 17: Creating Custom Forms 18: Formatting Worksheets with VBA 19: Context Menu Programming and Ribbon Customizations 20: Printing and Sending Email from Excel PART V: EXCEL TOOLS FOR DATA ANALYSIS 21: Using and Programming Excel Tables 22: Programming PivotTables and PivotCharts 23: Getting and Transforming Data in Excel PART VI: TAKING CHARGE OF PROGRAMMING ENVIRONMENT 24: Programming the Visual Basic Editor (VBE) 25: Calling Windows API Functions from VBA PART VII: ADVANCED CONCEPTS IN EXCEL VBA 26: Creating Classes in VBA PART VIII: WORKING TOGETHER: VBA, HTML, XML, AND THE REST API 27: HTML Programming and Web Queries 28: Using XML in Excel 2021 29: Excel and Rest API Index.