Kemps Corner (H.O) +91 98201 34058WhatsApp +91 98201 34058Bandra (W) +91 98333 61338
Classroom training since 1985 · Kemps Corner · Bandra (W)

Home › Courses › Office Automation › Advanced Excel with AI (ChatGPT & Co-Pilot)

Classroom training · Kemps Corner & Bandra (W)

Master Advanced Excel with AI, ChatGPT & Microsoft Copilot

25 hours · Classroom training · Free demo session

Automate formulas, data and reports with ChatGPT and Copilot. Hands-on with a trainer beside you, at Kemps Corner or Bandra (W).

  • 25 hrs classroom training
  • Fee ₹12,000
  • Free demo session
Online sessions available

Microsoft tools you'll learn

  • Advanced Excel
  • ChatGPT
  • Microsoft Copilot
  • Power Query
  • VBA with ChatGPT
  • Data analysis

Book your FREE Demo Session

We'll call you back to fix a time at Kemps Corner, Bandra (W) or online.

Your details go only to Compufield. We'll call you, no spam.

Course content

What you'll learn

Advanced Excel with AI, ChatGPT and Co-Pilot: Mastering Productivity and Automation. Unlock the integration of AI with Excel, from streamlining tasks to mastering advanced features and automating processes, for Excel users of all levels.

1

Advanced Excel - Overview of the Basics of Excel

Customizing common options in Excel. · Absolute and relative cells. · Protecting and un-protecting worksheets and cells.

2

Advanced Excel - Working with Functions

Writing conditional expressions (using IF) · Using logical functions (AND, OR, NOT) · Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX) · +4 more

3

Advanced Excel - Data Validations

Specifying a valid range of values for a cell · Specifying a list of valid values for a cell · Specifying custom validations based on formula for a cell

4

Advanced Excel - Working with Templates

Designing the structure of a template · Using templates for standardization of worksheets

5

Advanced Excel - Sorting and Filtering Data

Sorting tables, Using multiple-level sorting, Using custom sorting · Filtering data for selected view (AutoFilter) · Using advanced filter options

6

Advanced Excel - Working with Reports

Creating subtotals · Multiple-level subtotals · Creating Pivot tables · +9 more

7

Advanced Excel - More Functions

Date and time functions · Text functions · Database functions · +1 more

8

Advanced Excel - Formatting

Using auto formatting option for worksheets · Using conditional formatting option for rows, columns and cells

9

Advanced Excel - Macros

Relative & Absolute Macros · Editing Macros

10

Advanced Excel - WhatIf Analysis

Goal Seek · Data Tables · Scenario Manager

11

Advanced Excel - Charts

Using Charts · Formatting Charts · Using 3D Graphs · +4 more

12

Advanced Excel - New Features Of Excel

Sparklines, Inline Charts, data Charts · Overview of all the new features

13

Excel AI & Co-Pilot: Introduction to AI Tools in Excel

Discover the potential of AI tools within Excel.

14

Excel with AI & Co-Pilot: Powering Up Excel with ChatGPT

Utilize Column From Examples in Power Query. · Quickly generate data insights with Analyze Data in Excel.

15

Excel with AI & Co-Pilot: Getting Started with ChatGPT

Learn how to access and utilize ChatGPT effectively. · Introduction to ChatGPT and its versions. · ChatGPT 3.5 and ChatGPT 4 Differences. · +1 more

16

Excel with AI & Co-Pilot: Unlock the power of ChatGPT for Excel formulas

Easily request simple Excel formulas from ChatGPT. · Seamlessly integrate ChatGPT with Excel tables. · Advance your skills by fixing errors, adding comments, and exploring more complex formulas. · +3 more

17

Excel with AI & Co-Pilot: Streamline data cleaning and transformation processes

Convert PDF data with ease. · Transform complex Excel files seamlessly. · Practice exercises for reinforcement.

18

Excel with AI & Co-Pilot: Unlock the potential of ChatGPT in Excel macros

Date and time functions · Learn the basics of macros with ChatGPT. · Dive into event procedures in Excel VBA. · +4 more

19

Final Assignment

The Final Assignment contains questions to be solved at the end of the Course

Advanced Excel with AI (ChatGPT & Co-Pilot): Mastering Productivity →

By the end of this course you can

  • Enhance Excel proficiency by integrating ChatGPT and Copilot
  • Master advanced Excel features like Pivot Tables and formulas
  • Automate tasks and streamline data cleaning with ChatGPT
  • Optimise Excel formulas with ChatGPT's help
  • Stay updated with the latest Excel and ChatGPT advancements
  • Create custom solutions for unique Excel challenges

