Honest review of Excel CoPilot - What it can and cannot do 🤖

Copilot for Excel is here (well, it is here for beta users and large corporate clients). So, in this video, let me show you what it can do, How I am using it and what some of the limitations are. Strap your seat belts and hold tight. This one is going to be a bumpy ride into the future of Artificial Intelligence and generative AI 🚀
⏱ In this video
=============
0:00 - CoPilot - How to activate and use it in Excel
1:22 - CoPilot Tab in Excel - what it can do?
2:00 - Using CoPilot to do preliminary analysis of data (EDA)
4:06 - Writing formulas with CoPilot
6:23 - CoPilot vs. ChatGPT for writing formulas
7:12 - Data analysis & insights with CoPilot
9:05 - Highlighting data with CoPilot
11:05 - The verdict - What I think about CoPilot for Excel
More on AI & Data Analysis:
=======================
Top 5 AI Features of Excel - • 10x your productivity ...
Using ChatGPT with Excel to make a dashboard - • DON'T tell my boss, bu...
Using AI to write DAX in Power BI - • What! We don't need to...
Using AI tools - Playlist: • Using AI tools with Da...
📁 Play with CoPilot yourself:
========================
Learn more and activate copilot for your team: learn.microsoft.com/en-us/mic...
Sample dataset to experiment: chandoo.org/wp/wp-content/upl...
~
#Copilot #Excel #ai #Chan2

[@akashhanchatet-2842]

Sir, you are Sir ! I really mean it ✨ Everytime I get a pop up saying "Chandoo added a video", I get happy ! And to be honest, I am in a learning phase of mine in the field of 'Data Analysis', you would definitely get the credits as soon as I enter the corporate. 🙏🏻 Love from India ❤️

[@whoamiherein]

Thanks a zillion. You deliver on point all the way. The depth and analysis you share is amazing. And to top it all your kindness in sharing knowledge. 🎉 Waking up to this from London

[@fardeenahmedkhan517]

Chandoo, I have been watching you for couple of months and you have been my mentor in my way of becoming a Data Analyst. A lot of Thanks for that. I left my Job to learn required skills properly like Excel, SQL, Power BI and Some Coding. I have been looking for some Pandas Tutorial but failed to find some really helpful one. I will really love and appreciate your efforts on making a playlist for PANDAS as well. Again a lots of Thanks for giving me a Way in my Career.

[@snackplaylove]

Hi - if you didn’t find it then HSMA (on KZbin) has some great python resources including Pandas. HSMA 5 will have reached that part, but HSMA 6 which is the latest version might not have got there yet.

[@atulpower1]

Was eagerly awaiting this.

[@abhilashn2993]

nice video. Thanks for sharing initial insight on Co-pilot...

[@chrism9037]

The possibilities here are very cool, thanks Chandoo!

[@chandoo_]

Agreed.

[@chanduycm]

Bagundi bro , good writing and acting ❤

[@buddyTalks123]

Nicely Explained thank you ! Subscribed !!!

[@venkatiyer7459]

As usual Useful one for all by the way Sir nice T Shirt of Pushpa

[@arbazahmad7177]

Great.... Excellent 🎉 intro about copilot.. And awesome 👌 t shirt... "Pushpa"

[@DamuReddy7]

Great video...thank you for sharing to us.

[@user-qp1fk8sq3l]

Thanks for posting some videos beyond the hype. Your finding align with my own. Especially the point that you can do most things faster if you have more than a beginner understanding of Excel and more important that if you have only a beginner understanding it will not serve you well since it will not neccessarily translate your query in what you mean, as it works best when you use the professional terminology beginners don't know. So a long way to go. But a start nonetheless.

[@Tony_Montana659]

Thanks ,Gr8 Info.

[@j.k6580]

great teaching

[@user-qs5xb6sd3x]

Why some functions such as sequence, filter, sort, unique and offset are not working displaying name error. Sometimes it works and sometimes not what the problem???pls help!!!!!!

[@ysantosh]

Pushpa😂 taggedele.. anna nice informative video on copilot.. thank u

[@chandoo_]

You are welcome Santosh...🙂

[@asim2676]

Hi, can i use copilot on excel 2021 or i need 365 office? Thanks

[@INDYEAH]

copilot taken literal english ' FILTER ' meaning in your query! You asked "Filter (exclude) all rows without email" and it did what you asked for

[@chandoo_]

