It's probably going to take 2 years for my work 365 license to update to include PY but so looking forward to more advanced charting capabilities. Saving all of these for future reference. I always love when you find a workaround for something MS tells you that it can't be done :)
@@ajarivas72 I've been using Spreadsheet programs for 40+ years. I code in VBA, Python, C++, Java, and 8 other computer languages. I started wtih VisiCalc, then Lotus 1-2-3, and finally Excel. I've had a home licence for everything, and am part of the 365 Insider program and 365 Developer Program. The problem is that the file I create at home can't be used at work, which is where it's most needed. My work is very security sensitive which is why it takes so long to roll out updates.
Mynda, I am you following as a retiree with a lot of Excel knowledge, but following your videos is a pleasure and a good way to keep up with all new features. I can not wait to have also PY in my version of Office.
Hi Mynda, You really GENIUS to use Excel app. I am following you from 2013 and learnt a lot. Those really helped me to implement in my work. Waiting for Python in Excel to enable in my Office 365 subscription. Hoping for more videos from you on Python in Excel in future. Thanks a million 🤝
Interesting video. Way beyond my skill level. I'm still trying to understand formulas and Power Query. Mr. Excel gave you praise on your other videos. Keep up the good work.
I loved the use of: dropna, tolist, isin in pandas. Sorry, my English is not good, I use google translate. Thank you very much for your great contributions.
Noice! Jaw on floor with my tongue rolled out 😂 It's nice to finally see some original content, seems Excel channels these days are simply copying each other. Well done, Miranda! 👍🏽
Still waiting for Python - got an update yesterday but still not active - but still enjoying your Videos - will catch up eventually. They really are awesome -well done!
Thanks so much! Fingers crossed you get it soon. Be sure to check other PCs/laptops to see if they get the update. It's not specific to your login, but rather the installation of the software on each device.
First video I've watched from you and it has been enough to subscribe before seeing what else you got there. your thought process and attitude was enough to convince me. Thanks for sharing! Gonna dive into your other videos now. :)
Hi! There are two statistical algorithms which are good for our favorite excel... I) for any time when is the most profit and II) in any time, when is the worst profit... !
I'm really impress. Thank you very much for share your knowledge. I use a lot Power Query and Power Pivot in Excel. You have a new subscriber from Chile!
@@MyOnlineTrainingHub Might solve challenges I encountered creating a clinical biomarker platform, like a formula for APACHE score used in ICU. Hoping to see tutorials on medical applications in the future. I'd be glad to share what I got sofar.
@garydunken7934 Great to hear! @keylanoslokj1806 that's all part of the development phase, which is why they release it slowly to segments of the beta channel. Not sure I agree that it'll result in new vulnerabilities though 🤔
Looks fascinating. Great video. Very evident that you've already deepened your understanding significantly from your first XL Python video. Loving your output. ☺ For me, there are two irritants. 1. I'm on the Insider Programme, but not the Beta Channel. So I can't play around with it yet. 2. Given that we don't know how much of the new functionality is going to be placed behind a paywall (thanks Microsoft!), it could prove to be an anti-climax. I remember that you said once that you and other MVPs lobbied Microsoft NOT to paywall Power Query/Power Pivot and won. Fancy picking up the challenge a second time Mynda?? We're rooting for you! 🥊
So great to see examples of what you can do with it. Unfortunately I have to wait two months at least to start practicing. Future question: you make dynamic charts, for example in the title of a graph referencing to a cell. In Pivot/Excel you can do so to refer to the page field. But if you have multiple selections, you can not refer any more ("multiple fields"). Maybe Python can??
Great to hear you're excited to use Python in Excel, Bart! Yes, I'm sure Python can display multiple selections in the title. You can also do it with Excel using the TEXTJOIN function: www.myonlinetraininghub.com/excel-textjoin-function
Hi Mynda Very interesting, unfortunately I have not Python on my 365 yet, and when the time comes it will be great if you have a full course about the subject, since I must start from scratch. Best regards
Wow that is amazing. So am I correct in understanding that we now have access the power queries data size benefits, the ability to use the excel formula bar as a Jupyter Notebook, access all python libraries and visual the output in excel? So excel really has the benefit of a Large Data engine?
Yes, kind of! Not 'all' libraries. Only those supported by Anaconda. Yes, big data via Power Query but currently limited to 100MB while in testing/beta mode.
Nice work-around. It is great that Excel has the ability to use the extended range of charts available in the Python packages but wouldn't it be easier to just build the full report in python and display it in a browser window? There are some pretty neat Python packages out there that allow you to do just that.
Sure, if you know Python. I find getting nicely formatted charts easier in Excel. The Python chart labels, legends, borders etc. are ugly and require coding to change them. Excel chart tools are point and click, so for Excel users who don't have Python skills and who need a chart that's already natively in Excel, it's easier to use them.
@@MyOnlineTrainingHub yes I totally agree, but would say that anyone who can manage Excel formulae and Power Query M or DAX for Power Pivot would not have a huge learning curve to start to obtain some pretty spectacular results, especially if using some of the amazing packages available to do a lot of the heavy lifting for you. I am finding that, even as a relative newcomer to python, using python and it's associated libraries is pretty intuitive. The hardest part of the process was getting set up, and even that was not overly difficult to work out with a little patience. That said, Excel will always have a special place in heart and I will get excited about every new development that refines the way it handles data. I look forward seeing more of your videos dealing with this topic in the future and getting to use this amazing new feature. It seems that though I have it there is a bug in my implementation that stops excel from recognising the =PY function along with several other people I can't wait for MS to iron this out!
New features are released to batches of Beta users to ensure things run smoothly. If you don't see Python yet, check daily for updates. You might be lucky and be in the next batch!
Yes. The Python code runs in its own hypervisor isolated container using Azure Container Instances and secure, source-built packages from Anaconda through a secure software supply chain. 😊 More here: techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439
Can you use Python to dynamically add rows? If you can use Python to manipulate actual objects (sheets, cols, rows) that is awesome. You can get VBA to do this but the language is pretty horrible imo.
Hey. I can't get the right version of Excel installed. I opted into the Insider Program via the Account settings. I installed the latest update. It still doesn't work. Really frustrating!
The insider program releases new features to segments of users to test. As the weeks go by, more and more users on the beta channel will get the feature. Hopefully you'll get it in next week's update. 🤞
The insider program releases new features to segments of users to test. As the weeks go by, more and more users on the beta channel will get the feature. Hopefully you'll get it in next week's update. 🤞
@@MyOnlineTrainingHub I agree with you. But if I create a class in python script file and want to import that into excel. Is it possible to create object of that class ?
It's probably going to take 2 years for my work 365 license to update to include PY but so looking forward to more advanced charting capabilities. Saving all of these for future reference. I always love when you find a workaround for something MS tells you that it can't be done :)
Wow, that's a long time! Glad you're looking forward to it though.
Yes I'm disappointed my build version (same as video) does not include it also.
Buy your own license.
@@ajarivas72 I've been using Spreadsheet programs for 40+ years. I code in VBA, Python, C++, Java, and 8 other computer languages. I started wtih VisiCalc, then Lotus 1-2-3, and finally Excel. I've had a home licence for everything, and am part of the 365 Insider program and 365 Developer Program. The problem is that the file I create at home can't be used at work, which is where it's most needed. My work is very security sensitive which is why it takes so long to roll out updates.
Awesome as always! Please do more videos about Python and Excel in the future.
Thanks, will do!
Mynda, I am you following as a retiree with a lot of Excel knowledge, but following your videos is a pleasure and a good way to keep up with all new features. I can not wait to have also PY in my version of Office.
Wonderful to hear! 🙏😊
Hi Mynda, You really GENIUS to use Excel app. I am following you from 2013 and learnt a lot. Those really helped me to implement in my work. Waiting for Python in Excel to enable in my Office 365 subscription. Hoping for more videos from you on Python in Excel in future. Thanks a million 🤝
Wow, that's wonderful to hear 🙏😊
Interesting video. Way beyond my skill level. I'm still trying to understand formulas and Power Query. Mr. Excel gave you praise on your other videos. Keep up the good work.
Thank you! TBH, it's beyond my skill level too, but ChatGPT helps a lot!
Don't know if you would be interested but there is a course on AI and Python on TH-cam. th-cam.com/video/5NgNicANyqM/w-d-xo.html
I loved the use of: dropna, tolist, isin in pandas. Sorry, my English is not good, I use google translate. Thank you very much for your great contributions.
Glad you liked it!
Noice! Jaw on floor with my tongue rolled out 😂
It's nice to finally see some original content, seems Excel channels these days are simply copying each other. Well done, Miranda! 👍🏽
Wow, thanks! 😊
Excellent video.... Thanks for sharing.... We need more of such videos
Thank you! Working on it 😉
Impressive job Mynda. You cover so many aspects of Excel and Python in this video. Congrats
Thanks so much, Frederic! 😊
Your videos are awesome.
Thanks for keeping them short and to the point and not dragging out.
Glad you like them! 🙏😊
Still waiting for Python - got an update yesterday but still not active - but still enjoying your Videos - will catch up eventually. They really are awesome -well done!
Thanks so much! Fingers crossed you get it soon. Be sure to check other PCs/laptops to see if they get the update. It's not specific to your login, but rather the installation of the software on each device.
First video I've watched from you and it has been enough to subscribe before seeing what else you got there. your thought process and attitude was enough to convince me. Thanks for sharing! Gonna dive into your other videos now. :)
Awesome! Thank you!
Hi! There are two statistical algorithms which are good for our favorite excel... I) for any time when is the most profit and II) in any time, when is the worst profit... !
😁
Extraordinary tutorial as always Mynda! Can’t tell how much I have learnt from you. Please keep up the good work!!
You're too kind! Thanks so much! 😊
Wow!! Python now in Excel. Can't wait to see new videos. Thanks
More to come!
I'm really impress. Thank you very much for share your knowledge. I use a lot Power Query and Power Pivot in Excel. You have a new subscriber from Chile!
Awesome! Thank you 😊
Thanks! Looking forward to it!
Excel + Python + Pandas 👍
Great to hear!
@@MyOnlineTrainingHub Might solve challenges I encountered creating a clinical biomarker platform, like a formula for APACHE score used in ICU.
Hoping to see tutorials on medical applications in the future. I'd be glad to share what I got sofar.
Gracias Mynda por este gran aporte! Me encantan tus videos.
Thanks for watching!
Excellent! Py in Excel will open up so many things for me. Can't wait to get Py working on the beta channel that I signed up yesterday.
It will also introduce many new vulnerabilities though and bugs to fix
@garydunken7934 Great to hear!
@keylanoslokj1806 that's all part of the development phase, which is why they release it slowly to segments of the beta channel. Not sure I agree that it'll result in new vulnerabilities though 🤔
Amazing! Well delivered and super useful. Hoping to get this feature in the next update🤞🏽
Thanks for sharing, Mynda!
Thank you! 🤞for the next update for you!
Looks fascinating. Great video. Very evident that you've already deepened your understanding significantly from your first XL Python video. Loving your output. ☺
For me, there are two irritants.
1. I'm on the Insider Programme, but not the Beta Channel. So I can't play around with it yet.
2. Given that we don't know how much of the new functionality is going to be placed behind a paywall (thanks Microsoft!), it could prove to be an anti-climax. I remember that you said once that you and other MVPs lobbied Microsoft NOT to paywall Power Query/Power Pivot and won. Fancy picking up the challenge a second time Mynda?? We're rooting for you! 🥊
We're already fighting 😉
Awesome! So we can use both pivot charts from Excel and pivot charts from PY at the same time.
Yes, absolutely 😁
Magnificent 👍🏻 Great steps to continue my improvement. Thanks for your excellent effort to motivate us 👍🏻
My pleasure 😊 Have fun with it!
Thanks Mynda. Some of it is Greek to me for now. :) :)
😊me too, John!
Your content is amazing.
Glad you think so! 🙏
Great video Mynda - very interesting
Glad you enjoyed it, Heiko!
So great to see examples of what you can do with it. Unfortunately I have to wait two months at least to start practicing. Future question: you make dynamic charts, for example in the title of a graph referencing to a cell. In Pivot/Excel you can do so to refer to the page field. But if you have multiple selections, you can not refer any more ("multiple fields"). Maybe Python can??
Great to hear you're excited to use Python in Excel, Bart! Yes, I'm sure Python can display multiple selections in the title. You can also do it with Excel using the TEXTJOIN function: www.myonlinetraininghub.com/excel-textjoin-function
Thanks a lot Mynda! Very usefull content as always!😊
Glad you think so!
blow my mind away I hope R Script will be integration after this.
Who knows what’s next 😁
I am also waiting for R in Excel.
Hi Mynda
Very interesting, unfortunately I have not Python on my 365 yet, and when the time comes it will be great if you have a full course about the subject, since I must start from scratch.
Best regards
Cheers, Ivan!
fantastic! Thank you very much indeed!
Glad you liked it!
Awesome tutorial!
Glad you liked it!
Love this stuff! So fun! Thank you! :)
🙏 Glad you enjoyed it!
Very useful! Hope to get more amazing updates and tips
More to come!
Awesome tutorials for me as a beginner. A bit too fast though. But very useful 😊
Glad you liked it! Use the cog icon to change playback speed to slower.
@@MyOnlineTrainingHub I have always liked your videos. Your tutorials are very informative and easy to understand
Brilliant. Well done!
Thanks so much!
So cool! Thanks Mynda
Thanks for watching, Chris!
You are amazing 🎉
Thanks so much!
Awesome tutorial. Have you tried using plotly instead of seaborn? I guess you can make the charts interactive with plotly.
You can't use any Python interactive charts by Plotly, Seaborn, Matplotlib.... yet.
This is awesome. Thanks
Glad you liked it!
Wow that is amazing. So am I correct in understanding that we now have access the power queries data size benefits, the ability to use the excel formula bar as a Jupyter Notebook, access all python libraries and visual the output in excel? So excel really has the benefit of a Large Data engine?
Yes, kind of! Not 'all' libraries. Only those supported by Anaconda. Yes, big data via Power Query but currently limited to 100MB while in testing/beta mode.
Thanks for sharing
Thanks for watching!
Nice work-around. It is great that Excel has the ability to use the extended range of charts available in the Python packages but wouldn't it be easier to just build the full report in python and display it in a browser window? There are some pretty neat Python packages out there that allow you to do just that.
Sure, if you know Python. I find getting nicely formatted charts easier in Excel. The Python chart labels, legends, borders etc. are ugly and require coding to change them. Excel chart tools are point and click, so for Excel users who don't have Python skills and who need a chart that's already natively in Excel, it's easier to use them.
@@MyOnlineTrainingHub yes I totally agree, but would say that anyone who can manage Excel formulae and Power Query M or DAX for Power Pivot would not have a huge learning curve to start to obtain some pretty spectacular results, especially if using some of the amazing packages available to do a lot of the heavy lifting for you.
I am finding that, even as a relative newcomer to python, using python and it's associated libraries is pretty intuitive. The hardest part of the process was getting set up, and even that was not overly difficult to work out with a little patience.
That said, Excel will always have a special place in heart and I will get excited about every new development that refines the way it handles data.
I look forward seeing more of your videos dealing with this topic in the future and getting to use this amazing new feature. It seems that though I have it there is a bug in my implementation that stops excel from recognising the =PY function along with several other people I can't wait for MS to iron this out!
Excellent ❤
Glad you like it!
When this feature will be available for all users?
It will depend how it goes in the beta channel as to how quickly it becomes generally available. My guess is it's at least months away.
I signed up for Excell Insider but am still not see Python?
New features are released to batches of Beta users to ensure things run smoothly. If you don't see Python yet, check daily for updates. You might be lucky and be in the next batch!
Interesting. Would it be possible to create a word cloud based on several rows of customer comments?
I expect so, yes. You can use Python to extract sentiment, or keywords and then plot it in a word cloud.
Is Excel using Anaconda (cloud)?
Yes. The Python code runs in its own hypervisor isolated container using Azure Container Instances and secure, source-built packages from Anaconda through a secure software supply chain. 😊 More here: techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439
@@MyOnlineTrainingHub interesting.
Awesome!
😊
📊📉📈💹
😊🙏
Can you use Python to dynamically add rows? If you can use Python to manipulate actual objects (sheets, cols, rows) that is awesome. You can get VBA to do this but the language is pretty horrible imo.
Yes! You can use Python for data cleaning and manipulation.
plotly library supports interactive mode. please try it
But not inside of Excel. The interactive Python charts do not work in Excel, unfortunately.
buckle up for this one people! 😵😵😵😵
😁
@@MyOnlineTrainingHub just finished up watching thoroughly Mynda, amazing stuff !thank you!
Hey. I can't get the right version of Excel installed. I opted into the Insider Program via the Account settings. I installed the latest update. It still doesn't work.
Really frustrating!
The insider program releases new features to segments of users to test. As the weeks go by, more and more users on the beta channel will get the feature. Hopefully you'll get it in next week's update. 🤞
MSFT is a frustration as always. I signed up for Beta channel in Insider program. Nothing shows up in my Excel 365.
The insider program releases new features to segments of users to test. As the weeks go by, more and more users on the beta channel will get the feature. Hopefully you'll get it in next week's update. 🤞
Do you know if we can incorporate python chart in powerpoint?
Yes, use the linked picture, or embed the Excel file: th-cam.com/video/WgpfiVGs6qc/w-d-xo.html
Microsoft mentioned that certain Python in Excel features will require payment once they are generally available. It's unfortunate news. 😔
Yes. I can see both sides. 😞
It is great, but still I'm don't have Python on my excel 365
It's slowly being rolled out to office insiders on the beta channel. Maybe with next week's update 🤞
No python yet on my Beta channel 😞
Check for updates daily. More and more people will get it in the coming weeks.
@@MyOnlineTrainingHub I'm checking almost every minute :-)
👍😎✊
🙏😊
Microsoft should have provided a library for Python
and C++ developers to interact with excel. Python in a cell does not look promising.
You can bring in more libraries. There are several loaded by default e.g. Pandas, Seaborn, Matplotlip etc.
@@MyOnlineTrainingHub I agree with you. But if I create a class in python script file and want to import that into excel. Is it possible to create object of that class ?
wow...just wow Mynda 👍 excellent.
Thank you so much! 😊