Who this course is for

  • Excel users, data analysts and business professionals
  • Anyone who wants to automate work with AI

Before you start: Familiarity with basic Excel operations such as simple calculations, formatting and printing.

Fees and options

Fees and related courses

This course is highlighted. Every course starts with a free demo session.

Fees shown are for classroom training at Kemps Corner and Bandra (W). Live online sessions have different fees: call or WhatsApp +91 98201 34058 (Kemps Corner) or +91 98333 61338 (Bandra (W)).

Explore all AI coursesChatGPT, Claude, Copilot and Generative AI courses on one page.AI courses →

Inside our classrooms

Real classrooms. Real trainers.

Learn Advanced Excel with AI (ChatGPT & Co-Pilot) on real computers with a trainer beside you, at our centres or at your company.

Advanced Excel with AI (ChatGPT & Co-Pilot) class with students at Compufield Bandra (W)
Bandra (W)
Advanced Excel with AI (ChatGPT & Co-Pilot) class with students at Compufield Bandra (W)
Bandra (W)
Advanced Excel with AI (ChatGPT & Co-Pilot) class with students at Compufield Bandra (W)
Bandra (W)
Corporate Advanced Excel with AI (ChatGPT & Co-Pilot) training for a company team in Mumbai
Corporate training
Corporate Advanced Excel with AI (ChatGPT & Co-Pilot) training for a company team in Mumbai
Corporate training

Free demo session

Book your FREE Demo Session

Visit us at Kemps Corner or Bandra (W), or join online. Call or WhatsApp the centre nearest you.

For companies

Corporate Advanced Excel with AI (ChatGPT & Co-Pilot) training

We run these courses as corporate workshops and training programmes for company teams, at your office or at our centres.

  • Training at your office (client location)
  • MS Office, Excel and MIS training for company teams
  • Customised content for your industry and data
  • Copilot for Microsoft 365 for your teams

Train your team

Tell us your team size and the tools you use. We'll suggest a workshop that fits.

Corporate workshops in action. Led by Faiyaz M Khairaz, Microsoft Certified Trainer, with 22+ years of corporate training.

Student reviews

What our students say

Read all reviews on Google ↗
★★★★★
I have completed my course in diploma in MS office + generative AI. Good institution with teachers.
Vedant S.MS Office + Generative AI · Sep 2026 · Google review
★★★★★
Great place to learn MS office with AI. The trainers over here are really very helpful and are very…
Taha M.MS Office with AI · Sep 2026 · Google review
★★★★★
I completed my ms office + advance excel + tally course from this institute, would recommend this…
Saba Q.MS Office, Advanced Excel & Tally · Aug 2026 · Google review
★★★★★
Great place to learn digital courses, I have recently completed my Advanced Excel with AI course…
Sukanya B.Advanced Excel with AI · Aug 2026 · Google review
★★★★★
Completed my Advance excel course with AI recently from here.. the course was quite helpful for my…
Raj S.Advanced Excel with AI · Aug 2026 · Google review
★★★★★
I recently completed the Advanced AI, Excel & PowerPoint course through online classes at…
Sk Shabir A.AI, Excel & PowerPoint · Online · Jul 2026 · Google review

Questions about the Advanced Excel with AI (ChatGPT & Co-Pilot)

How long is the Advanced Excel with AI (ChatGPT & Co-Pilot)?

25 hours of classroom training at Kemps Corner or Bandra (W), with a trainer beside you.

What are the fees?

₹12,000 for classroom training. Live online sessions have different fees, so please call Kemps Corner on +91 98201 34058 or Bandra (W) on +91 98333 61338.

What should I know before joining?

Familiarity with basic Excel operations such as simple calculations, formatting and printing.

Are classes in the classroom or online?

Both. Classroom training at Kemps Corner and Bandra (W). Live online sessions are run by both centres and have different fees.

Can I try a class before joining?

Yes. Every course starts with a free demo session.

Do you train company teams?

Yes. We run this course as a corporate workshop at your office.

Book your FREE Demo Session

Kemps Corner · Bandra (W) · Online sessions available

WhatsApp us
WhatsApp usFree Demo
Chat with us on WhatsApp

What would you like to learn? We'll reply on +91 98201 34058.

Start WhatsApp chat →