Skip to content
UdemyOffice ProductivityPaid courseAll LevelsCertificate

Microsoft Excel Masterclass With ChatGPT, Copilot & AI (Udemy.com)

Learn Excel from scratch, then use ChatGPT, Copilot, AI, dashboards, PivotTables, formulas, data cleaning, automation

Created by: Sawan Kumar

Last updated September 2026

Our take

Based on the ratings of 1,108 students, a sample of their written reviews and the syllabus, as the course stood in September 2026. No course pays to be reviewed.

Sawan Kumar is a chartered accountant turned educator, and the course reads that way. It starts with the basics of Excel, such as formulas, formatting, sorting, validation, Flash Fill, charts and PivotTables, then moves into AI work: cleaning messy data, building dashboards and financial models, writing VBA and Office Scripts, and using Copilot and ChatGPT. It runs about 15 hours across 188 lectures, with 12 quizzes and 6 assignments. Despite the headline, roughly half the running time is plain beginner Excel and half is AI work.

Students like the pacing. Reviewers say it moves from beginner to advanced without feeling rushed, and several single out the hands-on exercises and the practical Copilot lessons. Others say the instructor explains difficult topics simply. The complaints are specific. Two reviewers say the audio is too quiet, and one says that makes it hard to follow. One experienced user found it too basic, and another said the AI methods took as long as doing the work by hand. The 1 and 2 star group is small, about 34 of 1,108 ratings.

The rating is 4.4 from 1,108 reviews, and about 5,900 students have enrolled. The AI sections were updated in September 2026, which matters because Copilot changes quickly. It is a sound pick for people new to Excel who want AI habits from the start. Experienced users should skim the early sections or look elsewhere. One student also could not find where to submit the first assignment, so expect a little friction there.

Best forExcel beginners who also want to use ChatGPT and Copilot for formulas, data cleaning and dashboards.
Skip it ifYou already use Excel daily and want advanced AI workflows; one reviewer found the class too basic for regular users.

Pros

  • Starts at the basics and builds up to dashboards, models and automation without feeling rushed
  • Hands-on projects such as a broken sales workbook, messy customer records and an executive dashboard
  • AI sections were refreshed in September 2026, so the Copilot and ChatGPT lessons are recent
  • Reviewers say the instructor explains hard topics in a simple, clear way

Cons

  • Audio is quiet: two reviewers say the volume is too low, and one could not follow it properly
  • Too basic for daily Excel users, and one reviewer says it was not made clear that the class starts from zero
  • One reviewer found the AI methods took no less time than doing simple tasks by hand
I really enjoyed the hands-on approach of this course. The exercises helped me understand how to actually use AI in Excel, not just learn theory.
Stephen Franks, a student

Listed for all levels, but it really suits beginners. No coding needed; Copilot or Python in Excel access helps later.

icon
What you will learn

  • Learn Microsoft Excel from beginner fundamentals.
  • Create, save, edit, and format Excel workbooks.
  • Enter data, use cell references, and build basic formulas.
  • Use common Excel functions such as SUM, AVERAGE, MIN, MAX, IF, COUNTIF, LEN, and CONCATENATE.
  • Sort, filter, validate, clean, and manage Excel data.
  • Use Flash Fill, Text to Columns, and data extraction techniques.
  • Create charts, PivotTables, PivotCharts, filters, and slicers.
  • Use conditional formatting and professional spreadsheet formatting.
  • Use ChatGPT and AI tools to solve Excel formula problems.
  • Use AI to understand, fix, and modernize inherited spreadsheets.
  • Clean messy data with AI and validate the results.
  • Analyze customers, products, trends, anomalies, and business performance.
  • Turn business questions into KPIs, summaries, reports, and dashboards.
  • Build executive dashboards and improve existing dashboards with AI.
  • Create business and financial models using AI assistance.
  • Analyze profitability, margins, budgets, actuals, scenarios, and sensitivities.
  • Generate VBA and Office Scripts with AI to automate Excel work.
  • Use Python-assisted analysis and Python in Excel for advanced workflows.
  • Use Microsoft Copilot in Excel for planning, editing, insights, and analysis.
  • Use ChatGPT with Excel to audit workbooks, find insights, and stress-test models.
  • Complete practical Excel and AI analyst projects.

