Chapters in this book

1. Frontmatter i
2. Contents vii
3. Preface xxi
4. Acknowledgments xxv
5. About the Author xxvi
6. Chapter 1: Overview of Excel 2021 1
7. Chapter 2: Cell References and Range 19
8. Chapter 3: Working with Formulas and Functions 29
9. Chapter 4: Data Validation 47
10. Chapter 5: Protection 57
11. Chapter 6: Sorting a Database 65
12. Chapter 7: Filtering a Database 71
13. Chapter 8: Subtotals and Data Consolidation 79
14. Chapter 9: Pivot Tables 93
15. Chapter 10: Conditional Formatting 113
16. Chapter 11: What-if Analysis 121
17. Chapter 12: Working with Multiple Worksheets, Workbooks, and Applications 131
18. Chapter 13: Working with Charts 141
19. Chapter 14: Creating and Recording Macros in VBA 151
20. Chapter 15: Assigning Buttons to Macros 163
21. Chapter 16: Functions and Subroutines in VBA 179
22. Chapter 17: Conditional Statements in VBA 193
23. Chapter 18: Variables and Data Types in VBA 199
24. Chapter 19: Looping Structures in VBA 207
25. Chapter 20: Arrays and Collections in VBA 223
26. Chapter 21: Debugging and Error Handling in VBA 229
27. Chapter 22: User Forms and User Input in VBS 237
28. Chapter 23: Advanced VBA Techniques and Best Practices 245
29. Chapter 24: Building Custom Add-ins with VBA 257
30. Chapter 25: ChatGPT with Excel 261
31. Index 269