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:
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 |