Skip to content
UdemyOffice ProductivityPaid courseBeginner levelCertificate

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

icon
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.

icon
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.

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

$49.99

$13.99

$10.99

$19.99

$64.99

$10.99

icon
More Office Productivity courses

$19.99

$94.99

$79.99

$10.99

$64.99

$39.99

icon
Reviews

4.0

160 ratings on Udemy

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

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

Showing all 10 reviews on CourseDuck

Read all 160 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 : 80 / 100