i liked the way you present your data and formulas.... apart from your excel skills and technical language, i admire your presentation skills...be it voice, expression, background...inspiring. Impressive stuff. Thank you.
Amazing Excel features and also well presented. Thank you. I wonder how in your video you highlight (in the green) the commands/areas which you focus on
Presented with concision and expertise. The AI-driven additions can be monumental time-savers and process-enhancers for analysts and accountants. Thanks for illuminating!
Hello Mynda this a great video like the rest of them. I love the channel and learn a lot. I’m try to see the video of formula by example and link in not on this video. If you can share it that will be great.
Flash fill popped up for me when I had to combine very complicated product list from suppliers in 3 different countries all with their own way of inputting the specs. Flash fill probably saved me 8 hours of manually sorting them out.
Thanks for the video. Analyse data is not great say compared to Cognos analytics where analytics is very much advanced and meaningful. Is there any add-in or some other tool that can be purchased to do similar in Excel or BI
Microsoft's BI tool like Cognos is Power BI. I agree, it would be great to have that functionality in Excel. One option if you require more advanced charting, is to use the new Python charts and data analytics in Excel: ruclips.net/video/IuqE6uh2Z9w/видео.html
Excellent.. simply superb... pl tell, how is lambda is different from macros? Also if we share the sheet having lambda functions with others, would our lambda functions be also copied or shared?
So glad you enjoyed it! Macros are VBA code and require the file to be saved as a .xlsm format. This has security risks associated with it, which is why you must 'enable' the file before you can use it. It's just another overhead of using VBA/Macros. This issue isn't present with LAMBDA functions which are treated like regular functions. If you share a file containing a LAMBDA, the receiving user also has the LAMBDA in the file.
@@MyOnlineTrainingHub awesome.... thanks for abundant clarity. Pl also guide about pivot and unpivot data in power query. I need clarity in my concepts
Great stuff again. Has the Insert Reccommended Pivot Tables been updated? I still get the old version with a dialog box not a task pane, similar or same table options but no new sheet / existing sheet option
I'm not sure what rectangles you mean, but presumably the ones that are drawn on. If so, they are done with my video editing software: Camtasia Studio.
Is there a built in formula or AI tool that will quickly look up information or description of a product and fill it in for you? For example, if I have a product in Column A such as Adobe Pro (A2). Description in column B, the tool will quickly look up (search on the web) a description for Adobe Pro and fill into B2. I wonder if a tool exist?
Interesting. I can see the add-in so not sure why they would block it for you. Maybe it's a regional restriction. You could try changing your settings to English-US to see if that changes things.
Flash fill is not working Formatted dates field for me - Its showing an error- We didn't fill in values because the displaying formatting for some cells in the active column is using a different level of precision than the underlying value. Can you explain this?
Sounds like the dates in some of the cells also contain a time component. If you change the date format to Number, you will see the underlying date serial number. If you're still stuck, please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@@keylanoslokj1806 You get a lot more than just Excel. The subscription is for Microsoft 365 which also gives you 1Tb of storage space and allows you to install on five or six different devices. It's also constantly updated. It's a great deal.
Can you please tell me how I use the function filter to show Date Cases Management Date column that is 90 days back, and then also show all the Final Class as "No", and show Dismissed as "No". I am struggling with the 90 days. I used this formula: =FILTER(A2:h4462,(A2:A4461>=today()-90)*(E2:E4446=12)*(F2:F4461=J3),"Nothing"). I filters, but is not showing the dates 90 days back because it is also showing 8/9/23, 7/25/23, 6/30/23. It would be 90 days back if showed only beginning of June and previous months. Also it will show previous months and years if the Final Class and Dismissed is blank(="No") which is ok this part, that's the purpose. The nurses have 90 days to provide diagnose(final class) from the date she was assigned the Case Management Date. Thank you.
Love that Excel Labs Lambda function, BUT there is no way I'm agreeing to that privacy policy. My data just doesn't look safe or private. Microsoft really need to give that better thought.
If Excel was dead they wouldn't be continuing to develop it for all platforms. Look at Access. Now there's an app that's dead. Excel alternatives say Excel is dead because they're trying to acquire some of its market share, but it's all just hot air and marketing. Excel is not dead. It's not even middle aged.
@@MyOnlineTrainingHub of course Excel is not dead, I was just mocking all these people that for many years are asking me, why I keep on investing (spending) my time with Excel.
Absolutely, positively jaw-dropping. Thank you so much for this very brief yet comprehensive intro!
So pleased you found it helpful! Have fun with these Excel AI tools 😊
i liked the way you present your data and formulas....
apart from your excel skills and technical language, i admire your presentation skills...be it voice, expression, background...inspiring.
Impressive stuff.
Thank you.
Thanks so much for your kind words! Made my day 🙏😊
Your tutorials have helped me to improve my Excel skills tremendously. Thank you
That's wonderful to hear 🙏😊
Amazing content as always Mynda! thanks a lot!
Thank you! Glad you enjoyed it!
🙏 Amazing! Your tutorials are outstanding. Thank you very much indeed!
🙏 Glad you think so! 😊
Awesome. Excel Labs is wonderful! Thank you Mynda.
Glad you think so, Ivan! 🙏
Another amazing video, thanks Mynda! I have to get in the habit of using some of these more
Thanks so much, Chris! They are definitely worth using, but old habits 😁
Amazing video Mynda! Great tips! Thank you.
Thank you, Luciano! Glad you enjoyed it 😊
amazing and clear video, thanks Mynda!
So pleased to hear that 🙏
cool effect with the copilot thing! lol you are becoming an expert with video editing as well !
Thanks 😁
I learn a lot from your channel!! thank you
Awesome to hear 🙏😊
LAMBDA and Labs are totally new to me! You are awesome!
Glad you like them!
Amazing Excel features and also well presented. Thank you. I wonder how in your video you highlight (in the green) the commands/areas which you focus on
Thank you! I use Camtasia Studio for my videos and the green boxes are callouts.
Thank you
You're welcome 😊
❤@@MyOnlineTrainingHub
Thank you! Please keep this up!
🙏Will do!
I didn't know number 7. That looks greate to build custom formula with Lambda. Thanks Mynda 😀👏
Thanks, Frederic!
Excellent/Efficient Summary
Thanks so much!
7:27 FORECASTING. historical data in column layout, Date and Values.
7:55 Options. Confluences and SEAONALITY. >> JUST LIKE FXBC
My pleasure! Glad you found it helpful 😊
Presented with concision and expertise. The AI-driven additions can be monumental time-savers and process-enhancers for analysts and accountants. Thanks for illuminating!
Thanks for your kind words! Much appreciated 😊
Thank you for the response and sending me the link to the other video
Amazing stuff!
I’ve embraced PQ but some of those other features look great.
Great to hear you're already using Power Query. Hope you'll find the others useful too.
Awesome thanks Mynda
Glad you liked it! 🙏
These findings are interesting👌
Glad you think so 😊
Thanks for the Video!. May I know the Mic name that you used to record the video?
The live action is this mic: Sennheiser MKE 600 - Shotgun Microphone
And the screen recording is this mic: Samson G-Track
@@MyOnlineTrainingHub Thanks for the quick response
Amazing 😊
Thanks 😄
Nice tools. 💯👍🏻💚
Glad you like them!
Hello Mynda this a great video like the rest of them. I love the channel and learn a lot. I’m try to see the video of formula by example and link in not on this video. If you can share it that will be great.
The link is at 13:13:28 Here it is to save you finding it again: ruclips.net/video/lRqCd2eL2gA/видео.html
Formula by example will be a stunning feature - can’t wait 👌🏻👌🏻👌🏻
I know, right!
Flash fill popped up for me when I had to combine very complicated product list from suppliers in 3 different countries all with their own way of inputting the specs. Flash fill probably saved me 8 hours of manually sorting them out.
Wow! Awesome to hear.
Thanks for the video. Analyse data is not great say compared to Cognos analytics where analytics is very much advanced and meaningful. Is there any add-in or some other tool that can be purchased to do similar in Excel or BI
Microsoft's BI tool like Cognos is Power BI. I agree, it would be great to have that functionality in Excel. One option if you require more advanced charting, is to use the new Python charts and data analytics in Excel: ruclips.net/video/IuqE6uh2Z9w/видео.html
Excellent.. simply superb... pl tell, how is lambda is different from macros? Also if we share the sheet having lambda functions with others, would our lambda functions be also copied or shared?
So glad you enjoyed it! Macros are VBA code and require the file to be saved as a .xlsm format. This has security risks associated with it, which is why you must 'enable' the file before you can use it. It's just another overhead of using VBA/Macros. This issue isn't present with LAMBDA functions which are treated like regular functions. If you share a file containing a LAMBDA, the receiving user also has the LAMBDA in the file.
@@MyOnlineTrainingHub awesome.... thanks for abundant clarity. Pl also guide about pivot and unpivot data in power query. I need clarity in my concepts
Here's a video on unpivot with Power Query: ruclips.net/video/-IMqkg35adA/видео.html
Great stuff again.
Has the Insert Reccommended Pivot Tables been updated? I still get the old version with a dialog box not a task pane, similar or same table options but no new sheet / existing sheet option
Possibly. I’m on the beta channel. There hasn’t been any announcement of an update, but that’s not unusual for small changes.
Can you explain how those rectangles are made?
I'm not sure what rectangles you mean, but presumably the ones that are drawn on. If so, they are done with my video editing software: Camtasia Studio.
Also pl can u explain in detail about pivot and unpivot data in power query?
Please see this video: ruclips.net/video/L4BuUzccLpo/видео.html
@@MyOnlineTrainingHub thanks.. u r a life saver
wow !!! you are awesome
Thank you so much 😀
Hi Mynda
You are truly amazing.
Know most of it, but haw to dive deep into Lambda guessing that it can reduce size and increase speed.
Thanks for your kind words, Ivan! Have fun with lambdas. They can really hurt your head 😁
Hi Mynda, I don't see the example file when clicking on the link
Never mind, I found it!
👍hope you find it helpful!
Is there a built in formula or AI tool that will quickly look up information or description of a product and fill it in for you? For example, if I have a product in Column A such as Adobe Pro (A2). Description in column B, the tool will quickly look up (search on the web) a description for Adobe Pro and fill into B2. I wonder if a tool exist?
You could try the LABS.GENERATIVEAI function: www.microsoft.com/en-us/garage/profiles/excel-labs/
Microsoft has started blocking Add-Ins from the Microsoft store. Is there another way to get the Excel labs Add-in? Great material
Interesting. I can see the add-in so not sure why they would block it for you. Maybe it's a regional restriction. You could try changing your settings to English-US to see if that changes things.
How to get that Analyze data ai tool please help me!!
Analyze Data is available in Excel for Microsoft 365 Windows or Mac and Excel for the web.
@@MyOnlineTrainingHub but where can i find it ?
@@MyOnlineTrainingHub But I cannot find it in Excel web please help me.
I have same problem
It's on the Home tab of the ribbon.
Flash fill is not working Formatted dates field for me - Its showing an error- We didn't fill in values because the displaying formatting for some cells in the active column is using a different level of precision than the underlying value. Can you explain this?
Sounds like the dates in some of the cells also contain a time component. If you change the date format to Number, you will see the underlying date serial number. If you're still stuck, please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
How much is that excel version per year subscription
It depends which subscription you choose. I think they start around $99/year.
@@MyOnlineTrainingHub damn that's expensive. And the high end one?
@@keylanoslokj1806 You get a lot more than just Excel. The subscription is for Microsoft 365 which also gives you 1Tb of storage space and allows you to install on five or six different devices. It's also constantly updated. It's a great deal.
when i click recommended pivot table a get a new sheet with 1 example no choices- im on. mac with full Microsoft subscription??
The same here. Excel for Mac lacks of a lot of features...
I haven't tested on a Mac, but there are a lot of features that are different/behind the PC version of Excel and it sounds like this is one of them.
Awesome
Glad you liked these tools 🙏
Can you please tell me how I use the function filter to show Date Cases Management Date column that is 90 days back, and then also show all the Final Class as "No", and show Dismissed as "No". I am struggling with the 90 days. I used this formula: =FILTER(A2:h4462,(A2:A4461>=today()-90)*(E2:E4446=12)*(F2:F4461=J3),"Nothing"). I filters, but is not showing the dates 90 days back because it is also showing 8/9/23, 7/25/23, 6/30/23. It would be 90 days back if showed only beginning of June and previous months. Also it will show previous months and years if the Final Class and Dismissed is blank(="No") which is ok this part, that's the purpose. The nurses have 90 days to provide diagnose(final class) from the date she was assigned the Case Management Date. Thank you.
Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
I fixed the formula, and now it's working. Thank you. I will use your suggestion in the future. @@MyOnlineTrainingHub
I have Office 365 Personal but the suggested formulas you showed last doesn't appear to be working. Any Ideas?
You can only see them in Excel Online at the moment. They’re still in development for the desktop.
Thank you Mynda! @@MyOnlineTrainingHub
Love that Excel Labs Lambda function, BUT there is no way I'm agreeing to that privacy policy. My data just doesn't look safe or private. Microsoft really need to give that better thought.
Fair enough, Ivor.
Nice, thanks! It does not work on a Macbook.
Some features will, I haven't tested them all.
😲🎆👏
👊
😎
😁🙏
❤
🙏
Ahhh , things are moving too fast ! they saying ‘the future is now’ i think the future was yesterday 😮
😁 ⚡fast!
👍😎✊
🙏😊
For many years people keep saying that excel is dead, is it???
I've worked at various funds, one thing that has remained consistent is excel. Excel is here to stay forever, every other system won't.
If Excel was dead they wouldn't be continuing to develop it for all platforms. Look at Access. Now there's an app that's dead. Excel alternatives say Excel is dead because they're trying to acquire some of its market share, but it's all just hot air and marketing. Excel is not dead. It's not even middle aged.
@@MyOnlineTrainingHub of course Excel is not dead, I was just mocking all these people that for many years are asking me, why I keep on investing (spending) my time with Excel.
First here
Welcome!