Some members of the Microsoft 365 Insiders program can now try out the combination of Python, Excel and the Anaconda Python repository.

Python and Excel can only really talk to each other through limited functions—xl () and =PY ()—that can only return code results, not macros, VBA code, or other data, Microsoft claims.

Still using Excel for your data analysis? Learn how to leverage Python so you can work with larger datasets and automate repetitive tasks.

This will enable users to perform complex statistical analysis, advanced visualizations, predictive analytics, and machine learning in Excel.

Slicers are a great tool for filtering a data set or PivotTable. Learn how to use one slicer to manipulate more than one PivotTable or PivotChart.