In-house: | Face to Face:

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

18 Dec, 2026, Concorde Hotel Kuala Lumpur

Register Now PDF Brochure

IPA Training is Registered with

Learn from the Best

Mr Morgan holds a Degree in IT & Tech Management from UTM, he has 24 years working experience as a trainer in the field of Information Technology. He is a Microsoft Certified Trainer, Microsoft Certified Power BI Data Analyst & Microsoft Certified Office 365 Specialist & also obtained ITIL Certification. He is 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.

 

He has trained in Provater Sectors, Insurance led companies, MNCs, Government Ministries & Government agencies, among them are :

 

  • Thermos (M) Sdn Bhd
  • Prime Minister Office (PMO)
  • IKBN
  • JKR
  • PNS
  • Bank Negara Malaysia
  • Tenaga Nasional Bhd
  • MAHSA University
  • Ranhill
  • Alam Flora
  • REAL Education
  • Sime Tyres
  • Tawau Polytechnic
  • Dasmesh International School

Venue Details

Concorde Hotel Kuala Lumpur
2 Jalan Sultan Ismail, 50250 Kuala Lumpur, Malaysia,

https://kualalumpur.concorde hotelsresorts.com/


Phone : 03 2144 2200

Contact us

FOR COURSE DETAILS

Juliany,

Office: 03 2283 6109

Mobile: +60 122281247

juliany@ipa.com.my

Phoebe,

Office: 03 2283 6100

Mobile: +60 193637822

phoebe@ipa.com.my

Bee Teng,

Office: 03 2282 6112

Mobile: +60 172566121

beeteng@ipa.com.my

FOR CUSTOMISED IN-HOUSE TRAINING

Jane,

Office: 03 2283 6101

Mobile: +60 129418251

jane@ipa.com.my

Keith,

Office: 03 2283 0000

Mobile: +60 162272735

keith@ipa.com.my

ADDRESS

A-28-5, 28th Floor, Menara UOA Bangsar,
No.5, Jalan Bangsar Utama 1,
59000 Kuala Lumpur

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