AI-powered Advanced Analytics in Excel

This killer feature is available worldwide and offers advanced analytics of large data sets in Excel using Azure compute power.

This killer feature is available worldwide and offers advanced analytics of large data sets in Excel using Azure compute power.

Now you can use natural language that will use AI magic to execute Python on your data in Excel to perform correlation analysis, visualize your data, find deviations, or prepare forecasts for future results.

This huge! You need to try it.

Excel Advanced Analytics with Copilot and Python

Excel users are in for a treat with the latest advancements in analytics functionality. After months of feedback regarding the basic AI features in Excel, the integration of Python has brought a new level of sophistication to data analysis. This blog post will delve into the exciting features now available in Excel, supported by Python, and how they can transform your data analysis experience.

Advanced Analytics with Python in Excel

Excel’s new functionality allows users to perform advanced analytics using Python directly within the application. This integration enables deep dives into large volumes of data, moving beyond simple conditional formatting to more complex analytical tasks.

The general way of working of Copilot in Excel with Python

• Natural Language Processing: Users can leverage natural language to generate Python code in the background, simplifying the process of executing advanced analytics without needing to write code manually. 
• Cloud Execution: The Python code is executed in the Microsoft Azure cloud, ensuring that it does not access your device or data outside of the spreadsheet. This provides a secure environment for data analysis.
• Data Frame Creation: Upon initiating the advanced analytics, a new spreadsheet is created with the Python configuration deployed. This includes a data frame with the Python icon, containing all the relevant data for analysis. 
• Premium Compute: Initially, the analytics use premium compute for faster processing, which later switches to standard compute. Users can extend their capabilities with premium computing if high performance is required.

Key Advanced Analytics features in Copilot in Excel that will allow you to work with large volume of data:

• Deep Dive Analysis: Users can perform deep dive analysis on large datasets, such as crime statistics from Chicago, to generate detailed statistics and visualizations. This includes monthly breakdowns and year-over-year comparisons. 
• Visualization: The integration allows for the visualization of data over time and by location, providing insights into trends and patterns. Although map loading is not yet supported, users can compare results with external maps for accuracy.
• Trend Analysis: Compilot can analyze trends and highlight deviations from average statistics, making it easier to identify anomalies in the data. This is particularly useful for quality control in production processes.
• Correlation Analysis: Users can perform correlation analysis to understand the relationships between different parameters in their data. This helps in identifying how specific elements impact the overall results.
• Prediction and Forecasting: The AI model can predict future trends based on historical data, providing forecasts for upcoming months. This feature is valuable for planning and decision-making. 

The integration of Python in Excel with advanced analytics is a game-changer for users dealing with large volumes of data. It offers a secure, efficient, and powerful way to analyze and visualize data, making it an essential tool for anyone looking to leverage AI in their data analysis workflows. Whether you’re performing trend analysis, correlation studies, or forecasting, these features provide the depth and flexibility needed to gain meaningful insights from your data.

Explore these new functionalities in Excel and see how they can enhance your data analysis capabilities. Happy analyzing!

Conclusion

The integration of Python in Excel enables users to go beyond basic AI features, providing advanced analytics capabilities that can handle extensive datasets.

About the Author

Szymon Bochniak

Copilot MVP | Head of Presales @ IT-Dev | Strategic Advisor focus on Copilot & Microsoft 365

Reference:

Bochniak, S (2025). AI-powered Advanced Analytics in Excel. Available at: AI-based Advanced Analytics of data using Copilot in Excel [Accessed: 27th March 2025].