Microsoft Excel Tutorial: First Look at Copilot in Excel, recorded late August 2024
In today’s video, I dive into my very first experience with the new Copilot feature in Excel on Windows. This is exciting stuff, folks! Imagine Bobby Moynihan’s SNL characters bringing some sass to Excel—because that’s exactly what it felt like working with this tool! 😄 Copilot has some cool new tricks up its sleeve, like no longer needing your data to be in a table format. It can now work with regular ranges, making things so much easier for all of us Excellers.
We’re talking about features like Suggest a Formula, Show Data Insights, Add Conditional Formatting, and even answering your complex data questions. But hey, it’s not all smooth sailing. I ran into some interesting quirks—like Copilot claiming it can’t handle pivot tables or create pie charts, and then… surprise… it actually does! 🍕 Or is that a “pizza chart”? 😜
I also share some fun experiments, like asking Copilot for the top three customers in the manufacturing sector, and it’s a mixed bag—sometimes it gets it right, other times, well, let’s just say Copilot’s got some personality. 😂 But the potential here is huge, and I’m excited to keep testing and pushing its limits.
There’s so much more to explore, and I’ll be sharing my findings in upcoming videos. Stay tuned for more insights and a deeper dive into what Copilot can do—because, trust me, this is just the beginning. And don’t forget to check out our new merch below the video. Perfect for you or your favorite Excel enthusiast!
🔔 Subscribe, like, and hit that notification bell so you don’t miss out on any future Copilot adventures! 🔔
Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/
Fun Excel t-shirts and mugs: https://mrexcel-shop.fourthwall.com/collections/excel-t-shirts?source=dashboard
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/
Table of Contents
(0:00) Please click Like
(0:11) Bobby Moynihan’s Drunk Uncle is on my mind today
(0:28) Copilot in Windows version of Excel as of August 2024
(0:38) Works with regular range
(1:00) Four things Copilot can do
(1:10) Asking copilot for top 10 customers in one sector
(1:30) Disappointed that it chose Quantity instead of Revenue
(2:00) Ask Copilot a follow up question
(2:40) Admiring the pivot table created by Copilot
(3:08) Copilot is surly and tells me it can’t work on a pivot table
(3:33) Ask for Pie Chart for One Year of the Data
(3:59) Copilot says it can not create a pie chart
(4:31) Surly question: Hey Copilot, Why can’t you create a pie chart?
(4:43) Copilot CAN create a pie chart
(4:55) Is Copilot just PRETENDING so people use less pie charts?
(5:32) Adding the Pie Chart to a new sheet
(5:51) Is it a Circle Graph?
(6:11) Still in preview. It will get better.
(6:59) New Excel Shirts and Mugs
(7:10) Like, Subscribe, Ring the Bell
#microsoft365 #pivottable #pivot_table #excelpivot #excelpivottablestutorial #powerpivot #excelunpivot #AI #getpivotdata #pivotchart #copilot
This video answers these common search terms:
Excel Copilot first look
How to use Copilot in Excel
Excel AI features 2024
Copilot Excel tutorial
Excel Copilot demo
Excel Copilot new features
Microsoft Excel Copilot review
Excel AI formula suggestions
Does Excel Copilot hate pie charts
Excel 2024 updates Copilot
Continue this discussion at MrExcel: https://www.mrexcel.com/board/threads/excel-copilot-first-look-august-2024-episode-2648.1263612/