Video není dostupné.
Omlouváme se.

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

Sdílet
Vložit
  • čas přidán 18. 08. 2024
  • 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.microsof...
    Sample dataset to experiment: chandoo.org/wp...
    ~
    #Copilot #Excel #ai #Chan2

Komentáře • 67

  • @akashhanchatet-2842
    @akashhanchatet-2842 Před 6 měsíci +10

    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
    @whoamiherein Před 6 měsíci +11

    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
    @fardeenahmedkhan517 Před 6 měsíci +6

    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
      @snackplaylove Před 3 měsíci

      Hi - if you didn’t find it then HSMA (on CZcams) 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.

  • @user-qp1fk8sq3l
    @user-qp1fk8sq3l Před 5 měsíci +1

    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.

  • @chanduycm
    @chanduycm Před 6 měsíci +2

    Bagundi bro , good writing and acting ❤

  • @atulpower1
    @atulpower1 Před 6 měsíci +2

    Was eagerly awaiting this.

  • @venkatiyer7459
    @venkatiyer7459 Před 5 měsíci +2

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

  • @arbazahmad7177
    @arbazahmad7177 Před 6 měsíci +1

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

  • @chrism9037
    @chrism9037 Před 6 měsíci

    The possibilities here are very cool, thanks Chandoo!

  • @INDYEAH
    @INDYEAH Před 6 měsíci

    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_
      @chandoo_  Před 6 měsíci +1

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

  • @ysantosh
    @ysantosh Před 6 měsíci +1

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

    • @chandoo_
      @chandoo_  Před 6 měsíci +1

      You are welcome Santosh...🙂

  • @abhilashn2993
    @abhilashn2993 Před 5 měsíci

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

  • @buddyTalks123
    @buddyTalks123 Před 3 měsíci

    Nicely Explained thank you ! Subscribed !!!

  • @DamuReddy7
    @DamuReddy7 Před 5 měsíci

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

  • @j.k6580
    @j.k6580 Před 5 měsíci

    great teaching

  • @DataDears
    @DataDears Před 6 měsíci +1

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

  • @mdbasha5269
    @mdbasha5269 Před 6 měsíci +1

    pushpa the fire

  • @Tony_Montana659
    @Tony_Montana659 Před 6 měsíci

    Thanks ,Gr8 Info.

  • @tinythings7976
    @tinythings7976 Před 6 měsíci

    Content is amazing like Pushpa

  • @unknownKnownunknowns
    @unknownKnownunknowns Před 3 měsíci +1

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

    • @chandoo_
      @chandoo_  Před 3 měsíci

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

  • @kashishgupta3054
    @kashishgupta3054 Před 2 měsíci

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

  • @MrKellvalami
    @MrKellvalami Před 5 měsíci

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

    • @MrKellvalami
      @MrKellvalami Před 5 měsíci

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

    • @chandoo_
      @chandoo_  Před 5 měsíci

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

  • @user-en8qq3ej5w
    @user-en8qq3ej5w Před 5 měsíci +5

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

    • @JosefTorkelsen
      @JosefTorkelsen Před 2 měsíci

      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.

  • @user-qs5xb6sd3x
    @user-qs5xb6sd3x Před 5 měsíci

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

  • @bluebadgersec
    @bluebadgersec Před 5 měsíci

    Insta-sub. Well done!

  • @asim2676
    @asim2676 Před 5 měsíci

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

  • @amazon5665
    @amazon5665 Před 5 měsíci

    I am not getting the option of copilot

  • @XAE_A_Xii
    @XAE_A_Xii Před 4 měsíci

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

  • @thebhaskarjoshi
    @thebhaskarjoshi Před 5 měsíci +1

    Pushpa 😂🤣

  • @DAXifiedSatish
    @DAXifiedSatish Před 6 měsíci

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

    • @chandoo_
      @chandoo_  Před 6 měsíci +1

      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.

  • @GoodlyChandeep
    @GoodlyChandeep Před 6 měsíci

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

  • @sports.mind-insight
    @sports.mind-insight Před 3 měsíci

    How we get Microsoft 365 for free

  • @bill9989
    @bill9989 Před 4 měsíci

    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.

  • @wagsbass
    @wagsbass Před 6 měsíci

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

  • @cleodontina1
    @cleodontina1 Před měsícem

    I thought you would give feedback on how you have used it and the limitations not start a tutorial on how to use copilot.

    • @chandoo_
      @chandoo_  Před měsícem

      I did that in the ending of the video.

  • @lucia26
    @lucia26 Před 6 měsíci

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

    • @chandoo_
      @chandoo_  Před 6 měsíci +3

      😂
      And don't call me Shirely!

    • @lucia26
      @lucia26 Před 6 měsíci

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

    • @lucia26
      @lucia26 Před 6 měsíci +1

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

  • @innerpeace1001
    @innerpeace1001 Před 5 měsíci

    Copilot doesn't work only even I have 365 subscription

  • @afhlmd
    @afhlmd Před 5 měsíci

    resumindo: Copilot ainda está fraco.

  • @hassanmaje5849
    @hassanmaje5849 Před 5 měsíci

    Satya Nadela is useless.

  • @gabi8557
    @gabi8557 Před 6 měsíci

    Painful

  • @dafeac
    @dafeac Před 6 měsíci

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

    • @chandoo_
      @chandoo_  Před 6 měsíci +4

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

  • @gergoadorjan4259
    @gergoadorjan4259 Před 6 měsíci

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

    • @chandoo_
      @chandoo_  Před 6 měsíci +3

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

    • @gergoadorjan4259
      @gergoadorjan4259 Před 6 měsíci

      @@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_
      @chandoo_  Před 6 měsíci +8

      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 CZcams 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
      @gergoadorjan4259 Před 6 měsíci

      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
      @sriphanikumarvaddiparti7157 Před 5 měsíci +2

      Wonderful constructive decent discussion❤