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! https://www.careerprinciples.com/courses/excel-for-business-finance

Learn how to sign up for Python in Excel here: https://insider.microsoft365.com/en-us/join/windows
The announcement: https://techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439

LEARN:
🔥Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
🚀 All our courses: https://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 – https://www.instagram.com/careerprinciples/?hl=en
🤳 TikTok – https://www.tiktok.com/@career_principles
🧑‍💻 LinkedIn – https://www.linkedin.com/company/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.