Amazon cover image
Image from Amazon.com

Mastering advanced Excel - with ChatGPT integration : learn formulas and functions, advance pivot tables, macros, VBA coding, ChatGPT integration with exercises / Ritu Arora.

By: Material type: TextTextLanguage: English Publication details: New Delhi : BPB Publications , 2023.Description: xxv, 278 pages : illustrations ; 24 cmISBN:
  • 9789355518651
Subject(s): DDC classification:
  • 005.54 ARO
Contents:
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.
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Call number Status Date due Barcode
Books Institute of Public Enterprise, Library S Campus 005.54 ARO (Browse shelf(Opens below)) Available 50799
Books Institute of Public Enterprise, Library S Campus 005.54 ARO (Browse shelf(Opens below)) Checked out 04/05/2026 50800
Books Institute of Public Enterprise, Library S Campus 005.54 ARO (Browse shelf(Opens below)) Available 50801

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.

There are no comments on this title.

to post a comment.

Maintained and Designed by
2cqr automation private limited, Chennai. All Rights Reserved.

You are Visitor Number

PHP Hits Count