That explains the mystery. But again, context is important part of a conversation. That fact that it is in "Excel", the result is disappointing.

[@kashishgupta3054]

Hi Chandoo, I wanted to know how can i add Copilot in my excel spreadsheet?

[@tinythings7976]

Content is amazing like Pushpa

[@steven871]

Will Copilot run solver and goal seek accurately? Will it run breakeven analysis accurately?

[@chandoo_]

I don't think so. At least not at this time.

[@mdbasha5269]

pushpa the fire

[@amazon5665]

I am not getting the option of copilot

[@DataDears]

Now I can say copilot can not replace me 🤪🤪🤪

[@bluebadgersec]

Insta-sub. Well done!

[@chandoo_]

Welcome aboard!

[@GoodlyChandeep]

Ok Understood, but what's the deal with your T-Shirt? 😁😁

[@chandoo_]

🌼 🔥

[@MrKellvalami]

Copilot is a language model! Don't ask it questions! If you instruct it, you will get much more accurate output!

[@MrKellvalami]

The question "Can you do something? " gives a much higher output probability of not being able to perform the object of the question.

[@chandoo_]

It seems silly. Other LLMs seem to work just fine with such language.

[@user-en8qq3ej5w]

Copilot is useless for excel but useful for powerpoint , notes and ms word.

[@JosefTorkelsen]

I would also put PowerPoint in the useless area as well. The word and outlook is alright but still limited and most of the things you can do in copilot for web anyway.

[@XAE_A_Xii]

give it a year or so, and it will get a lot better, I'm certain

[@DAXifiedSatish]

I found Copilot more useful on power point and Word than on excel

[@chandoo_]

I echo the thoughts. Word is a natural fit as GPTs are very good with text right now. Power Point is ok, but I don't make that many slides anyway.

[@sports.mind-insight]

How we get Microsoft 365 for free

[@thebhaskarjoshi]

Pushpa 😂🤣

[@bill9989]

Anyone with concerns about data security would be reluctant to upload a file. Until copilot can analyze on the computer, I won't use it.

[@rajdipbarui854]

Copilot doesn't work only even I have 365 subscription

[@lucia26]

I am sorry, I can't take over this plane from you. Can you try again?

[@chandoo_]

😂 And don't call me Shirely!

[@lucia26]

@@chandoo_ I guess AI is a different kind of flying, alltogether.

[@lucia26]

Seriously, your demonstration helps me somewhat in my struggle to embrace AI elegantly. Have a good day Chandoo.

[@wagsbass]

I will get old and die before Co-Pilot takes my job away

[@afhlmd]

resumindo: Copilot ainda está fraco.

[@hassanmaje5849]

Satya Nadela is useless.

[@gabi8557]

Painful

[@dafeac]

pretty useless as of now, when gpt 5 it will be a must have, by gpt 6 we won't have jobs

[@chandoo_]

gpt7 - no more youtube too gpt8 will write this comment.

[@gergoadorjan4259]

I always appreciate your videos but to be honest you have started to misslead people about Data and AI. Why is that ?

[@chandoo_]

What is misleading about this video? I've provided accurate, relevant and useful information with my opinions.

[@gergoadorjan4259]

@@chandoo_ Thanks for the super quick respone. The title of the video and thumbnail are missleading dude. Compared to what you showcased in the video. Lets be honest... Copilot will not change that much than what you guys are trying to sell on youtube right now. DO NOT GET ME WRONG ! I still respect all your work that you have done but this is just made more for youtube rather than providing an actual value for users are trying to simplify their work life or learn.

[@chandoo_]

Sorry, but I disagree. CoPilot is a big change and has far more implications for future use. This video shows the possibilities as of now. The fact that we have a fairly capable AI companion in Excel (and office) is a BIG thing. I do agree that that thumbnail & title are optimized for KZbin audience. But YT is a crowded space with 100s of new videos on these topics added every day. If I don't fine-tune the poster, no one will watch the content, making the effort worthless.

[@gergoadorjan4259]

Dude! 😎 One more time. I respect all you have done! 👏 You do not have to prove your values and I do not want to cause any negative effect on your channel, so therefore I propose to connect online sometime when you have some free time. Let’s have a friendly discussion about it. 🗣🤝If not then I will need to live without it... BUT I also need to say that I disagree with what you wrote me last. 😕 I am also in this YT chaos....

[@sriphanikumarvaddiparti7157]

Wonderful constructive decent discussion❤