Excel's Major Upgrade: Copilot AI Tutorial 🤖

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
- Sample Excel workbook to follow along: https://kevstrat-my.sharepoint.com/:x:/g/personal/admin_kevstrat_onmicrosoft_com/EZrFnuUdpRREj1o1bNVBBKABFMc5LXUiXqvAx4PPhf8q7A?e=FCJ7Zg

⌚ 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
- Playlist with all my videos on Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME
- Official website: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/

🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 📹 CapCut | https://bit.ly/installcapcut
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr
✅ 💵 Quickbooks Online | https://bit.ly/intuitquickbooksonline
✅ 👥 Hubspot | https://hubspot.sjv.io/DKo6jb
✅ 📈 Semrush | https://bit.ly/semrush14dayfreetrial
✅ 🎥 Descript | https://get.descript.com/sf22jb63w2tx
✅ 🏓 Smartsheet | https://bit.ly/trysmartsheet

🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz

⚖ 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