Mastering advanced Excel-with chatgpt integration: Learn formulas and functions, advance pivot tables, macros, VBA coding chatgpt integration with exercises

By:

Arora, Ritu

Publication details: New Delhi: BPB Publications, 2023.Description: xxv, 278p., ind., 23 cm X 19 cmISBN:

978-9355518651

Subject(s):

-- microsoft excel (computer file) -- microsoft software -- chatgpt, an AI chatbot

DDC classification:

005.54

List(s) this item appears in: New Arrivals 6 November 2023

Tags from this library: No tags from this library for this title. Log in to add tags.

Average rating: 0.0 (0 votes)

Holdings ( 1 )
Title notes ( 2 )
Comments ( 0 )

Holdings
Item type	Current library	Call number	Materials specified	Status	Date due	Barcode
Books	KEIC	005.54 ARO (Browse shelf(Opens below))		Checked out	11/24/2023	22646

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

There are no comments on this title.

to post a comment.