Normal view MARC view ISBD view

Arora, Ritu

Mastering advanced Excel-with chatgpt integration: Learn formulas and functions, advance pivot tables, macros, VBA coding chatgpt integration with exercises - New Delhi: BPB Publications, 2023. - xxv, 278p., ind., 23 cm X 19 cm

Recommended by: Sumit Barad

Content:

Overview of Excel 2021
Cell References and Range
Working with Formulas and Functions
Data Validation
Protection
Sorting a Database
Filtering a Database
Subtotals and Data Consolidation
Pivot Tables
Conditional Formatting
What-if-Analysis
Working with Multiple Worksheets, Workbooks and Applications
Working with Charts
Creating and Recording Macros in VBA
Assigning Buttons to Macros
Functions and Subroutines in VBA
Conditional Statements in VBA
Variables and Data Types in VBA
Looping Structures in VBA
Arrays and Collections in VBA
Debugging and Error Handling in VBA
User Forms and User Input in VBS
Advanced VBA Techniques and Best Practices
Building Custom Add-ins with VBA
ChatGPT with Excel


ISBN: 978-9355518651

Subjects--Topical Terms: --microsoft excel (computer file)--microsoft software--chatgpt, an AI chatbot

Dewey Class. No.: 005.54