Excel Copilot Tutorial - Excel’s Biggest Upgrade Ever

Microsoft Excel just got a game-changing upgrade with Copilot, your AI-powered assistant! In this video, I’ll show you how to leverage Copilot to write formulas, clean data, analyze feedback, generate charts, and even build full dashboards—all with simple prompts. If you've ever struggled with Excel functions or spent hours manually analyzing data, Copilot will revolutionize your workflow.

In This Video, You’ll Learn:
✔️ How to enable & access Copilot in Excel
✔️ Automate tasks like filling in missing data & cleaning up spreadsheets
✔️ Generate formulas & advanced calculations effortlessly
✔️ Create interactive dashboards & charts with AI
✔️ Use Python in Excel for next-level data analysis

Host: Kevin Stratvert

📚 RESOURCES

⌚ TIMESTAMPS
00:00 - Introduction to Excel Copilot
00:28 - How to Get Copilot
01:08 - Where to Find Copilot
01:58 - Automate Lookup Functions
04:56 - Clean Data
07:15 - Fill in Missing Data
07:41 - Extract Data
08:05 - Generate & Use Custom Formulas
08:27 - Apply Conditional Formatting
08:55 - Sort Data
09:29 - Filter Data
10:00 - Summarize Data
10:43 - Visualize Data with Charts
11:10 - Analyze Sentiment for Feedback Visualization
11:38 - Generate a Word Cloud with Python
13:39 - Build AI-Powered Dashboards with Python
14:48 - How to Enable Python in Excel
15:02 - Explore Copilot’s Prompt Gallery
15:55 - Wrap Up

📺 RELATED VIDEOS

📩 NEWSLETTER

🔽 CONNECT WITH ME

🎁 TOOLS AND DISCOUNTS

🎒 MY COURSES

🙏 REQUEST VIDEOS

🔔 SUBSCRIBE ON YOUTUBE

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert #excel #copilot

[Bupa-bt]

Great, Kevin. Thank you. My only problem is that I'm retired and don't have a boss to impress. But I still love Excel. ❤❤❤

[ralphpayne]

Brilliant summation of how anyone can now be an Excel "expert"!

[vincentho]

Nice tutorial. I could share this with my co-workers who are completely novice to Excel.

Personally as someone who is already proficient in Excel, I find it much faster and more efficient at writing formulas on my own.

And honestly for analysis, it feels like it’s just throwing stuff at the wall to see what sticks—random fields, random charts, it generates 8 maybe 1 is correct. It gets even worse when it can’t make sense of anything beyond basic stuff like price, quantity, or revenue.

[gmargenka]

Kevin this was great!!! More stuff like this with Copilot and Excel!!!

[Lorenzog]

Thank you for this tutorial. Can you provide the original Spreadsheet so that we can follow along. The one in your SPO site is already updated and edited. Thank you and great video.

[trietluong]

Great guidance for using Microsoft Copilot in Excel. Thanks so much

[RiminiVirage]

Excellent explanatory video, thank you very much for taking the time, really worth watching as always.

[nyusemotech]

Thanks a lot Kevin, this is super amazing. AI is doing the job for everyone.

[francesdobbins]

Great tutorial on using Copilot in Excel. Thanks, Kevin

[daniboi]

I've found that CP is good for those completely new to Excel; however intermediate/advanced users are much quicker at just doing the steps or writing the formulas themselves.

[rezafarzipoorsaen]

Great Kevin. Can you please explain how we can use Copilot in Solver in Excel? That will be so useful.

[dasanyum]

This looks Magical 😮! Excellent innovation and presentation

[hayab_u]

Great! Please do more videos about Python in Excel: And also more videos about other tools for data analysis ❤❤

[nikol]

What a wonderful video for Excel lovers !

[weston.weston]

This is soooo good, thank you, Kevin.

[guebbouh]

That's very informative. Thank you again

[dianna]

very excellent video. thank you for sharing.

[darimages]

Awesome Kevin. Thanks for the tutorial. You rock!

[mateuszkosecki]

Simply amazing! Thank you for this very useful video.

[MRQirex]

Great vid, so well explained, congrats :)