Course content

25 sections · 188 lectures · 15 hours of video 12 quizzes, 6 assignments, 33 articles

  1. 1Introduction 4 free previews8 lectures · 34 min
  2. 2Excel Fundamentals 1 free preview5 lectures · 1 quiz · 34 min
  3. 3Copilot, ChatGPT & AI Inside Excel6 lectures · 1 quiz · 16 min
  4. 4Build Your First Spreadsheet7 lectures · 1 quiz · 38 min
  5. 5Basic Excel Functions12 lectures · 2 quizzes · 35 min
  6. 6Solve Formula Problems With AI - [Updated September 2026]8 lectures · 53 min
  7. 7Changes to Excel Worksheet4 lectures · 1 quiz · 17 min
  8. 8Format Data Professionally5 lectures · 2 quizzes · 29 min
  9. 9Excel Lists and Data Management6 lectures · 1 quiz · 22 min
  10. 10Data Filtering and Analysis7 lectures · 1 quiz · 22 min

Who it is for

The instructor says it suits

  • Beginners who want to learn Microsoft Excel from scratch.
  • Excel users who want to upgrade their skills with AI.
  • Students, professionals, freelancers, and business owners who use spreadsheets.
  • Accountants, finance professionals, analysts, managers, and operations teams.
  • Learners who want to use ChatGPT and Copilot with Excel.
  • Professionals who build reports, dashboards, trackers, customer lists, budgets, or management reports.
  • Anyone who wants to clean data, analyze business performance, and automate repetitive Excel work.
  • Learners who want a practical Excel course with projects, quizzes, assignments, and AI workflows.

What you need before you start

  • No advanced Excel experience is required.
  • Basic computer knowledge is helpful.
  • Access to Microsoft Excel is recommended.
  • Access to ChatGPT, Copilot, Claude, Gemini, or another AI tool is useful for the AI lessons.
  • Microsoft Copilot access is recommended for the Copilot section.
  • Python in Excel access is helpful for advanced analysis lessons, but not required for the beginner sections.
  • No coding background is required.
  • A willingness to practise with spreadsheets and check AI-generated answers.

How it compares

Against the other 480 rated Udemy courses in Office Productivity on CourseDuck:

  • Rating4.4 out of 5higher than 29% of them
  • Reviews1,108#130 of 481 by number of reviews
  • Length15 hourslonger than 89% of them
  • Last updatedSeptember 2026more recently than 94% of them

icon
Course Description

Recently reviewed by : 


Stephen

Rating: 5.0 out of 5

I really enjoyed the hands-on approach of this course. The exercises helped me understand how to actually use AI in Excel, not just learn theory.


Maphe J P

Rating: 5.0 out of 5

I liked how the course gradually moves from beginner to advanced level. ChatGPT helped me generate formulas and understand errors quickly. This course is a great investment for career growth.


and 1070+ more reviews from 5000+ learners


Microsoft Excel is no longer just a spreadsheet tool.

Today, Excel is used for business analysis, reporting, dashboards, data cleaning, financial modeling, automation, and decision-making. And with AI tools like ChatGPT, Microsoft Copilot, Python in Excel, VBA, and Office Scripts, Excel is becoming even more powerful.


But here is the problem.

Most Excel courses teach old Excel only. Most AI courses show random prompts without teaching real spreadsheet skills.


This course brings both together.

You will start from the basics of Excel: launching Excel, understanding the home screen, entering data, creating formulas, formatting spreadsheets, sorting, filtering, validation, Flash Fill, charts, PivotTables, conditional functions, and shortcuts.

Then you will move into modern AI-powered Excel workflows.


You will learn how to use AI to solve formula problems, clean messy datasets, repair broken workbooks, analyze business performance, build dashboards, create financial models, automate recurring tasks, generate VBA and Office Scripts, use Python-assisted analysis, work with Microsoft Copilot in Excel, and use ChatGPT as an Excel analysis partner.


