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.
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.
Listed for all levels, but it really suits beginners. No coding needed; Copilot or Python in Excel access helps later.
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
- 1Introduction 4 free previews8 lectures · 34 min
- 2Excel Fundamentals 1 free preview5 lectures · 1 quiz · 34 min
- 3Copilot, ChatGPT & AI Inside Excel6 lectures · 1 quiz · 16 min
- 4Build Your First Spreadsheet7 lectures · 1 quiz · 38 min
- 5Basic Excel Functions12 lectures · 2 quizzes · 35 min
- 6Solve Formula Problems With AI - [Updated September 2026]8 lectures · 53 min
- 7Changes to Excel Worksheet4 lectures · 1 quiz · 17 min
- 8Format Data Professionally5 lectures · 2 quizzes · 29 min
- 9Excel Lists and Data Management6 lectures · 1 quiz · 22 min
- 10Data Filtering and Analysis7 lectures · 1 quiz · 22 min
- 11Data Validation in MS Excel7 lectures · 2 quizzes · 29 min
- 12Flash Fill in MS Excel7 lectures · 26 min
- 13Clean Messy Data With AI [Updated Sep 2026]9 lectures · 1.2 hours
- 14Charts in Excel3 lectures · 2 quizzes · 13 min
- 15Excel Pivot Table7 lectures · 2 quizzes · 38 min
- 16Working with Conditional Functions7 lectures · 2 quizzes · 25 min
- 17Become an AI-Assisted Analyst [Updated Sep 2026] 3 free previews9 lectures · 1.1 hours
- 18Build Management Reports & Dashboards [Updated Sep 2026]7 lectures · 42 min
- 19Business & Financial Modeling With AI [Updated Sep 2026]7 lectures · 42 min
- 20Automate Excel Work With AI [Updated Sep 2026]5 lectures · 50 min
- 21Beyond Traditional Excel6 lectures · 45 min
- 22Excel Shortcuts Tips & Tricks14 lectures · 25 min
- 23Microsoft Copilot in Excel [Updated Sep 2026]5 lectures · 1.1 hours
- 24ChatGPT With Excel [Updated Sep 2026]5 lectures · 56 min
- 25Optional Excel Reference Library22 lectures · 1 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
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.
Instructor Details
- 4.4 Rating
1,108 Reviews
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.
More courses by Sawan Kumar
Canva AI Masterclass 2026: Magic Studio, AI Design & ChatGPT
4.5 (1,650 Reviews)
Provider: Udemy
Time: 31.4h
$11.99
Original priceMastering AI in 2026: ChatGPT, Claude, Agents & Automation
4.1 (1,384 Reviews)
Provider: Udemy
Time: 18.7h
$13.99
Original priceComplete Shopify Course: Build & Launch Your Online Store (2026)
4.4 (1,002 Reviews)
Provider: Udemy
Time: 10.4h
$11.99
Original priceLinkedIn B2B Sales Mastery: AI Lead Generation & Closing (2026)
4.1 (733 Reviews)
Provider: Udemy
Time: 12h
$11.99
Original priceAI Product Management: Strategy, Roadmaps & ChatGPT (2026)
4.3 (480 Reviews)
Provider: Udemy
Time: 13.5h
$19.99
AI for HR: ChatGPT Recruiting, Hiring & HR Automation (2026)
4.4 (468 Reviews)
Provider: Udemy
Time: 4.8h
$10.99
Original price
More Office Productivity courses
AI-Powered Social Media Management: From Beginner to Pro (2025)
5.0 (211 Reviews)
Provider: Udemy
Time: 1.1h
$11.99
Original priceMicrosoft Excel + AI: Go From Data Analysis to Visualization (2026)
4.9 (276 Reviews)
Provider: Udemy
Time: 3.8h
$10.99
Original priceGoogle Sheets Fundamentals (2021)
4.9 (177 Reviews)
Provider: Udemy
Time: 1.1h
$11.99
Original priceComplete Introduction to Google Sheets Pivot Tables (2026)
4.8 (3,570 Reviews)
Provider: Udemy
Time: 2.9h
$12.99
Original priceAchieve Inbox Zero Today! (2024)
4.8 (855 Reviews)
Provider: Udemy
Time: 36 mins
$11.99
Original priceMicrosoft Excel - Managing Personal Finances with Excel (2024)
4.8 (810 Reviews)
Provider: Udemy
Time: 3h
$11.99
Original price
Reviews
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.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 88 / 100












