Webinar on

MS-Excel with ChatGPT & AI

On

20th May 2025

11:00 AM to 05:00 PM

By

Mr. Pradeep K

Microsoft Certified Professional & Data Analyst

This program is design to help users integrate ChatGPT with Microsoft Excel effectively. It provides a systematic guide to understanding ChatGPT's setup, options, and limitations, making it accessible even for those new to AI tools. Participants will learn how to use ChatGPT for tasks like sorting data, designing tables, creating charts, and automating calculations, all while enhancing productivity and professional results. This program is designed for executives who want to learn Advance features of Excel with CHAT GPT that help in improving their efficiency of working with worksheet, analyzing data, creating MIS reports for various tasks

ROI on Training: -

By the end of the course, participants will have a strong foundation in

VLOOKUP, Advance VLOOKUP, Index-Match

Calculation on Dynamic Pivot Table

Filter data using slicers in multiple pivot tables

Date Grouping (PivotTables) etc.

Work with CHAT GPT AI Tool

Dashboard Creation by using CHAT GPT

Course Contents

Module-01: Introduction to Excel 2019/365

ü Shortcut, Excel Tips & Tricks

 

Module 02: Lookup and Reference Function  

ü VLOOKUP, ADVANCE VLOOKUP, HLOOKUP,

ü INDEX, MATCH, XLOOKUP, TEXTJOIN

 

Module 03: Pivot Tables

ü Creating pivot tables, using pivot tables options, Changing and updating data range

ü Formatting pivot tables and making dynamic pivot tables

ü Advance Pivot techniques Show Report Filter Pages

ü First & Last Service Date, Insert Calculated Field

 

Module 04: CHAT GPT in Excel

ü How to use  chat GPT to solve the problem

ü ChatGPT Basics

ü Add Chat GPT to Excel

ü Improve Your Responses

ü Art of the Ask

ü Excel with ChatGPT

ü How to write a Prompt to solve Excel Basic to Complex Problems

ü Create Dynamic Dashboard by using CHAT GPT

Profile of Faculty

Mr. Pradeep K - Microsoft Certified Professional & Data Analyst

Microsoft Certified Trainer with 17+ Years’ experience in Training, Data Analysis & MIS Reporting. Proficient in Advance Excel (LOOKUPs, Pivot Table /Charts, VBA Macros and BI Tools) and Advance PowerPoint (Business Presentation and Advance Animation).

Highly motivated trainer with experience in training small and large groups across diverse industries. Proven success in leveraging educational theories and methodologies to design, develop, and deliver successful training programs and integrate instructional technology to provide onsite and virtual training

He also worked as Corporate Trainer at HCL Infosystems Ltd. and as a Software Engineer at Matrix Soft Pvt. Ltd.

He is expert in Data Analysis using Excel, Chat GPT, Solver, Histogram, Pareto Chart, Power Pivot, Power View, Power Query, BI Tools and VBA Macro, Advance PowerPoint, Data Visualization & Storytelling, MS-Office , OFFICE 365, Programming Language C, C++, Java, VBA Macro, MySQL, MS-Access, Google Sheet and Open Office (Libre & Apache)

Pre-requisites

You should have good internet connection and good quality headphone/speaker set with Laptop.

You should have notepad/pen to note down important points.

How to Register:

Fees: Per person

Rs. 5000/-

USD 81

18% GST is applicable

> Mode of Payment: NEFT /Paytm / Credit Card/ GPAY

> Fees include certificate of participation & Course Material.

*Terms & Conditions apply

 

Best regards

For GFORD Institute of Management Pvt Ltd

Piyush Verma

For Booking seats Email us : gfordseminar@outlook.com 

Mob. : 9711114779 / 9315556407

For Query and nominations – 9540012349 only Whatsapp

 

For unsubscribe from the mailing list, please mail us on deletemailgford@gmail.com