Python in Excel! MAJOR Upgrade for Data Analysis & Visualization

Python in Excel. That’s right, Microsoft just announced Python inside of Excel. No external plug-ins, and completely free if you’re a Microsoft 365 user.
🔥 Take our Excel course! www.careerprinciples.com/cour...
Learn how to sign up for Python in Excel here: insider.microsoft365.com/en-u...
The announcement: techcommunity.microsoft.com/t...
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
In this video, we go over Python in Excel. For this, we first start with an overview of the feature and how to use it. This includes finding it under the formula ribbon and activating it with =PY in the formula bar. Then, we’ll get into what it can do with data analysis. We’ll do some descriptive analysis and some correlation analysis for some stocks using Python in Excel. Third, we’ll go over some of the visuals and charts Python in Excel has to offer. This includes some default charts as well as some advanced charts not typically available inside Microsoft such as a pairplot using Seaborn. Lastly, we’ll look at how you can install Python in Excel and some of the shortcomings of the software (primarily that it operates on the cloud, which could raise some privacy concerns and you need external internet connection for it.
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​ -​ Python in Excel Overview
1:57​ - Data Analysis with Python in Excel
4:05​ - Data Visualization
7:57​ - Installing & Shortcomings of Python in Excel
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

[@KenjiExplains]

✅Learn more Excel with my course here: www.careerprinciples.com/courses/excel-for-business-finance

[@vernienavarro4403]

Hi Kenjie, I would really like to enroll on the Excel and Power BI bundle course, do you till provide discount?

[@paulmartineau3850]

Thanks for your video. I just found out about this and want to use it as soon as it available.

[@ashanisomarathne8859]

Your Excel knowledge was really helpful for me on today's exam ❤

[@vikramadityarathore97]

Great one Kenji!

[@camlex6310]

Great video on the new Python feature!! Thankssss

[@m-e-Lee-o]

Extraordinary way to summarize this update for Excel. Thanks for sharing!

[@KenjiExplains]

Thanks for the nice comment :) Glad it was helpful!

[@zeeshanahmedkhan8227]

Is there a quick reference of the python codes that you’ve used in this? Can we see anywhere in the excel sheet or we need to just Google it up?

[@yohannaagbanaji8012]

Nice job as usual Kenji. I am following closely. Keep it up.

[@KenjiExplains]

Awesome, thank you!

[@yuyuhuang1967]

Thanks for this great video. That is excellent! Could you please upload your Excel workbook for this tutorial? Then I can follow step by step for practice.

[@marzenababij5148]

Thanks🦋💙🦋, greetings from 🇵🇱🇩🇪

[@vitkrasiuk9827]

Great video, thanks Kenji!

[@KenjiExplains]

My pleasure!

[@dalskiBo]

I thought it may be great at first BUT from what I've read python code is at Microsoft's end of the server (not your local machine). Apparently anywhere python is inserted it acts like a volatile function; seriously affecting performance, so you can't have much python in your spreadsheet, refreshing each time you click inside a dataframe I'd imagine. i have not been lucky enough to receive the python in excel despite updating to the latest build in the Insider 365 beta channel.

[@jonjohnson2844]

I'm not that excited about this per se - but I am excited about what more talented people can do with it that I can copy!

[@junerey6680]

have the same thought

[@aegialina]

Python is the excellently language and one of more used languages ​​in Microsoft projects. I wanted an Excel that was secure and easy to use ironPython in it. The current version is very similar to most of my expectations and is revolutionary. I want this powerful language to be used by more people.

[@ttech_official]

Thank you so much!!

[@KenjiExplains]

Glad it helped!

[@ajraol9032]

Thanks!! Could you do a tutorial on the S&P Capital IQ plug in

[@KenjiExplains]

Not sure but will keep it noted! Thanks for the suggestion

[@darren-silvertrade]

i have a new install of office 365 with excel... but do not see python in the formula bar. How to get this ?

[@willm7994]

Kenji you are a ⭐️ ❤

[@KenjiExplains]

Haha thank you!

[@OldDogNewTricks_at_60]

