ChatGPT & AI for Microsoft Excel Boosting Your Excel Productivity with AI: Unlocking ChatGPT, Power Query & Smart Formulas

27 Nov, 2025, CONCORDE HOTEL KUALA LUMPUR

Register Now
PDF Brochure

IPA Training is Registered with

Learn from the Best

Morgan holds a Degree in IT & Tech Management from UTM, he has 20 years working experience as a trainer in the field of Information Technology. He has obtained ITIL Certification and also PSMB approved trainer (TTT). He has conducted various trainings. His key expertise are:

  • Conducting IT Training in the area of Basic Networking, PC Repairing, PC Troubleshooting & Microsoft Office Training
  • Conducting research on the latest development and requirement for training based on customer request Developing & Maintaining a sound marketing strategy
  •  Ensure KPI and Customer Satisfaction are meet

 

As a qualified professional educator, he has personally designed and delivered many specialized training courses including the validation and management of over 10 other trainers, operating nationwide in Malaysia.
As a qualified professional educator, he has personally designed and delivered many specialized training courses including the validation and management of over 10 other trainers, operating nationwide in Malaysia. He's also a well sought after consultant and works on several key IT projects each year, with leading brands in the region.

 

Venue Details

CONCORDE HOTEL KUALA LUMPUR
2 Jalan Sultan Ismail, 50250 Kuala Lumpur, Malaysia,
Phone : 03 2144 2200

https://kualalumpur.concorde hotelsresorts.com/

Contact us

Juliany,
03 2283 6109
juliany@ipa.com.my

Phoebe,
03 2283 6100
phoebe@ipa.com.my 

FOR CUSTOMISED IN-HOUSE TRAINING
Jane,
03 2283 6101
Jane@ipa.com.my

ADDRESS 
A-28-5, 28th Floor, Menara UOA Bangsar, 
No.5, Jalan Bangsar Utama 1, 
59000 Kuala Lumpur
www.ipa.com.my

FOCUSING ON
  • Section 1: Introduction To The ChatGPT & AI For Microsoft Excel Course
  • Section 2: Built-In Excel AI Tools
  • Section 3: Getting Started With ChatGPT For Excel
  • Section 4: Using ChatGPT For Excel Formulas
  • Section 5: Advanced Formulas With ChatGPT For Excel
OVERVIEW

This course is designed to integrate the power of ChatGPT with Excel to increase your productivity and efficiency in managing data and performing complex tasks.

Through this course, you will learn how to use built-in AI tools in Excel, as well as how to leverage ChatGPT to generate formulas, analyze data, and automate repetitive tasks.

At the end of this course, you will be able to combine the strengths of both AI tools to streamline your Excel workflows.

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Understanding the fundamentals of integrating ChatGPT with Excel.
  2. Exploring built-in AI tools in Excel, such as Flash Fill and Power Query.
  3. Learning how to generate Excel formulas using ChatGPT.
  4. Mastering Advanced Excel techniques with the assistance of AI.
  5. Applying these techniques in real-world scenarios to boost efficiency.
WHO SHOULD ATTEND
  • Anyone who uses Excel and wants to work faster
    with AI
  • Data or Business Analysts
  • Managers who need quick, data-driven insights
  • Trainers and Educators teaching Excel skills
  • Administrative staff handling repetitive data tasks
  • Level of understanding: Intermediate.
METHODOLOGY
  • Guided Learning, group-paced, hands-on classroom training with real life examples for business
    applications.
  • Challenging exercises are set based on practical applications for typical organizational functions such as HR, Admin, Production, Sales etc.
COURSE CONTENT
9:00

Section 1: Introduction to the ChatGPT & AI for Microsoft Excel Course

  • Welcome & Overview
  • Introduction to the course objectives and structure.
  • How to get the most out of this course.
  • Resource Downloads
  • Download the “ChatGPT for Excel” eBook.
  • Access sample files for practice.
10.45

Section 2: Built-In Excel AI Tools

  • Introduction to AI Tools in Excel
  • Brief overview of AI features available within Excel.
  • Flash Fill for Fast Data Manipulation
  • How to use Flash Fill to automate data entry tasks.
  • Let Excel Write Formulas for You
  • Utilize Excel’s AI to generate formulas automatically.
  • Column From Examples in Power Query
  • Use Power Query to create columns based on examples.
  • Create Data Insights with Analyze Data in Excel
  • Analyze data quickly and generate insights using AI.
  • Practice Exercise & Quiz
  • Hands-on practice and a quiz on using Analyze Data.
12.00

Section 3: Getting Started with ChatGPT for Excel

  • How to Get ChatGPT
  • Instructions on accessing and using ChatGPT.
  • ChatGPT 3.5 vs. ChatGPT 4
  • Differences between the two versions and their implications.
  • Using ChatGPT with Excel
  • Practical application of ChatGPT for Excel- related tasks.
  • Practice Exercise & Quiz
  • Practice scenarios and a quiz about ChatGPT functionalities.
1:00 Lunch
2:00

Section 4: Using ChatGPT for Excel Formulas

  • Using ChatGPT with Excel Formulas
  • Introduction to creating Excel formulas using ChatGPT.
  • Asking ChatGPT for Simple Formulas
  • Examples of simple formula creation via ChatGPT.
  • Using ChatGPT with Excel Tables
  • Integration of ChatGPT with Excel tables.
  • Advanced Formula Creation
  • Developing more complex formulas with ChatGPT.
  • Practice Exercise
  • Hands-on practice to reinforce learning.
3:45

Section 5: Advanced Formulas with ChatGPT for Excel

  • Deep Dive into Complex Formulas
  • Detailed exploration of advanced Excel formulas aided by ChatGPT.
  • Error Fixing & Commenting
  • Techniques for troubleshooting formulas
    and adding annotations.
  • Comprehensive Practice Exercise
  • Advanced exercises to solidify skills learned
5:00 End of Course