Posted by admin

Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/ You can use Python INSIDE Excel now \ud83d\ude31 In this video I'll introduce this game changing new functionality of working with Python inside Excel. Is Python in Excel for non-programmers? Can everyday data analysts make use of it? I'll answer these in the video. Plus checkout the announcement from Microsoft: https://techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439 If you have this feature which is currently free to use in Microsoft 365 Insiders, you will find Python in the Insert tab in the Excel Ribbon. You get a few Python libraries already ready for you to use in Excel. These are the pandas, matplotlib, seaborn, statsmodels and NumPy. You can import other libraries as you need using the import statement - for example import re module for REGEX calculations. How can you use Python in Excel in practical terms? I share a few ideas in the videos. You can use the pandas library and turn your data into a dataframe which you can then use for more complex tasks, like query the data, unpivot the data with python, create charts using matplotlib - make a line, area or even small multiples. You can grab URLs from long text by using the regex library. You can also use python together with Power Query. We'll only scratch the surface and even that is pretty awesome. \ud83c\udf0d My Online Courses \u25ba https://www.xelplus.com/courses/ 00:00 Python in Excel 00:40 Enter Python Mode 01:32 Send Excel Data to Python - Create Data Frame 03:19 pandas Python Library 03:43 Python Describe Data 05:11 Assign Name to DataFrame 05:51 Referencing Headers Shortcut 06:26 Examples of pandas Functionalities 07:29 Create Series Python Object 09:35 Plot a Chart in an Excel Cell 10:51 pandas Documentation 11:16 Calculation Logic of Python Cells 12:07 Examples from Default Libraries 13:35 Plot Multiple Charts As Single Object 14:49 Importing Libraries & Referencing Tables 18:10 Python to Excel Power Query 18:35 Wrap Up \u27a1\ufe0f Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join \ud83c\udfac LINKS to related videos: Introduction to Office Scripts: \u25ba https://youtu.be/fny4zUycp_w How to Create & Use Excel Macros: \u25ba https://youtu.be/An-2Nxf_Dms \ud83d\udc55\u2615 Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ \ud83c\udf93 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ \ud83c\udfa5 RESOURCES I recommend: https://www.xelplus.com/resources/ More resources on my Amazon page: https://www.amazon.com/shop/leilagharani \ud83d\udea9Let’s connect on social: Instagram: https://www.instagram.com/lgharani Twitter: https://twitter.com/leilagharani LinkedIn: https://at.linkedin.com/in/leilagharani \ud83d\udc49 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #python #excel