Living a SharePoint life

Tuesday, August 22, 2023

Introducing Python in Excel: The Best of Both Worlds for Data Analysis and Visualization

Today, we are excited to introduce the Public Preview of Python in Excel - making it possible to integrate Python and Excel analytics within the same Excel grid for uninterrupted workflow. Python in Excel combines Python's powerful data analysis and visualization libraries with Excel's features you know and love. Now you can do advanced data analysis in the familiar Excel environment by accessing Python directly from the Excel ribbon. Using Excel's built-in connectors and Power Query, you can easily bring external data into Python in Excel workflows. Python in Excel leverages Anaconda Distribution for Python running in Azure, which includes the most popular Python libraries such as pandas for data manipulation, statsmodels for advanced statistical modeling, and Matplotlib and seaborn for data visualization. Teammates can refresh Python in Excel analytics for the most up-to-date information, even if they don't have Python in Excel activated. Super charge your data analysis and tell better stories with Python in Excel. -------------------- Read more at Source: Microsoft Tech Community Microsoft 365 Blog

Featured Post

How are Microsoft Search quota consumed?

With Office 365 Search, Microsoft has created a central entry point for the modern workplace. In one convenient spot, users can access all ...