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
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.
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
$49.99
Mastering AI in 2026: ChatGPT, Claude, Agents & Automation
4.1 (1,384 Reviews)
Provider: Udemy
Time: 18.7h
$13.99
Complete Shopify Course: Build & Launch Your Online Store (2026)
4.4 (1,002 Reviews)
Provider: Udemy
Time: 10.4h
$19.99
LinkedIn B2B Sales Mastery: AI Lead Generation & Closing (2026)
4.1 (733 Reviews)
Provider: Udemy
Time: 12h
$64.99
AI for HR: ChatGPT Recruiting, Hiring & HR Automation (2026)
4.4 (468 Reviews)
Provider: Udemy
Time: 4.8h
$10.99
ChatGPT & Claude for HR: AI Hiring & Recruitment (2026)
4.2 (353 Reviews)
Provider: Udemy
Time: 7.3h
$10.99
More Office Productivity courses
AI-Powered Social Media Management: From Beginner to Pro (2025)
5.0 (211 Reviews)
Provider: Udemy
Time: 1.1h
$19.99
SUPERHUMAN 10X Productivity with AI: 75 Time Management Tips (2026)
4.9 (4,994 Reviews)
Provider: Udemy
Time: 13.7h
$94.99
Microsoft Word 2019 (MO 100) Study Guide to 1000 points
4.9 (451 Reviews)
Provider: Udemy
Time: 2.1h
$79.99
Microsoft Excel + AI: Go From Data Analysis to Visualization (2026)
4.9 (276 Reviews)
Provider: Udemy
Time: 3.8h
$10.99
Workshop 5: Access VBA, Design and Advanced Methods (2024)
4.9 (182 Reviews)
Provider: Udemy
Time: 2.2h
$64.99
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












