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... !
@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 🤔
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.
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.
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.
Don't know if you would be interested but there is a course on AI and Python on RU-vid. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5NgNicANyqM.html
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
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!
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! 👍🏽
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.
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 🤝
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. 🤞
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. 🤞
@@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.
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
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!
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! 🥊
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
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. :)
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.
@@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 ?
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!
