How to use Analyze Data in Excel (AI Creates Pivot Tables and Charts)

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 พ.ย. 2024

ความคิดเห็น • 274

  • @LeilaGharani
    @LeilaGharani  ปีที่แล้ว +4

    Tired of wasting hours in Excel? Pivot Tables can cut your work in half 👉 www.xelplus.com/course/excel-pivot-tables/ 👈 My Pivot Table Essentials course will teach you how.

  • @richardlibby2407
    @richardlibby2407 ปีที่แล้ว +26

    Once again, Leila doesn’t disappoint us with her knowledge 😊

  • @anindadatta164
    @anindadatta164 ปีที่แล้ว +7

    But "analyze data " feature is not available in most excels, is it to be bought separately as an add in? We use tableau for all this kind of work

  • @nalimelashiva2538
    @nalimelashiva2538 ปีที่แล้ว +7

    How to enable that option

  • @jerg83
    @jerg83 ปีที่แล้ว +4

    The best content on Excel topics. ❤🔥🙌🏼

  • @steinanderson
    @steinanderson ปีที่แล้ว +1

    your smile makes it quick and painless

  • @sesughyaji4783
    @sesughyaji4783 ปีที่แล้ว +3

    Awesome. You deliver your sessions in the most effective ways. Very interesting, easy to follow and focus through it. Your videos are of massive help to me. Well-done.

  • @Stan_sprinkle
    @Stan_sprinkle ปีที่แล้ว +3

    How timely. I finally started playing with this just last week. Go figure Leila reads my mind and posts a video on it.

  • @aylorpaul39
    @aylorpaul39 ปีที่แล้ว +1

    Another great Vid Leila 🙂. Suggestion to make it even more interactive is provide source data so we can try it ourselves , also likely to push your average viewing time up which should also impact your revenue stream. Moving onto your power BI dashboard

  • @samrathna6885
    @samrathna6885 ปีที่แล้ว +2

    I played around this tool when I saw it. But I learned bit more by seeing your video. Thank a bunch

  • @borstenpinsel
    @borstenpinsel ปีที่แล้ว

    I did this on a data Set a few months ago. Excel delivered 30 some graphs , most of which were pointless for my use case (like the first column was some ID and excel showed me the sum). A bunch were really obvious but I knew the data already so... on completely foreign data it might have been cool. 3 or so insights were unique. 2 of them again useless but at least unique and something that wasn't immediately obvious. And what's really cool for the management level who always asks for graphs but doesn't bother reading them: excel out the quintessential result as a heading to the graph. Something which is hard to automate even with macros, without manually adding a ton of cases. This is really a task that I can see AI doing for me in the future. Write a heading and 2-3 sentences about the analysis I created. And I just need to proofread it before sending it out.

  • @shivamrai162
    @shivamrai162 ปีที่แล้ว

    I HAVENT COMPLETED WATCHING BUT I ALREADY LOVE IT.

  • @WilfEsme
    @WilfEsme ปีที่แล้ว

    Not only is this video helpful, but you've made an excel tutorial less boring. AIs are really helpful indeed. I'm using Bluewillow recently to induce an idea and lessens the mental block in generating visuals and designs.

  • @bigboldbicycle
    @bigboldbicycle ปีที่แล้ว +2

    This is crazy useful. I've seen that natural language query feature in PowerBI but didn't realise it's also available in Excel. Thanks!

  • @subhrajitbhattacharjee7211
    @subhrajitbhattacharjee7211 ปีที่แล้ว +3

    Thanks for this video, but Can you tell me which Excel version is available Analyze Data rebon?

  • @Micktunz
    @Micktunz ปีที่แล้ว +5

    Thanks for the tips, Leila. Just to add, I believe a vb code can be used to automatically refresh the pivot tables whenever the source data changes.

    • @nattymo7835
      @nattymo7835 ปีที่แล้ว +1

      She covers auto refresh for changing data in the last 45 seconds or so.

    • @yemtel
      @yemtel ปีที่แล้ว

      You can equally add your data to a model and set auto-refresh

  • @silverlicious2086
    @silverlicious2086 ปีที่แล้ว

    Nice demonstration. Best wishes from Cincinnati USA

  • @hosseinyalaan9064
    @hosseinyalaan9064 ปีที่แล้ว

    The God of Excel 😄 perfect as usual

  • @FilmGrouch
    @FilmGrouch ปีที่แล้ว

    Where has this been my whole life? Very cool!

  • @yungkreuz7986
    @yungkreuz7986 ปีที่แล้ว +2

    The most insightful video I've ever watched since the beginning of 2023
    Thanks a million for that 🤩🤩🤩

  • @aaronag7876
    @aaronag7876 ปีที่แล้ว +14

    Just an idea for a future video
    I'd like to see you "Do your magic" on subscribers own sheets. You ask subscribers to send in their sheets and you show what could be done to improve their processes and functions.

    • @LeilaGharani
      @LeilaGharani  ปีที่แล้ว +5

      That sounds interesting and is similar to what we do but we break it up by topic and simplify data sets so that it applies to a wider audience.

    • @alokprasad8935
      @alokprasad8935 9 หลายเดือนก่อน

      Plz help me how to add this in my excel. I have a exam on Monday.plz plz ​@@LeilaGharani

  • @anandl2003
    @anandl2003 ปีที่แล้ว +1

    Appreciate it! I used it yesterday, Its Super usefull leila, Thank you to help me relax as well :-)

  • @bamideledamilare5940
    @bamideledamilare5940 ปีที่แล้ว +1

    Thanks for the video Leila. But I didn’t get how to get started on this? Is this the newer excel version?

  • @samr4650
    @samr4650 ปีที่แล้ว

    Thank you for sharing this feature, Leila! I credit you for many of my Excel skills...I appreciate you!❤️

  • @nagaphaneendramannem
    @nagaphaneendramannem 9 หลายเดือนก่อน +3

    How to enable this option

  • @fordaysafterxmas
    @fordaysafterxmas ปีที่แล้ว +3

    Hi Leila, is Analyze Data part of the office 2016? for some reason, i could not see it

  • @theamaze9705
    @theamaze9705 ปีที่แล้ว

    Thank u ma'am. Big fan of yours from India

  • @911alps
    @911alps ปีที่แล้ว +2

    Is the analyse by option only available of excel 365 and not excel desktop ? I can’t find it 😢

  • @charlydubaiuae8093
    @charlydubaiuae8093 ปีที่แล้ว

    Thank you Leila for the tips.

  • @isaacmwabila5830
    @isaacmwabila5830 ปีที่แล้ว

    Thank you Leila for always share with us these new Excel options!
    You're the Best!👌🏽👏🏾

  • @InvestorInsaan
    @InvestorInsaan ปีที่แล้ว +1

    Very nicely explained

  • @AparnaModou
    @AparnaModou ปีที่แล้ว +4

    Great AI tool you've shown here! We can see a lot AIs now evolving and being integrated into different fields. Similarly, Bluewillow is also evolving as an image generator. Maybe in the future we'd also have presentations purely made by AI.

  • @tianyi05
    @tianyi05 ปีที่แล้ว +10

    This may work well for smaller data sets. But most of the data sets I work with over 100,000 records and over 50 entries per record. The Analyze Data feature has a hard time prioritizing and seems to offer up mostly random associations.

    • @87pawlok
      @87pawlok ปีที่แล้ว

      Then, divide data and conquer!

  • @Erikve
    @Erikve ปีที่แล้ว

    This is amazing, super handy, thanks for the video Leila!

  • @andrewgeorge2853
    @andrewgeorge2853 9 หลายเดือนก่อน

    Thank you! This was a time save for me.

  • @rukshik
    @rukshik ปีที่แล้ว +2

    Hi.. wanted to check if we can use this for analysing the pnl?

  • @Albelto8a
    @Albelto8a ปีที่แล้ว +1

    Hi Leila, is this feature available in Excel 2019? can't find it, I'm a Planning Manager and analyzing data is one of the most important tasks in my role, thank you for sharing your knowledge, your Awesome!

  • @bhupendrabisht2226
    @bhupendrabisht2226 3 หลายเดือนก่อน

    That was very interesting features which I never saw before, thanks a lot.

  • @SanjayGupta-lr6xs
    @SanjayGupta-lr6xs ปีที่แล้ว

    Best excel teacher.

  • @jag571
    @jag571 ปีที่แล้ว +1

    I was excited to use this feature after watching Leila's video on How to use Analyze Data. However, no matter where I look for help, I cannot get a version that she is showing (not even the same icon) for my Excel 2016. I would gladly take a course if that would be included

  • @kaushikkumar007
    @kaushikkumar007 ปีที่แล้ว +1

    Video was intersting ma'am, cana you help me to find out the data analysis tab

  • @Miriam-jy7tgz
    @Miriam-jy7tgz 6 หลายเดือนก่อน

    You make me feel I can do this!!!!Thank you

  • @SpaceTacos60316
    @SpaceTacos60316 ปีที่แล้ว

    GAH! I'm finding this video a week too late bc I was asked very similar questions recently. Oh well, this is a fantastic video that I will be referencing the next time I get these questions. Thank you. 😊

  • @BenDieselBasicAutomotive
    @BenDieselBasicAutomotive ปีที่แล้ว

    Wow...... another amazing topic... Thanks again...

  • @momodousowe3034
    @momodousowe3034 ปีที่แล้ว

    Wow! Thanks for this great tool

  • @CyrptoDeb
    @CyrptoDeb ปีที่แล้ว

    Just what I needed, perfect :)

  • @thedavidseatonshow
    @thedavidseatonshow ปีที่แล้ว

    Great video as always. I just purchased a new business and will be using this feature.

  • @ricardoarevalo6946
    @ricardoarevalo6946 ปีที่แล้ว

    Bruv. Thank you so much for demo-ing this. Super helpful... And it's right there and never thought to click it lol

  • @bojanasmiljanic7452
    @bojanasmiljanic7452 ปีที่แล้ว

    Wow Leila - amazing as always! ⭐️

  • @mohammedbaydoun9464
    @mohammedbaydoun9464 ปีที่แล้ว +1

    I think that your previous videos were bringing more creative ideas, I don't know if the creative tools are out of stock!
    Anyway, thanks for sharing!

    • @mohammedbaydoun9464
      @mohammedbaydoun9464 ปีที่แล้ว

      two years ago video:
      th-cam.com/video/bey_1SUTB4k/w-d-xo.html

  • @MrJonathanhidalgo365
    @MrJonathanhidalgo365 ปีที่แล้ว

    Omg this is going to save me so much time!!!

  • @tricksntales505
    @tricksntales505 ปีที่แล้ว +5

    Nice video like everytime.......but please provide some alternatives to your solutions for old excel users too........In india specifically, we don't throw the old things as soon as new things come in market, instead of that we repair them and use them again......by keeping that in mind, we still have previous versions of excel (mostly 2016 or 2019) so please make sure that you provide trick to do the same work in those old versions too, as most of these options are not available in previous versions.......

  • @mohammedabaza4831
    @mohammedabaza4831 ปีที่แล้ว

    it's amazing features , could you please inform me should i install this feature , i cant find it in the home tab , thanks in advance

  • @ZKProgrammer
    @ZKProgrammer ปีที่แล้ว +1

    Great job

  • @farzanehvalipour5666
    @farzanehvalipour5666 ปีที่แล้ว

    Hi Leila, thanks for all great training videos you are sharing. They are super helpful.
    I have a question about this command. I enabled this command in my Excel 365 Home tab but it is grayed out. What should I do? I tried everything to make it work but no success yet. Thanks in advance!

  • @FaysalEasyExcel
    @FaysalEasyExcel ปีที่แล้ว

    Thank you for this nice tutorial :)

  • @alex626ification
    @alex626ification ปีที่แล้ว

    I love the art form of making a pivot table.

    • @LeilaGharani
      @LeilaGharani  ปีที่แล้ว

      Haha, never thought about it that way :)

  • @MAJIDMANSOOR1
    @MAJIDMANSOOR1 ปีที่แล้ว

    Waoooo this vedio is very helpful .....,.Thanks

  • @parveznikhat
    @parveznikhat หลายเดือนก่อน

    Thank you so much!!

  • @lilytran1710
    @lilytran1710 ปีที่แล้ว +5

    My excel doesn't have this feature, the Home tab stops at Find&Select. :(

    • @ZUBBYPRINCEOBIDIMMA-bf5sj
      @ZUBBYPRINCEOBIDIMMA-bf5sj 5 หลายเดือนก่อน

      Same with me. Please have you find a solution to this?

    • @arshadarshad-im9pt
      @arshadarshad-im9pt 3 หลายเดือนก่อน

      @@ZUBBYPRINCEOBIDIMMA-bf5sj same wiot me
      same with me

  • @TamerRagheb
    @TamerRagheb ปีที่แล้ว +1

    I don't find the ANALYZE DATA under ANALYSIS section. The ANALYSIS section is empty no buttons, are these options I am using excel 2021?

  • @besmirbode8480
    @besmirbode8480 ปีที่แล้ว +1

    Thanks Leila. I have a company account but Analyze Data is not clickable. How can I activate it?

  • @spuneet156
    @spuneet156 ปีที่แล้ว +1

    Thanks Leila this feature is available in Google sheets as well

    • @topsyturvyy4558
      @topsyturvyy4558 ปีที่แล้ว

      I didn't know that, thanks for the information. This feature is not available in the non-subscription excel.

  • @GAGANBHATIA-m8k
    @GAGANBHATIA-m8k ปีที่แล้ว +2

    I am using excel 365 but analyze data option is not showing in home tab

  • @malcbatotony9518
    @malcbatotony9518 ปีที่แล้ว

    Thank you so much Leila. I really hadn't tried using this feature beyond the suggestions it gives when I am inserting formulas in my data. This is so helpful?

  • @chartphred1
    @chartphred1 ปีที่แล้ว

    You, are a smart cookie!

  • @jerry5149
    @jerry5149 7 หลายเดือนก่อน

    Great stuff!

  • @motazal-natour662
    @motazal-natour662 ปีที่แล้ว +113

    your boss needs to learn how to do this, it is faster than writing an email.

  • @fayazmuhammad5983
    @fayazmuhammad5983 ปีที่แล้ว

    Amazing feature!

  • @malli7979
    @malli7979 6 หลายเดือนก่อน

    hi, well explanation, i have office 365 account but analyze data button not showing, how to enable please guide me

  • @TheSgee100
    @TheSgee100 ปีที่แล้ว

    Fantastic video. 🔥

  • @maciejkopczynski55
    @maciejkopczynski55 ปีที่แล้ว

    Hi Leila,
    is it possible that Analyze Data feature is only available for english version of Excel? I noticed, i was missing the feature even tho I am an Office Insider. When i switch to an english language pack however, the feature suddenly pops up. If you know anything about the matter I would really appreciate your expertise.
    And also - many thanks for all the awesome work you put in to educate us and make everyone EXCELlent :))

  • @mohammadharisfahim6614
    @mohammadharisfahim6614 ปีที่แล้ว

    Data analytics diva. Salam alykum❤

  • @prathameshbile5865
    @prathameshbile5865 ปีที่แล้ว +1

    Thank You! ❣️

  • @vidhipatel248
    @vidhipatel248 4 หลายเดือนก่อน +1

    How to add analyse data tool

  • @VurtAddicted
    @VurtAddicted ปีที่แล้ว +1

    In which excel versions is this functionality available?

  • @aniceemyrapanga849
    @aniceemyrapanga849 3 หลายเดือนก่อน

    Is there a way that from the value, it would show the data from the spreadsheet and not use the count or sum of value?

  • @rosiesilva882
    @rosiesilva882 ปีที่แล้ว

    Hi Thank you for this video it was very helpful. Is there a way to search part of a column info in Excel Row and create a new column just with the search ie fruit type - orange which ends with a enter/return key. Have you already completed a video on this that u can direct me to?

  • @ankurshukla3337
    @ankurshukla3337 5 หลายเดือนก่อน

    Hello Leila can you suggest me how to install or add this addin um Excel

  • @hiralshinde4368
    @hiralshinde4368 ปีที่แล้ว +1

    How to activate this option in excel 2021??

  • @dekelmarkovits3334
    @dekelmarkovits3334 ปีที่แล้ว +1

    how do I get this button on excel

  • @hitraj1705
    @hitraj1705 ปีที่แล้ว

    You are just amazing mam🇮🇳🇮🇳

  • @tariqaziz783
    @tariqaziz783 ปีที่แล้ว

    pls provide workbook for practice too, thanks

  • @PradeepKumar-hg1tl
    @PradeepKumar-hg1tl ปีที่แล้ว

    Ma'am how to activate the data analysis option on MS excel 2021 please kindly make a video on it..

  • @samuelolanipekun5020
    @samuelolanipekun5020 9 หลายเดือนก่อน

    Quick question Leila, how do you format your data set to make it official? 7:47

    • @darrencarlin3388
      @darrencarlin3388 หลายเดือนก่อน

      I need to know this too please

  • @nunyabusiness4516
    @nunyabusiness4516 ปีที่แล้ว

    Hi Leila. As you are such a powerful educator, I thought I might ask you a question. I have built a userform in excel and all the text boxes would clear and transfer as they should - except, I thought I would tweak it a bit and add two new fields. To my dismay, they do not clear as they should and wondered if you might be able to assist me in this frustrating adventure.

  • @raksaramed7113
    @raksaramed7113 ปีที่แล้ว

    This is wonderful

  • @puralasettisruthi8748
    @puralasettisruthi8748 ปีที่แล้ว +1

    Is this option available for free account ? If yes, can anyoneplease share the steps to activate.

  • @vernonprevatt-usmc
    @vernonprevatt-usmc ปีที่แล้ว +1

    Love these tips. Using now to analyze a data set of test results by 30 locations. 😎 Thanks Leila!

  • @ATInstitute
    @ATInstitute ปีที่แล้ว +1

    Woahhh this is powerful

  • @patrickkinbonso1809
    @patrickkinbonso1809 ปีที่แล้ว

    Hi Leila, is the Analyze Data feature safe to use with confidential data please

  • @hitraj1705
    @hitraj1705 ปีที่แล้ว

    Could you please share all the practical files which you use for the video

  • @quentinbricard
    @quentinbricard ปีที่แล้ว

    Wow! Thanks a lot!

  • @rameshprasad8349
    @rameshprasad8349 5 หลายเดือนก่อน

    do i have to subscribe to use this tool?

  • @muzadnan5414
    @muzadnan5414 ปีที่แล้ว

    Great content as the usual, thank you for that. Quick question: I don't have this feature "Analyze Data" or "Ideas" in my Excel, how do I get it?

    • @LeilaGharani
      @LeilaGharani  ปีที่แล้ว

      It's available in Excel for Microsoft 365 and Excel for the web.

    • @mahendrachourasiya
      @mahendrachourasiya 8 หลายเดือนก่อน +1

      Still unable to find it in both versions. Could you please help me with different solution.

  • @addisugebremichael5071
    @addisugebremichael5071 ปีที่แล้ว

    that is awesome but how can I get this icon in my excel sheet. I couldn't find it.

  • @anandl2003
    @anandl2003 ปีที่แล้ว

    Awesome, Leila

  • @teoxengineer
    @teoxengineer ปีที่แล้ว +2

    Hi Leila,
    We can't use Data Analyse tool because of regional differences. For example, I'm living in Turkey and this button is not activated.
    In order to be used this tool, we have to change our language in English version of Excel and than it is being activated.
    Is there any way to use this useful tool?

    • @alexdemoura9972
      @alexdemoura9972 ปีที่แล้ว +3

      That is because Analyze Data uses Natural Language - the way people like us write and not "another" programming language.
      Excel has 3 "programming languages" already:
      1. Excel functions (translated to many languages, it is a kind of functional programming language despite many don't think in that way);
      2. VBA (English only like 99% of all programming languages in this world);
      3. TypeScript (a superset of JavaScript like 99% of these new object/web-oriented programming languages, it is based on something like "English-stenotype" and "Math-symbols-with-no-rules");
      To prevent a 4th programming Analyze Data Natural Language was developed by Microsoft in English, French, Spanish, German, Simplified Chinese, and Japanese only. The Natural Language activates (or uploads) the language pack (lexicon, dictionary, etc.) for these languages.
      That has been my fight for years: against world information & knowledge dominated by "ASCII-and-almost-English-biased" technology.

  • @daliahassan3178
    @daliahassan3178 ปีที่แล้ว

    Thank you for this interesting video but i would be great if you share the file with to follow you in each step you done in the video

  • @pixelasm
    @pixelasm ปีที่แล้ว

    #mindblown Did not expect #microsoft to integrate AI features that quickly, although they poured in billions into OpenAI since 2019 and in January announced to invest another 10 billion. Lets see where this takes us and the office suite ...