hello - what version of Excel is this possible - I still have 2010 excel in my PC

[@pl4195]

Hi Kenji, I cannot find python in my insert tab. Any way that I could activate it? thank you!

[@albertuslano1785]

please explain, vba versus phyton....what same the fiture or phyton more full and more good vba

[@paopaoastig]

New subscriber here. Anyone!. I'm not knowledgeable to excel. Even a simple basic. Any recommendations of how to learn excel from basic to advanced. A simplified teaching will be much appreciated. Thank you

[@dannynedwich]

Hey Kenji, great video. I've gone through all of the steps and have added the Python add-in but only get the "preview" option. I've tried to troubleshoot but no luck. Is there something else I need to do? Many thanks!

[@dannynedwich]

never mind figured it out!

[@dylan_song]

Great video! When is this going to be available for the public to use?

[@KenjiExplains]

It's already available for some people so should be rolled out more generally soon :)

[@wooddog007]

Thanks

[@KenjiExplains]

Thank you for supporting the channel! Hopefully more good videos coming :)

[@CaribouDataScience]

But both Python and R are available in Power BI.....

[@motopelamohapi4152]

Kenji, You are the Man. Thank you a million.

[@KenjiExplains]

Thanks for watching man I appreciate you!

[@user-dg6zy3fs6c]

Hi Kenji, I am a huge fan of your videos and all your advice. I have an interview excel test coming up and I was wondering if you have any videos on that? Like what sort of questions to look for? I was told it would be basic cash flow definitions, WACC calculations, and fundamental financial statement questions Thank you

[@KenjiExplains]

Hey yeah I have mulitple excel test videos! See here kzbin.info/www/bejne/fomtZGdjnrNofpY Good luck with the interview! This other finance interview questions should also be useful: kzbin.info/www/bejne/noukfXlrbcSkqbs

[@MegaTrickykid]

Awesome - thank you very much indeed for this very useful tutorial!

[@KenjiExplains]

You're very welcome!

[@zaibacook6061]

​😂F tc fv 🎉CRoz😅😅

[@charlesjaphe]

Super Do-per

[@faizansayed9203]

Does it autoupdate or we need to buy a premium version for it? Which version has this feature

[@KenjiExplains]

Autoupdates with microsoft 365

[@ch012]

For me Insert Python itself is not enabled. Can you help enabling it.? I have already joined the insider program but it is of no help.

[@KenjiExplains]

Hey, I explain more about the rollout process in the video

[@KenjiExplains]

see towards the end for the details of the rollout process

[@Viper4ever05]

doesn't look like its on the Mac version :(

[@Dedicated2WendyWilliams]

is this availible for MAC ?

[@KenjiExplains]

Not yet!

[@gersonady2274]

What excel year from? 2013 or after? And how to install it?

[@mohsentarashi]

Office 365, newest version!

[@victorfritsch3530]

correct if i wrong but excel dont install python in your machine only use python which is hosted in a server.

[@celestinballa6640]

please help me to get office 365

[@lazyswimmer7]

To clarify, this is only available to a few for marketing purposes, this is not available to the public.

[@fykDice]

Not true

[@redeux]

It is in the beta channel of excel releases (which anyone with a subscription can get. Ltsc licenses do not get updates)

[@lazyswimmer7]

@@redeux Of course you can sign up for it, but that still doesn’t mean you can use it.

[@waynez8136]

no wonder

[@mohamedeassa]

Notification gang

[@KenjiExplains]

Lets go!

[@ab_c4429]

At this point why even use excel? If you want to create good visuals with python you need many more lines of code. Easier to just put the data in a csv, import and manipulate with pandas. Then matplotlib however much you want to tweak to perfection.

[@MuhammadAffaf]

Python is best If you know python Upwork give you 1st job

[@MuhammadAffaf]

If you have a team you do something if you are alone you dont do any think

[@willzinner8813]

nice intro lol

[@KenjiExplains]

XD

[@AmpersAndAI]

This is not Python...

[@MultiEminemfan01]

Every video i have seen so far doesn't tell you how to enable python inside excel, they only tell you how to use it, for god sake!!!