This course is built for practical learning.

You will complete projects such as fixing a broken sales workbook, cleaning messy customer records, answering CEO-level business questions, building an executive sales dashboard, creating a 3-year business model, automating a monthly management report, and completing an AI Excel Analyst challenge.


The goal is not just to teach you Excel features. The goal is to help you become confident using Excel for real work.

By the end of this course, you will understand traditional Excel and modern AI-assisted Excel workflows. You will know when to use formulas, when to use PivotTables, when to use dashboards, when to use Copilot, when to use ChatGPT, and when AI output needs to be checked before you trust it.


If you want to learn Excel in a modern, practical, AI-powered way, this course is designed for you.


icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Sawan Kumar

Hi, I’m Sawan Kumar, a Chartered Accountant turned tech entrepreneur and educator. Over the past decade I’ve built a 50‑person IT company and coached 95,000+ learners worldwide on AI, Generative AI, Canva, Excel, LinkedIn marketing, and GoHighLevel automation. My courses blend financial expertise, technology, and design to help professionals boost productivity and grow their careers. Join my free community for weekly AI tools, templates, and business insights.

icon
More courses by Sawan Kumar

$11.99

Original price $49.9976% off

$13.99

Original price $22.9939% off

$11.99

Original price $19.9940% off

$11.99

Original price $64.9982% off

$19.99

$10.99

Original price $19.9945% off

icon
More Office Productivity courses

$11.99

Original price $19.9940% off

$10.99

Original price $19.9945% off

$11.99

Original price $39.9970% off

$12.99

Original price $64.9980% off

$11.99

Original price $64.9982% off

$11.99

Original price $19.9940% off

icon
Reviews

4.4

1,108 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Udemy User on 6/2/2026

The volume of the video just feels too low. Nothing else apart from that! It's great

By Michael OQuinn on 3/30/2026

This course exceeded my expectations. I started as a beginner, and now I feel confident using advanced Excel features along with ChatGPT. The AI integration part was incredibly useful.

By Adérito Paulo on 3/9/2026

This training covered everything I needed — from basic navigation to advanced automation with ChatGPT. I now handle Excel tasks faster and more effectively.

By Zakaria El Hallaoui on 2/9/2026

An excellent course for anyone who wants to master Excel with modern AI support. The real-life examples and AI-driven solutions helped me understand complex tasks easily.

By Agustina on 2/8/2026

Class is good and he is a good tutor but It was not mentioned at the beginning that this class is for those who are totally new to Microsoft Excel. So for those who have been using Excel day to day basis, this class is too basic.

By Leonardo Martinez on 2/7/2026

I never thought Excel could be this powerful until I took this course. The integration of AI tools like Copilot and ChatGPT saved me so much time and effort. The explanations were clear and beginner-friendly.

By Joan Jeyden on 2/7/2026

This course completely changed the way I use Excel. Starting from the basics and slowly moving to advanced topics with Copilot and ChatGPT made learning very easy and practical. Highly recommended for beginners and professionals.

By Maria Erlinda Bantigue Collado on 2/2/2026

iI alredy knew the basic and how to open from my laptop the excel and also have my own subsription from microsoft, so nothin to learn new from this only reminders. I was wrong! I've learned things that I did not know before like, the Concatenate, HEX Code of colours, the shortcuts or function that I have been using but do not know the name or call for it, using subtotal and sum of quantity for sorting and multiple sorting....but I have a hard time submitting assignments i do know if I am doing it correctly....I am not receiving feedback....

By Maphe J P Caulker on 1/11/2026

I liked how the course gradually moves from beginner to advanced level. ChatGPT helped me generate formulas and understand errors quickly. This course is a great investment for career growth.

By Tamim Iqbal on 1/10/2026

This course is an excellent blend of traditional Excel learning and modern AI tools like Copilot and ChatGPT. The lessons are well-structured and easy to follow, even for beginners. I especially liked how AI was used to simplify complex Excel formulas and tasks.

Showing all 10 reviews on CourseDuck

Read all 1,108 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 88 / 100