News

Faculty of Engineering and Technology Organized Workshop on Excel Using ChatGPT for Faculty Members

29 Jul 2026

The Faculty of Engineering & Technology organized a workshop on “Excel Using ChatGPT” on 25 July 2026 (from 2:00 pm to 4:00 pm) to enhance the digital productivity skills of faculty members. The expert Mr. Kartik Shukla (Technical Trainer) was trained different faculties from various department for Artificial Intelligence (AI) with Microsoft Excel to simplify data analysis, automate repetitive tasks, generate formulas, create reports, and improve overall efficiency in academic and administrative work. The session emphasized practical applications of ChatGPT for handling day-to-day Excel tasks, thereby promoting AI-assisted teaching, research, and documentation.

Workshop Highlights

The workshop covered both theoretical concepts and practical demonstrations. The following topics were discussed:

Introduction to Artificial Intelligence and ChatGPT

Effective Prompt Engineering for Excel

Generating Excel formulas using ChatGPT

Functions such as IF, SUMIF, COUNTIF, VLOOKUP, XLOOKUP, INDEX-MATCH, and TEXT functions

Data Cleaning and Formatting

Conditional Formatting

Sorting and Filtering

Creating Pivot Tables

Charts and Data Visualization

Automating repetitive Excel tasks using ChatGPT

Generating reports and summaries from datasets

Best practices for verifying AI-generated responses

Create Pivot Tables and charts for reporting.

Reduce the time required for repetitive Excel operations.

Utilize AI tools to improve academic and administrative productivity