TY  - BOOK
AU  - Arora, Ritu
TI  - Mastering advanced Excel - with ChatGPT integration : : learn formulas and functions, advance pivot tables, macros, VBA coding, ChatGPT integration with exercises 
SN  - 9789355518651
U1  - 005.54 
PY  - 2023///
CY  - New Delhi
PB  - BPB Publications
KW  - Microsoft Excel
KW  - Electronic spreadsheets
KW  - Artificial intelligence
KW  - ChatGPT
N1  - 1. Overview of excel 2021 --  2. Cell references and range -- 3. Working with formulas and functions --  4. Data validation -- 5. Protection -- 6. Sorting a database -- 7. Filtering a database -- 8. Subtotals and data consolidation -- 9. Pivot tables -- 10. Conditional formatting -- 11. What-if-analysis -- 12. Working with multiple worksheets, workbooks and applications -- 13. Working with charts -- 14. Creating and recording macros in VBA -- 15. Assigning buttons to macros -- 16. Functions and subroutines in VBA -- 17. Conditional statements in VBA -- 18. Variables and data types in VBA -- 19. Looping structures in VBA -- 20. Arrays and collections in VBA -- 21. Debugging and error handling in VBA -- 22. User forms and user input in VBS -- 23. Advanced VBA techniques and best practices -- 24. Building custom add-ins with VBA -- 25. ChatGPT with excel
ER  -