PLEASE CLICK HERE to view upcoming event. Information here is outdated

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

27 Nov, 2025, CONCORDE HOTEL KUALA LUMPUR

IPA Training is Registered with

Venue Details

CONCORDE HOTEL KUALA LUMPUR
2 Jalan Sultan Ismail, 50250 Kuala Lumpur, Malaysia, - 50250

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