Absolutely amazing, Mynda. You have already pushed open another door! What you have demonstrated here is absolutely fantastic. Many thanks also for the working material, which I immediately downloaded from your website. warm greetings from Berlin!
This is a game changer. When I considered the possibility of using Python in Excel, I was thinking it might be in place of Visual Basic and hadn't considered the possibilities of using libraries as you've demonstrated. I'm still interested in the possibilities of using for loops to iterate through lines for some unusual requirements I might have, so I'll explore more. Thanks for sharing this info in such an easy to understand and follow way 👍🏻
Be aware that besides ChatGPT and Bing, there are other Chat AIs out there as well. From my experiments with code (and in general) no one AI gives the best answer for every prompt. So it’s often worth comparing at least a couple at a time.
Wow this is really awesome! Looking forward for full deployment of Python in excel for data science! excel never ceases to amaze me in making itself relevant! thank you for sharing this, Mynda!
The power of python is that it has no limitations on the number of records in BIG BIG DATA!! 😁 I'm waiting to see if being tied to an excel spreadsheet will install a ceiling on data size 😣 Also, can we pip install any of the python libraries and then import them for use in excel ? Excel already does dataframes/tables and charts, but, traditionally, we've have to skedaddle to VBA to process text mining stuff. However, I'm looking forward to the general release to take it for a test drive. Thanks for the intro, Mynda 👍
This will be a great way of squeezing some more revenue out of Excel jocks too dumb to realize that you can completely bypass the whole Microsoft bit and make direct use of Python and NumPy and Jupyter and Pandas and Matplotlib and all the rest of it ... for free.
Mynda, what an incredible thing to see! Even not knowing a thing in Python, of course it is widely known that it is amazing and will bring new endless possibilities to Excel!
This is awesome! I must admit I am struggling to catch up with new Microsoft Apps and features. Thanks, Treacy for always providing relevant use case descriptions.
This was amazing. I look forward to each Excel Newsletter but this installment was Epic. Thank you Mynda...you continue to deliver value with each newsletter.
@@kyth2583 Do you have the beta program and downloaded Version 2309 Build 16818.20000? In Excel (Microsoft 365), File => Account (on left near bottom) => "About Excel" should have that version number (or higher) and say "Beta Channel".
Thanks for this video Mynda. This is powerful stuff. I already use python and being able to use the python libraries with Excel is exciting. I wonder if you will be doing courses with Excel and Python Libraries in the future. If you do, let me know.
Python integration opens up a whole new world of possibilities! One grumble I have, though, is I can’t help but think we need the Advanced Formula Environment to replace the formula bar we’re so used to. It doesn’t seem right typing Python code in the current one!
This is fantastic news. I stopped learning VBA a while back and switched to Python. I have seen in some job postings some companies are looking to update legacy Excel and this may be an option in the future.
So far I can't see anything that really excites me but that might change when seeing more advanced examples. The charts alone wouldn't be incentive enough. I'm a graphics designer and often create charts but have found that simple ones everyone understands without a lengthy explanation work best. I certainly wouldn't pay extra for them.
Python is vast and the libraries make it relatively easy to get started with. If you’re already using it then it’s a no brainer. If it’s new to you then there might not be any immediate need.
It depends on how far you can see. Python and the libraries if offers is an absolute game changer here @ennykraft. Look at it this way, Microsoft will not spend the time and development effort to integrate a 3rd Party language into Excel if there wasn't going to be great advantages. The charts is just the tip of the iceberg.
Thank you for this video. Where would you recommend I look to find more information on the different type of graphs available thru Seaborn? Thank you 🙏🏽.
It's available to Office Insiders on the beta Version 2309 Build 16.0.16818.20000. You can join Office Insiders here: insider.microsoft365.com/en-us/join/windows Not in Excel Online yet.
Hello Mynda, once again you enlightened my Excel knowledge with a new game changer "Python in Excel" with astonishing charts! My question might sound odd but with large data analysis and related charts what would you recommend: Power BI or Python in Excel? Please advise and many thanks for your easy-to-understand method, best.
Thank you! For large data reporting, I'd use Power BI 😉 for analysis, it depends on what type of analysis and how flexible you want it to be. Power BI is quite rigid, whereas Excel is the opposite.
@@MyOnlineTrainingHub Thanks for the guidance! I'm actually a financial management specialist and deal with large data for analysis and reporting. I sometimes need to focus on specific data that do not require huge amounts of information and that's where "Python in Excel" comes in. I like the flexibility and the related charts' availability. Also, I have the Business subscription how can I get it, unless I'm mistaken I haven't seen a way of getting "Python in Excel". Could you help or assist? Many thanks in advance.
Thanks for the guidance! I'm actually a financial management specialist and deal with large data for analysis and reporting. I sometimes need to focus on specific data that do not require huge amounts of information and that's where "Python in Excel" comes in. I like the flexibility and the related charts' availability. Also, I have the Business subscription how can I get it, unless I'm mistaken I haven't seen a way of getting "Python in Excel" for enterprise users having the latter subscription. Could you help or assist? Many thanks in advance. sorry to rebvert to you with same question
I'm impressed. I will have to spend the time playing with it. I keep an excel spreadsheet with daily calorie intake as well as protein, fat, weight, etc. Is there an easy way that python can scale all the charts at once?
Kind of. If you recalculate any Python formula, they all recalculate. If you have a lot of Python formulas in Excel, then switching to manual calc might be helpful. There's a new 'stale values' format that will highlight any cells that need recalculating.
For Excel users who don't know Python, the main benefits I see are the charts. Excel doesn't have anything like the charts available in Python. If you're a data analyst, then the Python stats are excellent. I don't know Python, but I found with ChatGPT I was able to use it relatively easily.
There's no installation process. It's currently available to 365 users on the Office Insiders beta channel. You can sign up for it here for free: insider.microsoft365.com/en-us/join/windows
It's available to Office Insiders on the beta Version 2309 Build 16.0.16818.20000. You can join Office Insiders here: insider.microsoft365.com/en-us/join/windows
great possibilities. Like the 'picture in cell' alternative to merging cells to show the seaborn picture. Only I do not see that option in my right click menu.
I do have python. Perhaps Picture in Cell is the same as Paste Special as Picture (with link), but then you still have to size the cell or merge cells to get a proper picture.@@MyOnlineTrainingHub
I need to learn this ASAP. however, I have a hard time of finding out to be a "Microsoft 365 Office Insider users on the Beta Channel". Any tips to get access by becoming a "insider user"
@@MyOnlineTrainingHub thank you, I've signed up. How long does it usually take? I want to spend the weekend on this and shine in a job interview early next week
Hi Mynda - Looking forward to this - looks fscinating - have been using Python for years and recently completed an online course. However it does not seem to have been activated in my version yet. A couple of posts online also say it is on a rollout method. Do anyone know anything about this I am on the 365 Beta and the vesion is Microsoft 365 MSO (Version 2309 Build 16.0.16818.20000) 64-bit. I am not getting Insert Python on the formual bar
Great to hear you're excited to use Python in Excel. The way the beta program works for big changes like this is to release the feature to random subsets of users. They often start with 50% of users, but I think this was less than that. Each week there is an update, so keep your eye out for it to see if you're in the lucky group. Note: it's possible to be in the first lucky group and then the next week lose the feature! If you have multiple PCs, it's possible for one to have it and one not to have it. Good luck!
Thank you! Any libraries supported by Anaconda. More info here: techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/bc-p/3906074#M3737
Why would I use this over Jupyter Notebook or even a standard IDE? I guess in Excel you have the added mobility of being able to view all columns easier.. but what are the other benefits?
Because you can use data in Excel, use Power Query to get data from multiple sources, you can combine Python results with Excel formulas, VBA, Office Scripts and all the other good stuff in Excel.
That’s incredible thank you Mynda. A question, can the data frame reference a table housed in Power Query and included as a connection only in excel? That would take away the data size constraints of excel.
Good video Mynda, but the question is why do we need to code Python in Excel when Copilot for Excel is coming soon, where are we going to be able to analyze everything with AI?
The Microsoft Teams working on Excel are brilliants! You can't sleep these days with these fast moves...
😁it's a moving target of learning!
Absolutely amazing, Mynda. You have already pushed open another door! What you have demonstrated here is absolutely fantastic. Many thanks also for the working material, which I immediately downloaded from your website. warm greetings from Berlin!
Awesome to hear 🙏 have fun with it.
I love Excel AND Python, and been working with them for years. This is very exciting indeed! Thanks for the news.
Great to hear!
This is a game changer. When I considered the possibility of using Python in Excel, I was thinking it might be in place of Visual Basic and hadn't considered the possibilities of using libraries as you've demonstrated.
I'm still interested in the possibilities of using for loops to iterate through lines for some unusual requirements I might have, so I'll explore more.
Thanks for sharing this info in such an easy to understand and follow way 👍🏻
Cheers, David! Sounds like you have some ideas ready to go. Have fun with it 😊
Excellent!!!
Python + Excel + ChatGPT is a Chat worth while!!!!
Well going amazing enough Mynda!!!
😁 sure is! Glad you liked it 🙏
Be aware that besides ChatGPT and Bing, there are other Chat AIs out there as well. From my experiments with code (and in general) no one AI gives the best answer for every prompt. So it’s often worth comparing at least a couple at a time.
Wow this is really awesome! Looking forward for full deployment of Python in excel for data science!
excel never ceases to amaze me in making itself relevant! thank you for sharing this, Mynda!
🙏Great to hear you're excited about Python in Excel!
Same, Python is very user-friendly (especially with all the sources available and chatgpt)
The power of python is that it has no limitations on the number of records in BIG BIG DATA!! 😁
I'm waiting to see if being tied to an excel spreadsheet will install a ceiling on data size 😣
Also, can we pip install any of the python libraries and then import them for use in excel ?
Excel already does dataframes/tables and charts, but, traditionally, we've have to skedaddle to VBA to process text mining stuff.
However, I'm looking forward to the general release to take it for a test drive.
Thanks for the intro, Mynda 👍
This will be a great way of squeezing some more revenue out of Excel jocks too dumb to realize that you can completely bypass the whole Microsoft bit and make direct use of Python and NumPy and Jupyter and Pandas and Matplotlib and all the rest of it ... for free.
wow, wow, wow. That's what i have to say about it. Thank you so much for bringing this to us Mynda. You're the best
So glad you like it 🙏😊
Always wanted to learn Python, now I have a reason! Thank you, Ma'am!
Go for it!
Great video Mynda! So many new things to learn and explore in Excel.
Thanks, Jon! It's exciting times!
Your Brilliance I can't wait to use python in Excel. it is incredible. Thank you!
So pleased you're looking forward to it!
Mynda, what an incredible thing to see! Even not knowing a thing in Python, of course it is widely known that it is amazing and will bring new endless possibilities to Excel!
Exciting times 😊
Continue it.
Thanks
Wow, it only took me 1 min to watch the video to press subscribe and click the like. That's how awesome this video is.... Cheers!
Awesome! Thanks so much 😊
Game changer. Can't wait for it to move beyond beta. Thanks for the briefing.
Glad you're excited about it!
This is awesome! I must admit I am struggling to catch up with new Microsoft Apps and features. Thanks, Treacy for always providing relevant use case descriptions.
My pleasure! I know, it's a lot even for me, and I write about it for a living 😁
Mynda, thank you so so much!! News and insightful tutorials like this keep me excited for your new videos. Python is Excel is so exciting!!
My pleasure! Have fun with Python in Excel 😊
You are one of the best teachers of excel... Where r u from?
Thank you so much! I'm from Australia 😊
@@MyOnlineTrainingHub Eeessshhh! Once a brit, always a Brit!!
Mynda, thank you again, my best excel teacher!
Glad you like it! 🙏😊
Gracias Mynda, es maravilloso ahora Python en Excel. Me encanto tu video. Felicitaciones.
¡Muchas gracias!
🙂...Extraordinaria noticia: A estudiar Python se ha dicho. Saludos Andrés.
@@Fredick.7 Saludos Freddy, un abrazo fuerte amigo.
All I can say is, 'endless possibilities.' I cannot even begin to imagine the extent of Excel + Python. I will certainly come back to this post.
Exciting times 😁
Hi, excellent news I am making a course of Python and this news went the but amazing in this moment. I wiil go many jobs with python and excel. Thanks
Best of luck!
Wow, this is a game-changer. I can't wait to get it through the Office 365 beta channel. Thank you
Great to hear!
Excellent videos.. i always loved to listen to your classes..
Thank you! 😃
wow it will be game changer for data analytics u made great video thanks alot
Glad you think so! 🙏😊
Wow! Amazing! Now i have more drive to learn Python! Guess what! In Excel ! Thank you, Mynda🎉❤
Wonderful!
This was amazing. I look forward to each Excel Newsletter but this installment was Epic. Thank you Mynda...you continue to deliver value with each newsletter.
So thankful you like them 🙏😊
Thank you Mynda ,A'm amazed the way this goes beyond and out of limits
Always something new to learn with Excel 😊
Mynda, thank you very much for this great news, which will open up lots of possibilities in Excel.
Glad you're excited to use it!
This is phenomenal work! Thanks Mynda!
Sure is! Have fun with it.
Thnak you for this video!
Really really excited!
You’re welcome! Glad you’re excited!
Really excited to learn python and use it in my data analytics. I'm currently training at ALX Africa in partnership with Explore Academy.
Awesome to hear!
Very cool!! Two of my favorite things together like pizza and beer! Cant wait until its in wide release.
😁enjoy!
Awesome information madam, I am really happy with this information
So nice of you 🙏
Thank you Mynda. yet another feature to help confuse us oldies. Just kidding, we will get our minds around it eventually I guess.
😁I'm sure you will. It'll keep the brain cells active at least!
Interesting. Do you think it is worth learning Python? If so, what would be the advantages? What is the downside?
I think at least knowing the basics of Python will enable you to leverage the code you can get from ChatGPT more easily.
now this is really a game changer....thank you so much
Sure is!
This is just awesome and it will tremendously change certain things in my line of work. Thank you Mynda!
Wonderful!
I am so glad that we finally have Python in Excel.
Great to hear, Jim! Have fun with it.
You're the first I've heard explain "enter =PY and tab". This is essential. If you just put =py and return, like you'd normally do, it won't work.
Glad I could help! =PY( also works, or the keyboard shortcut which I prefer: CTRL+ALT+SHIFT+P
Hi Mynda, it still wont work with me using the shortcut either way.
@@kyth2583 Do you have the beta program and downloaded Version 2309 Build 16818.20000?
In Excel (Microsoft 365), File => Account (on left near bottom) => "About Excel" should have that version number (or higher) and say "Beta Channel".
Thanks for this video Mynda. This is powerful stuff. I already use python and being able to use the python libraries with Excel is exciting.
I wonder if you will be doing courses with Excel and Python Libraries in the future. If you do, let me know.
Great to hear you're looking forward to using Python in Excel, Paul! I'll keep you posted regarding any new Python courses 😊
I know Python so this is great, thanks for sharing.
Glad you liked it!
Oh WOW!!!!!!!!!! ... Ur the best Mynda
Too kind 🙏😊
Python integration opens up a whole new world of possibilities! One grumble I have, though, is I can’t help but think we need the Advanced Formula Environment to replace the formula bar we’re so used to. It doesn’t seem right typing Python code in the current one!
I agree, the AFE would be ideal for Python. It may well work. I haven’t tried it yet.
This is fantastic news. I stopped learning VBA a while back and switched to Python. I have seen in some job postings some companies are looking to update legacy Excel and this may be an option in the future.
The options seem almost endless now 😊
Thanks much for this wonderful lectures. please, what version of excel is this possible or can we get python mode enabled?
Python is generally available to all 365 Enterprise and Business users.
Thank you Mynda! Fantastic!😊
Glad you liked it!!
Amazing add to make excel even better. Thank you!!
Glad you like it!
So far I can't see anything that really excites me but that might change when seeing more advanced examples. The charts alone wouldn't be incentive enough. I'm a graphics designer and often create charts but have found that simple ones everyone understands without a lengthy explanation work best. I certainly wouldn't pay extra for them.
Ok
Python is vast and the libraries make it relatively easy to get started with. If you’re already using it then it’s a no brainer. If it’s new to you then there might not be any immediate need.
It depends on how far you can see. Python and the libraries if offers is an absolute game changer here @ennykraft. Look at it this way, Microsoft will not spend the time and development effort to integrate a 3rd Party language into Excel if there wasn't going to be great advantages. The charts is just the tip of the iceberg.
This is awesome! Thank you for sharing, cant wait for this to come to the regular user
Hope you enjoy it!
Thank you for this video. Where would you recommend I look to find more information on the different type of graphs available thru Seaborn? Thank you 🙏🏽.
My pleasure. You can see the Seaborn graphs here: seaborn.pydata.org/examples/index.html
Thanks Mynda. You rocks 🙏🙏🙏🙏
You are so welcome 🙏 😊
This is an awesome tutorial. Thank you for sharing it!!
Glad you like it!
this is the first time, i watch video after releasing 3 minutes :D
Thanks for watching! Exciting times 😁
This is great great. Looking forward to see more insights into Py usage. Well done
Thank you 😊
MS excel is probably the most underrated software product ever built
It's a treasure trove 😊
Simply Loving it. Excelthonic!
😁
SO EXCITED!!!
Great to hear!
This feature didn't hit my tenant yet. I am excited to try. Does it work in web app as well?
It's available to Office Insiders on the beta Version 2309 Build 16.0.16818.20000. You can join Office Insiders here: insider.microsoft365.com/en-us/join/windows Not in Excel Online yet.
This is great! Thanks for the comprehensive overview. I'm looking forward to playing with this.
Great to hear!
Great material. 🚀🚀
Glad you think so!
Legacy VBA can it be replaced with the Cloud based Python Packages? Could it interface with PowerQuery, too?
No, Python in Excel cannot interact with other Excel tools other than formulas.
Hello Mynda, once again you enlightened my Excel knowledge with a new game changer "Python in Excel" with astonishing charts! My question might sound odd but with large data analysis and related charts what would you recommend: Power BI or Python in Excel? Please advise and many thanks for your easy-to-understand method, best.
Thank you! For large data reporting, I'd use Power BI 😉 for analysis, it depends on what type of analysis and how flexible you want it to be. Power BI is quite rigid, whereas Excel is the opposite.
@@MyOnlineTrainingHub Thanks for the guidance! I'm actually a financial management specialist and deal with large data for analysis and reporting. I sometimes need to focus on specific data that do not require huge amounts of information and that's where "Python in Excel" comes in. I like the flexibility and the related charts' availability. Also, I have the Business subscription how can I get it, unless I'm mistaken I haven't seen a way of getting "Python in Excel". Could you help or assist? Many thanks in advance.
Thanks for the guidance! I'm actually a financial management specialist and deal with large data for analysis and reporting. I sometimes need to focus on specific data that do not require huge amounts of information and that's where "Python in Excel" comes in. I like the flexibility and the related charts' availability. Also, I have the Business subscription how can I get it, unless I'm mistaken I haven't seen a way of getting "Python in Excel" for enterprise users having the latter subscription. Could you help or assist? Many thanks in advance. sorry to rebvert to you with same question
This is a definite game changer 🙌👏🙏👌
Sure is 😊
I'm impressed. I will have to spend the time playing with it. I keep an excel spreadsheet with daily calorie intake as well as protein, fat, weight, etc. Is there an easy way that python can scale all the charts at once?
If by scale, you mean automatically pick up the new data, then see this video: th-cam.com/video/Jev5ATXwnOs/w-d-xo.htmlrel=0
This is so valuable! thank you so much! 🙏
Thanks Mynda! I don’t have access to try this out yet, but just wondering if Python formulas are volatile?
Kind of. If you recalculate any Python formula, they all recalculate. If you have a lot of Python formulas in Excel, then switching to manual calc might be helpful. There's a new 'stale values' format that will highlight any cells that need recalculating.
@@MyOnlineTrainingHub Makes sense, thanks Mynda!
This is fantasic - My job will never be the same!
Great to hear you’ll be making use of Python in Excel 😊
Seems cool for those who know python. Are there benefits of using Python vs normal functions/power query & power pivot?
For Excel users who don't know Python, the main benefits I see are the charts. Excel doesn't have anything like the charts available in Python. If you're a data analyst, then the Python stats are excellent. I don't know Python, but I found with ChatGPT I was able to use it relatively easily.
@@MyOnlineTrainingHub Yeah those were some pretty cool charts. ChatGPT has been pretty useful in many ways.
Thank you for a great explanation
Glad you liked it 😊
this future persists only in a special version of excel ? where we can see instalation process ,ty in advance
There's no installation process. It's currently available to 365 users on the Office Insiders beta channel. You can sign up for it here for free: insider.microsoft365.com/en-us/join/windows
Thank you for this wonderful feature!
The Excel team did an amazing job!
Amazing, thanks for the quick reference.
You bet!
Thank you Mynda🌹
My pleasure 😊
wowser it will change data world thanks!
Indeed!
Is it part of the main Excel distribution?
It's available to Office Insiders on the beta Version 2309 Build 16.0.16818.20000. You can join Office Insiders here: insider.microsoft365.com/en-us/join/windows
@@MyOnlineTrainingHub can I install along side of regular office365
No, but you can switch between regular and insiders via the File tab > Account.
how exciting, something new
Have fun with it 😊
Do you have an example Excel file with the USA map by county?
No, sorry.
great possibilities. Like the 'picture in cell' alternative to merging cells to show the seaborn picture. Only I do not see that option in my right click menu.
Yes, exciting! If you have Python, then you should have Picture in Cell. If you don't have Python yet, then it'll be a version limitation.
I do have python. Perhaps Picture in Cell is the same as Paste Special as Picture (with link), but then you still have to size the cell or merge cells to get a proper picture.@@MyOnlineTrainingHub
Hi, I'm JUN. Thank you. I need more tips to learn. It's very educative.😅
Glad you liked it 🙏
Belíssima explicação! E que simpatia!!!
Obrigado!
I need to learn this ASAP. however, I have a hard time of finding out to be a "Microsoft 365 Office Insider users on the Beta Channel". Any tips to get access by becoming a "insider user"
You can sign up for it here: insider.microsoft365.com/en-us/join/windows
@@MyOnlineTrainingHub thank you, I've signed up. How long does it usually take? I want to spend the weekend on this and shine in a job interview early next week
Thank you for a great intro to Python in Excel
Glad you liked it!
With this new feature, what will be the impact on VBA? Can we use Python in Excel to create Userforms with ActiveX controls?
No, Python in Excel is not designed to replace automation tools. It's more there for the data analytics, charting and machine learning tools.
Great explanation, thanks!
Glad you enjoyed it!
Thank you so much. Every video is valuable.
Glad you like them!
Excel users will become programers 😊
We already are 😉
Awesome Teaching…
Thank you! 🙂
Notice how she didn't menation BARD. Because BARD is horrible. Very cool video. Thank you.
QQ: How does it interact with POWER QUERY?
Thank you! You can define a query in a dataframe, so no need to load it to the grid and you can obviously handle a lot more data 😁
Thanks for share, very useful 🙂
My pleasure 😊
Hi Mynda - Looking forward to this - looks fscinating - have been using Python for years and recently completed an online course. However it does not seem to have been activated in my version yet. A couple of posts online also say it is on a rollout method. Do anyone know anything about this I am on the 365 Beta and the vesion is Microsoft 365 MSO (Version 2309 Build 16.0.16818.20000) 64-bit. I am not getting Insert Python on the formual bar
Great to hear you're excited to use Python in Excel. The way the beta program works for big changes like this is to release the feature to random subsets of users. They often start with 50% of users, but I think this was less than that. Each week there is an update, so keep your eye out for it to see if you're in the lucky group. Note: it's possible to be in the first lucky group and then the next week lose the feature! If you have multiple PCs, it's possible for one to have it and one not to have it. Good luck!
@@MyOnlineTrainingHub Thx for the explanation. It would be helpful if you had mentioned this in the video.
Very nice. But excel is limited to 1 mln rows or u can upload text files with much more rows?
You can connect to a Power Query query 😉
Exciting!
Indeed 😁
Is there a list of which python libraries can be used? Thanks great video
Thank you! Any libraries supported by Anaconda. More info here: techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/bc-p/3906074#M3737
"Excel haters" must be crying...again 😝 - thank you Mynda!! mind-blowing what's ahead!
😁I'm sure the haters are always gonna hate, but good luck to them. We now have Python in Excel. Let the fun begin!
@@MyOnlineTrainingHub just finished re-watching it - amazing Mynda, THANK you for making it!
Why would I use this over Jupyter Notebook or even a standard IDE? I guess in Excel you have the added mobility of being able to view all columns easier.. but what are the other benefits?
Because you can use data in Excel, use Power Query to get data from multiple sources, you can combine Python results with Excel formulas, VBA, Office Scripts and all the other good stuff in Excel.
Wonderful. Thanks for the video.
Glad you enjoyed it!
I love your videos
Thank you so much!
That’s incredible thank you Mynda. A question, can the data frame reference a table housed in Power Query and included as a connection only in excel? That would take away the data size constraints of excel.
Yes, it can 👍 next week’s video 😉
Oh wow that’s brilliant- thank you for making these super insightful videos
Good video Mynda, but the question is why do we need to code Python in Excel when Copilot for Excel is coming soon, where are we going to be able to analyze everything with AI?
I guess eventually we are likely to be able to use co-pilot, but until then you can use ChatGPT. Unless you're happy to wait...
Truly amazing to see how all this works! I can't wait to be a wiz kid! As always, Mynda, great information! :)
Glad you liked it 🙏😊
Did you say this was only available on the Beta version?
At the moment, yes.