Python in Excel Tutorial

Published: 09 March 2024
on channel: Sheet Skunk

450

Python in Excel has been available for several months now. If you've used Python in the past, this should come as exciting news! Most companies rely on Excel for most of their day to day data analysis. With the integration of Python in Microsoft 365, your data analysis can take on a whole new form.

Let me show you how to set up your Python script, create a DataFrame, run some aggregations, and build a chart. All you need is a Microsoft 365 subscription and become a member of the Insider's program.

Let's see what all the fuss is about!

00:00 Python in Excel
00:46 Initiating Python in Excel
01:52 Using DataFrames
03:30 Working with data types
04:38 Filtering a DataFrame
05:26 Aggregating and Grouping using Python
08:08 Creating charts with Python
11:22 What do you think of Python in Excel?

Looking for more Excel help? ➡️ https://sheetskunk.com

Let's connect on social! 👨‍💻📲

TikTok ➡️   / sheetskunk
Instagram ➡️   / sheetskunk
Pinterest ➡️   / sheetskunk

On this page of the site you can watch the video online Python in Excel Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Sheet Skunk 09 March 2024, share the link with friends and acquaintances, this video has already been watched 450 times on youtube and it was liked by 13 viewers. Enjoy your viewing!

13,912

323