Microsoft Excel With AI: ChatGPT, Copilot & Analysis (Udemy.com)
Learn Excel basics, formulas, formatting, data cleaning, analysis, Copilot workflows, and ChatGPT case studies for real
Created by: Sawan Kumar
Last updated September 2026
What you will learn
- Understand Excel basics and how spreadsheets are used in real work.
- Launch Excel, use the startup screen, and understand the Excel home screen.
- Create, save, and work with new Excel sheets.
- Enter data, create titles, use cell references, and build basic formulas.
- Use common Excel functions such as SUM, AVERAGE, MIN, MAX, AutoSum, and AutoFill.
- Use AI to turn business questions into Excel formulas.
- Understand inherited formulas and fix broken Excel formulas.
- Format spreadsheets with fonts, colors, borders, and conditional formatting.
- Use ChatGPT and AI to improve Excel projects.
- Use AI to audit messy datasets before cleaning them.
- Clean names, categories, locations, dates, numbers, and formats.
- Detect duplicates, conflicting records, missing values, and suspicious data.
- Extract useful information from messy text.
- Classify large sets of records automatically.
Course Description
Excel is no longer just a spreadsheet tool.
Today, Excel is used for formulas, reports, data cleaning, business analysis, dashboards, decision-making, and AI-powered workflows. With tools like ChatGPT and Microsoft Copilot, Excel users can work faster, ask better questions, clean messy data, understand formulas, and find insights inside business data.
But there is a problem.
Most beginners either learn Excel the old way without AI, or they try to use AI without understanding the spreadsheet basics. Both approaches are weak.
This course brings both together.
You will start with Excel fundamentals: launching Excel, understanding the home screen, creating and saving workbooks, entering data, using cell references, building basic formulas, using common functions, formatting spreadsheets, and working with rows, columns, and conditional formatting.
Then you will learn how AI changes the way Excel work gets done.
You will use ChatGPT and AI to turn business questions into formulas, understand inherited formulas, fix broken formulas, audit messy datasets, clean names and categories, standardize dates and numbers, detect duplicates, find missing data, extract information from messy text, and classify large sets of records.
You will also learn how to move from basic spreadsheet work into analysis. You will ask better business questions, find what is growing or declining, identify best and worst performers, detect anomalies, compare periods and segments, analyze customers and products, and turn analysis into management insights.
The course also includes updated sections on Microsoft Copilot in Excel and ChatGPT with Excel. You will see practical case studies for repairing broken workbooks, building management reports, analyzing data with Copilot and Python, auditing unfamiliar workbooks, finding the story in 5,000 transactions, and stress-testing a financial model.
This is a practical Excel course for modern learners. You will not just learn buttons and formulas. You will learn how to think, check, analyze, and use AI properly inside Excel.
By the end, you will be able to use Excel more confidently and use ChatGPT, Copilot, and AI as assistants for formulas, cleaning, analysis, and business reporting.
Instructor Details
- 4.0 Rating
160 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
Microsoft Excel Masterclass With ChatGPT, Copilot & AI (2026)
4.4 (1,108 Reviews)
Provider: Udemy
Time: 15h
$10.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
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 Rohit Jatt on 12/20/2025
this was good and made excel easy for me , i learned a lot from here.
By Kartik Mishra on 4/13/2025
provides good start to excel for absolute beginners
By Carolyn Sue Skaggs on 3/28/2025
Very informative and paced correctly.
By ARUN SATISH on 1/21/2025
This guy showed nothing about ChatGPT, I lost Rs 499 while starting the course and now it is free. I want my money back
By Amaan Anwar Ahmed Khan on 10/22/2024
The name of the course is fraud. He is mentioning "with the power of AI and ChatGPT" but he is just showing the viewers the basic functions of excel and putting paragraphs prompted by chatgpt for reference. Nothing is displayed as per Chatgpt or AI. Very bad.
By Hathika .V on 10/20/2024
I was enjoying the learning of shortcuts keys
By Nammina Dattatreya on 10/12/2024
The sir is telling good and understand what sir saying.
By Ghulam Nabi on 9/26/2024
Yes, it was simple but an addition to my knowledge
By Muhammad Ullah on 9/17/2024
Its an amazing course and i learn new things about excel.
By Familusi Moyosore Ebenezer on 9/11/2024
I’m pretty much enjoy it. The tutor is explanatory enough
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 80 / 100












