Requires Authorization
Advanced Excel 365
Including ChatGPT Tips
Frontmatter
Contents
Preface
Acknowledgments
About the Author
Chapter 1: Overview of Excel 2021
Chapter 2: Cell References and Range
Chapter 3: Working with Formulas and Functions
Chapter 4: Data Validation
Chapter 5: Protection
Chapter 6: Sorting a Database
Chapter 7: Filtering a Database
Chapter 8: Subtotals and Data Consolidation
Chapter 9: Pivot Tables
Chapter 10: Conditional Formatting
Chapter 11: What-if Analysis
Chapter 12: Working with Multiple Worksheets, Workbooks, and Applications
Chapter 13: Working with Charts
Chapter 14: Creating and Recording Macros in VBA
Chapter 15: Assigning Buttons to Macros
Chapter 16: Functions and Subroutines in VBA
Chapter 17: Conditional Statements in VBA
Chapter 18: Variables and Data Types in VBA
Chapter 19: Looping Structures in VBA
Chapter 20: Arrays and Collections in VBA
Chapter 21: Debugging and Error Handling in VBA
Chapter 22: User Forms and User Input in VBS
Chapter 23: Advanced VBA Techniques and Best Practices
Chapter 24: Building Custom Add-ins with VBA
Chapter 25: ChatGPT with Excel
Index
Keywords
Frontmatter
Contents
Preface
Acknowledgments
About the Author
Chapter 1: Overview of Excel 2021
Chapter 2: Cell References and Range
Chapter 3: Working with Formulas and Functions
Chapter 4: Data Validation
Chapter 5: Protection
Chapter 6: Sorting a Database
Chapter 7: Filtering a Database
Chapter 8: Subtotals and Data Consolidation
Chapter 9: Pivot Tables
Chapter 10: Conditional Formatting
Chapter 11: What-if Analysis
Chapter 12: Working with Multiple Worksheets, Workbooks, and Applications
Chapter 13: Working with Charts
Chapter 14: Creating and Recording Macros in VBA
Chapter 15: Assigning Buttons to Macros
Chapter 16: Functions and Subroutines in VBA
Chapter 17: Conditional Statements in VBA
Chapter 18: Variables and Data Types in VBA
Chapter 19: Looping Structures in VBA
Chapter 20: Arrays and Collections in VBA
Chapter 21: Debugging and Error Handling in VBA
Chapter 22: User Forms and User Input in VBS
Chapter 23: Advanced VBA Techniques and Best Practices
Chapter 24: Building Custom Add-ins with VBA
Chapter 25: ChatGPT with Excel
Index
Keywords