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.
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.
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.
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.
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.
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.......
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
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.
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. 😊
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
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!
At the 10 second mark " ... let me quickly get this out of the way before I grab a coffee ..." WHAT??? ... 😲... No ...no ... no!!! ... this must be a trick ... I immediately went and got a second cup of coffee ... ☕☕ ... but the presentation was so good it turns out I didn't need it ... 😉 Excellent feature .... very ... Very ... VERY cool! ... both the feature and the presentation. Lots to work with here ... lots of ideas! Question: Your data set is presented in the portrait format (so to speak) with the dates running down the page. Will "Analyze Data" also work in the landscape format? , i.e. with the dates presented across the top of the page? For example an Income Statement with 10 years of historical data? Thank you ... thank you ... thank you ... 😍😍😍 PS At the 8:00 minute mark " ... thank you for being here ...". HA! ... and where else would I be on Thursday morning?
That's nice that you didn't need the second cup to keep awake 😉 Regarding your question - it will "work" but it will not be optimal. It will be the same as if you created a pivot table over the income statement. The better approach is to push the data to Power Query and unpivot to get the dates in a single column and remove any totals etc you might have in the income statement and output in a table on a separate tab. Then you can use analyze data and get a proper analysis.
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?
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!
Unfortunately, the Analyse Data function doesn't create charts with dynamic conditional formatting. So, in the instance of the chart where February had the highest cost, the chart has 'hard-coded' the title and February's data point as orange. If your data changes and another month becomes the highest value, the graph will update but the title will still read February and February's data point will still be orange.
Stay up to date with the latest by signing up to my FREE weekly newsletter: link.xelplus.com/yt-c-newsletter
Once again, Leila doesn’t disappoint us with her knowledge 😊
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.
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.
Plz help me how to add this in my excel. I have a exam on Monday.plz plz @@LeilaGharani
How to enable that option
How timely. I finally started playing with this just last week. Go figure Leila reads my mind and posts a video on it.
😊
your boss needs to learn how to do this, it is faster than writing an email.
😂
😂😂
🤣
Hilarious 😂
If he does who will call him "Boss"
I played around this tool when I saw it. But I learned bit more by seeing your video. Thank a bunch
You're very welcome!
your smile makes it quick and painless
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
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.
She covers auto refresh for changing data in the last 45 seconds or so.
You can equally add your data to a model and set auto-refresh
That was very interesting features which I never saw before, thanks a lot.
The most insightful video I've ever watched since the beginning of 2023
Thanks a million for that 🤩🤩🤩
Wow! 😳😊
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.
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!
The best content on Excel topics. ❤🔥🙌🏼
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.
Then, divide data and conquer!
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.
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.
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!
two years ago video:
ruclips.net/video/bey_1SUTB4k/видео.html
I HAVENT COMPLETED WATCHING BUT I ALREADY LOVE IT.
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.......
Where has this been my whole life? Very cool!
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
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.
Video was intersting ma'am, cana you help me to find out the data analysis tab
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. 😊
Thank you for sharing this feature, Leila! I credit you for many of my Excel skills...I appreciate you!❤️
Thank you Leila for always share with us these new Excel options!
You're the Best!👌🏽👏🏾
You're so welcome, Isaac!
Appreciate it! I used it yesterday, Its Super usefull leila, Thank you to help me relax as well :-)
Bruv. Thank you so much for demo-ing this. Super helpful... And it's right there and never thought to click it lol
Very nicely explained
I love the art form of making a pivot table.
Haha, never thought about it that way :)
The God of Excel 😄 perfect as usual
Nice demonstration. Best wishes from Cincinnati USA
Great job
Thank u ma'am. Big fan of yours from India
You make me feel I can do this!!!!Thank you
Great video as always. I just purchased a new business and will be using this feature.
Thanks for the video Leila. But I didn’t get how to get started on this? Is this the newer excel version?
Thanks for this video, but Can you tell me which Excel version is available Analyze Data rebon?
Is the analyse by option only available of excel 365 and not excel desktop ? I can’t find it 😢
How to enable this option
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
Best excel teacher.
Thank you! 😃
Love these tips. Using now to analyze a data set of test results by 30 locations. 😎 Thanks Leila!
Glad it was helpful!
Thank you! This was a time save for me.
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!
This is amazing, super handy, thanks for the video Leila!
Thank You! ❣️
Thank you Leila for the tips.
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?
Just what I needed, perfect :)
Hi Leila, is Analyze Data part of the office 2016? for some reason, i could not see it
At the 10 second mark " ... let me quickly get this out of the way before I grab a coffee ..."
WHAT??? ... 😲... No ...no ... no!!! ... this must be a trick ... I immediately went and got a second cup of coffee ... ☕☕ ... but the presentation was so good it turns out I didn't need it ... 😉
Excellent feature .... very ... Very ... VERY cool! ... both the feature and the presentation. Lots to work with here ... lots of ideas!
Question: Your data set is presented in the portrait format (so to speak) with the dates running down the page. Will "Analyze Data" also work in the landscape format? , i.e. with the dates presented across the top of the page? For example an Income Statement with 10 years of historical data?
Thank you ... thank you ... thank you ... 😍😍😍
PS
At the 8:00 minute mark " ... thank you for being here ...".
HA! ... and where else would I be on Thursday morning?
That's nice that you didn't need the second cup to keep awake 😉
Regarding your question - it will "work" but it will not be optimal. It will be the same as if you created a pivot table over the income statement. The better approach is to push the data to Power Query and unpivot to get the dates in a single column and remove any totals etc you might have in the income statement and output in a table on a separate tab. Then you can use analyze data and get a proper analysis.
@@LeilaGharani
More food for thought ... thank you ... thank you ... thank you ... soooo much ... 😍😍😍
Leila Joon, thank you - thank you, and thank you!
Hi.. wanted to check if we can use this for analysing the pnl?
Wow Leila - amazing as always! ⭐️
Thank you!! 😊
Wow! Thanks for this great tool
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?
My excel doesn't have this feature, the Home tab stops at Find&Select. :(
Same with me. Please have you find a solution to this?
@@ZUBBYPRINCEOBIDIMMA-bf5sj same wiot me
same with me
Wow...... another amazing topic... Thanks again...
Omg this is going to save me so much time!!!
You, are a smart cookie!
Thank you for this nice tutorial :)
Thanks Leila this feature is available in Google sheets as well
I didn't know that, thanks for the information. This feature is not available in the non-subscription excel.
Great stuff!
Woahhh this is powerful
Amazing feature!
Wow! Thanks a lot!
Fantastic video. 🔥
This is wonderful
Waoooo this vedio is very helpful .....,.Thanks
Great, thanks!
Ma'am how to activate the data analysis option on MS excel 2021 please kindly make a video on it..
Great video
Cool feature. Hadn't really given it a lot of thought
Thanks Leila, very cool
Thanks for watching, Chris!
hi, well explanation, i have office 365 account but analyze data button not showing, how to enable please guide me
Awesome, Leila
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
Data analytics diva. Salam alykum❤
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?
Good one
Thanks Leila. I have a company account but Analyze Data is not clickable. How can I activate it?
Very nice!
Awesome
You are just amazing mam🇮🇳🇮🇳
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!
Thank you Leila! Great video as usual, but with AI becoming better and better, wonder what may happen to NI?(Natural Intelligence) 😁😜
More Excel magic! Thank you Leila. 😀
You are amazing!
Thanks Leila
Quick question Leila, how do you format your data set to make it official? 7:47
Thank you
It’s amazing n save alots of time 👍🏻
Custom formatting to obtain engineering exponential, I,e., as multiples of e. E.g., 1E-6, 23E-9, 123E+3, ...
Hello Leila can you suggest me how to install or add this addin um Excel
Unfortunately, the Analyse Data function doesn't create charts with dynamic conditional formatting. So, in the instance of the chart where February had the highest cost, the chart has 'hard-coded' the title and February's data point as orange. If your data changes and another month becomes the highest value, the graph will update but the title will still read February and February's data point will still be orange.
fantastic
I have 365, but cannot view analyse data tab in home screen. hoe do i do it?