Programme on 'CHATGPT With Excel'
Context Setting
In
this training session, participants will be introduced to ChatGPT and AI for
Excel automation. They will learn the fundamentals of AI, ChatGPT, and how to
interact with it. Practical exercises will cover generating customized
formulas, automating repetitive tasks, and creating reports and dashboards
using ChatGPT in Excel. Troubleshooting and error handling will also be
explored. Participants will discover how to integrate Chat-GPT with Excel
add-ins and discuss its advantages, limitations, and alternative AI solutions.
The session aims to equip participants with the knowledge and skills to
streamline tasks, save time, and enhance productivity using ChatGPT and AI in
Excel.
Objective
<!--[if !supportLists]-->·
<!--[endif]-->Understand the fundamentals of AI and ChatGPT,
gaining insights into their capabilities and applications.
<!--[if !supportLists]-->·
<!--[endif]-->Learn how to effectively use ChatGPT in Excel,
including logging in, providing correct prompts, and extracting relevant
information through follow-up prompts.
<!--[if !supportLists]-->·
<!--[endif]-->Develop proficiency in generating customized
formulas with ChatGPT, enabling participants to perform complex calculations
and modify formulas to suit their Excel needs.
<!--[if !supportLists]-->·
<!--[endif]-->Discover how to automate routine tasks in Excel
using ChatGPT, such as data entry, formatting, and calculations, as well as
generating Excel formulas, macros, and VBA code.
Acquire
skills in generating reports, dashboards, summaries, charts, and visualizations
using ChatGPT, enabling effective communication of information and
troubleshooting Excel issues with the assistance of ChatGPT.
Key Takeaways
<!--[if !supportLists]-->1. Comprehensive understanding of AI and ChatGPT: Concepts and
potential applications of Artificial Intelligence and ChatGPT.
<!--[if !supportLists]-->2. Effective usage of ChatGPT in Excel: Interaction with ChatGPT and
extract relevant information.
<!--[if !supportLists]-->3. Customized formula generation: use ChatGPT to generate
personalized formulas and make complex calculations more accessible.
<!--[if !supportLists]-->4. Excel automation: Automate repetitive tasks, using ChatGPT, saving
time and effort.
<!--[if !supportLists]-->5. Report and dashboard generation: Create comprehensive reports,
dashboards, summaries, charts, and visualizations for effective data
communication.
<!--[if !supportLists]-->6. Troubleshooting and Error handling: Identifying and resolving
issues in Excel spreadsheets, formulas, and macros.
<!--[if !supportLists]-->7. Integration with Excel Add-ins: Integrate ChatGPT with existing
Excel add-ins for enhanced functionality.
<!--[if !supportLists]-->8. Awareness of limitations and alternatives: Insights into the
limitations of ChatGPT and explore other AI alternatives for specific use
cases.
<!--[if !supportLists]-->9. Versatility of ChatGPT: Beyond Excel,
understand other potential applications and domains where ChatGPT can be
utilized.
Participation Fees
Scale |
Per Participant fee |
GST @ 18% |
Total |
CII
Small Scale Members |
7,500.00 |
1,350.00 |
8,850.00 |
CII
Medium Scale Members |
8,000.00 |
14,40.00 |
9,440.00 |
CII
Large Scale Members |
8,500.00 |
1,530.00 |
10,030.00 |
Non-Members |
9,000.00 |
1,620.00 |
10,620.00 |
SPECIAL DISCOUNT10% on 3 or more nominations from an
organization
Who Should Attend / Target Audience
Venue
Online Microsoft Teams platform