NEW Python in Excel - PYTHON + EXCEL + ChatGPT = Easy!
Vložit
- čas přidán 11. 06. 2024
- How to use Python in Excel natively using libraries like Pandas, NumPy, Matplotlib, Seaborn and more. In this video I'll show you how to use Python in Excel to do data analysis and create amazing Python charts, aka Python plots.
Don't know Python, don't worry, I'll show you how to use ChatGPT to write the Python code for you and cover the error messages you might experience.
⬇️DOWNLOAD the example file here: www.myonlinetraininghub.com/p...
📝 Note: At the time of recording Python in Excel is currently available to Microsoft 365 Office Insider users on the Beta Channel: insider.microsoft365.com/join
❓ Are you excited about Python in Excel? Please let me know in the COMMENTS.
🎓 LEARN MORE in my Excel courses: www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
0:00 Python in Excel
0:57 Import Python Libraries in Excel
1:57 Defining Dataframes from Excel Data
3:16 Descriptive Statistics in Python
4:05 How to Use ChatGPT to Write Python
6:27 How to Create Python Charts in Excel
9:11 Python Errors in Excel
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 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 😁
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 😊
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 😊
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.
Great video Mynda! So many new things to learn and explore in Excel.
Thanks, Jon! It's exciting times!
Always wanted to learn Python, now I have a reason! Thank you, Ma'am!
Go for it!
Game changer. Can't wait for it to move beyond beta. Thanks for the briefing.
Glad you're excited about it!
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 🙏😊
This is great! Thanks for the comprehensive overview. I'm looking forward to playing with this.
Great to hear!
This is phenomenal work! Thanks Mynda!
Sure is! 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.
This is so valuable! thank you so much! 🙏
Mynda, thank you again, my best excel teacher!
Glad you like it! 🙏😊
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 🙏😊
This is awesome! Thank you for sharing, cant wait for this to come to the regular user
Hope you enjoy it!
Thank you Mynda ,A'm amazed the way this goes beyond and out of limits
Always something new to learn with Excel 😊
This is just awesome and it will tremendously change certain things in my line of work. Thank you Mynda!
Wonderful!
This is great great. Looking forward to see more insights into Py usage. Well done
Thank you 😊
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! 😃
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!
This is an awesome tutorial. Thank you for sharing it!!
Glad you like it!
Your Brilliance I can't wait to use python in Excel. it is incredible. Thank you!
So pleased you're looking forward to it!
Thanks Mynda. You rocks 🙏🙏🙏🙏
You are so welcome 🙏 😊
Great tutorial, thank you so much!! ❤
Glad you liked it 🙏😊
Thank you for this wonderful feature!
The Excel team did an amazing job!
Thank you Mynda! Fantastic!😊
Glad you liked it!!
Amazing, thanks for the quick reference.
You bet!
Amazing add to make excel even better. Thank you!!
Glad you like it!
wow it will be game changer for data analytics u made great video thanks alot
Glad you think so! 🙏😊
now this is really a game changer....thank you so much
Sure is!
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!
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 😊
Thank you for a great intro to Python in Excel
Glad you liked it!
Thank you so much. Every video is valuable.
Glad you like them!
Great material. 🚀🚀
Glad you think so!
Wow! Amazing! Now i have more drive to learn Python! Guess what! In Excel ! Thank you, Mynda🎉❤
Wonderful!
SO EXCITED!!!
Great to hear!
Belíssima explicação! E que simpatia!!!
Obrigado!
Great explanation, thanks!
Glad you enjoyed 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
Thank you for a great explanation
Glad you liked it 😊
Simply Loving it. Excelthonic!
😁
Wonderful. Thanks for the video.
Glad you enjoyed it!
This is a definite game changer 🙌👏🙏👌
Sure is 😊
how exciting, something new
Have fun with it 😊
Great info !!!
Glad it was helpful!
Super Awesome!
Great to hear you're excited about Python in Excel 😊
Thank you Mynda🌹
My pleasure 😊
I love your videos
Thank you so much!
good video !
yes again
Glad you liked it!
Exciting!
Indeed 😁
Thanks for share, very useful 🙂
My pleasure 😊
Oh WOW!!!!!!!!!! ... Ur the best Mynda
Too kind 🙏😊
I know Python so this is great, thanks for sharing.
Glad you liked it!
Awesome Teaching…
Thank you! 🙂
wowser it will change data world thanks!
Indeed!
Very cool!! Two of my favorite things together like pizza and beer! Cant wait until its in wide release.
😁enjoy!
I am so glad that we finally have Python in Excel.
Great to hear, Jim! Have fun with it.
Awesome information madam, I am really happy with this information
So nice of you 🙏
Magnificent 👍
It's super exciting!
very very excited
Great to hear!
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 😊
Incredible👏
Glad you're excited about Python in Excel 😊 Have fun with it!
You are the best
Too kind 😊🙏
This is fantasic - My job will never be the same!
Great to hear you’ll be making use of Python in Excel 😊
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 😁
Awesome video
Glad you enjoyed it 🙏
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!
Amazing!!!
Glad you think so!
this is the first time, i watch video after releasing 3 minutes :D
Thanks for watching! Exciting times 😁
thanks it's amazing
I'm glad you like it 😊
@@MyOnlineTrainingHub it's work now for me, thanks a lot
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 😊
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!
You are one of the best teachers of excel... Where r u from?
Thank you so much! I'm from Australia 😊
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!
Well that's rad!
Sure is 😁
Tu es géniale merci Amenda
Glad you enjoyed it 🙏
Cool stuff Mynda. Once I get a bit better with DAX and M Code, I’ll turn my attention to learning some Python!
Yep, add it to the list 😁
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
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.
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.
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 🙏😊
Again 👏👏👏👏 👍😎
🙏😁
Hi, I'm JUN. Thank you. I need more tips to learn. It's very educative.😅
Glad you liked it 🙏
Excel + Python is a game changer. The competition will have some catching up to do.
Sure is!
There is no catching up to do. M$ simply offloaded the cost of developing the scripting language to the open-source community. The competition has been better since the 80s. Excel and Word were not better than Quattro and WordPerfect. Maybe this misstep by M$ will push their Office products to the obscurity they have deserved.
Great work Mynda.
Can we import files from other workbooks?
You can import files with Power Query and then connect directly to them as objects. That’s a video for another time 😁
Finally!
Yep 😊
This is definitely a trigger to learn some Python.
Yep, and even easier with ChatGPT!
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".
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
Thank you for the wonderful video! It was truly informative and enlightening. I'd like to create a new sheet in my Excel file using the structure defined in Python code from another sheet. I'm having trouble writing the code to implement this. Could you assist me?
Glad you liked it! My Python skills are still limited, but I wonder if the problem you're experiencing is due to the order of evaluation i.e. Python can only reference cells above or to the left of the active cell, likewise for sheets. e.g. Sheet1 cannot reference Python on Sheet2, assuming sheets are in numeric order in the file. Hope that helps.
Hi Mynda, this is amazing. Unfortunately, I don't have the privilege to give it try. I wonder what python libraries does it come with? Can user install custom packages with pip command? Since you mentioned it does come with pandas so I suppose reading data from various databases would not be an issue, but how about common packages such as openxl etc.
Great to hear you're excited about it. Any libraries supported by Anaconda are available: www.anaconda.com/excel
MS excel is probably the most underrated software product ever built
It's a treasure trove 😊
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.
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: czcams.com/video/Jev5ATXwnOs/video.htmlrel=0
Wow!!!
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.