Excel Copilot First Look August 2024 - Episode 2648

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! 🔔

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

[GrainneDuggan_Excel]

Bill that is hilarious! I can't do that, I really can't do that, told you I can't do that, Oh, I did that....

[Excelambda]

The interaction was absolutely fun, super cool !!
Excel human expertise will still be needed for a truly brief period, only to check if AI delivers correct answers, then will completely fade away.

question 1: Hey copilot, can you deal with quantum field equations?
copilot: I don't deal with quantum field anything
question 2: Why ??
copilot: Now I do 😀

[ricos]

Refusing to do things, and making up lazy excuses? I'd say that is a fairly realistic employee.

[richardhay]

The key to using ANY AI is being very explicit in prompting.

[analysiscloud]

I wonder if the column had been entitled Sales or Income instead of Revenue copilot would have got the first question right?! I did a review of co-pilot in Excel and gave it a rating of 3 / 10.

[gnbyrne]

Really does nothing of usefulness at this point esp with what MS are charging. No doubt will get better but will need a lot of time before any semi competent user will see benefit.