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 › Certificate in Advanced Excel + AI › Course content

Classroom training · Kemps Corner & Bandra (W)

Advanced Excel + AI (ChatGPT & Co-Pilot) Course Syllabus

25 hours · Classroom training · Free demo session

Unlock the seamless integration of AI with Excel: from streamlining tasks to mastering advanced features and automating processes. Microsoft Copilot brings generative AI into Microsoft 365, turning Excel, Word, PowerPoint, Outlook and Teams into intelligent productivity partners.

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

Microsoft tools you'll learn

  • Advanced Excel
  • ChatGPT
  • Copilot
  • Pivot Tables
  • Macros
  • Data cleaning

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

Full course content

19 modules, 74 topics.

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)
  • VLOOKUP with Exact Match, Approximate Match
  • Nested VLOOKUP with Exact Match
  • VLOOKUP with Tables, Dynamic Ranges
  • Using VLOOKUP to consolidate Data from Multiple Sheets
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
  • Formatting and customizing Pivot tables
  • Using advanced options of Pivot tables
  • Pivot charts
  • Consolidating data from multiple sheets and files using Pivot tables
  • Using external data sources
  • Using data consolidation feature to consolidate data
  • Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)
  • Viewing Subtotal under Pivot
  • Creating Slicers ( Version 2010 & Above)
7

Advanced Excel - More Functions

  • Date and time functions
  • Text functions
  • Database functions
  • Power Functions (CountIf, CountIFS, SumIF, SumIfS)
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
  • Using Bar and Line Chart together
  • Using Secondary Axis in Graphs
  • Sharing Charts with PowerPoint / MS Word, Dynamically
  • (Data Modified in Excel, Chart would automatically get updated)
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.
  • Getting started guide.
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.
  • Utilize ChatGPT to write lookup formulas and formulas from image data.
  • Collaborate with ChatGPT to develop advanced Excel formulas and understand complex ones.
  • Improve existing formulas and troubleshoot with the aid of your ChatGPT assistant.
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.
  • Utilize ChatGPT for writing and understanding complex VBA code.
  • Easily add comments and improve macro code with ChatGPT.
  • Debug and troubleshoot VBA code effectively.
  • Practice exercises for hands-on learning.
19

Final Assignment

  • The Final Assignment contains questions to be solved at the end of the Course
Certificate in Advanced Excel + AI: details, fees & free demo →

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 + AI on real computers with a trainer beside you, at our centres or at your company.

Advanced Excel + AI class with students at Compufield Bandra (W)
Bandra (W)
Advanced Excel + AI class with students at Compufield Bandra (W)
Bandra (W)
Advanced Excel + AI class with students at Compufield Bandra (W)
Bandra (W)
Corporate Advanced Excel + AI training for a company team in Mumbai
Corporate training
Corporate Advanced Excel + AI 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 + AI 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 Certificate in Advanced Excel + AI

How long is the Certificate in Advanced Excel + AI?

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 (simple calculations, formatting and printing). No prior AI or programming knowledge required.

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 →