Microsoft shows off Python in Excel

Stefan Mileschin · 24th August 2023, 09:56

Snakes on Microsoft Cloud

Software King of the World Microsoft announced the Public Preview of Python in Excel, which "runs securely on the Microsoft Cloud".

Vole said that Python was one of the most popular programming languages, loved by businesses and students alike and Excel is an essential tool to organise, manipulate and analyse all kinds of data.

“Until now, there hasn't been an easy way to make those two worlds work together. 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 data analysis and visualisation libraries with Excel's features you know and love. You can manipulate and explore data in Excel using Python plots and libraries, and then use Excel's formulas, charts and PivotTables to refine your insights.

Microsoft has partnered with Anaconda, a Python repository used by tens of millions of data practitioners worldwide. Python in Excel uses Anaconda Distribution for running in Azure, including Python libraries such as pandas for data manipulation, statsmodels for advanced statistical modelling, and Matplotlib and seaborn for data visualisation.

https://fudzilla.com/news/57466-micr...ython-in-excel

24th August 2023, 09:56	#1
Stefan Mileschin [M] Reviewer Join Date: May 2010 Location: Romania Posts: 153,575	Microsoft shows off Python in Excel Snakes on Microsoft Cloud Software King of the World Microsoft announced the Public Preview of Python in Excel, which "runs securely on the Microsoft Cloud". Vole said that Python was one of the most popular programming languages, loved by businesses and students alike and Excel is an essential tool to organise, manipulate and analyse all kinds of data. “Until now, there hasn't been an easy way to make those two worlds work together. 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 data analysis and visualisation libraries with Excel's features you know and love. You can manipulate and explore data in Excel using Python plots and libraries, and then use Excel's formulas, charts and PivotTables to refine your insights. Microsoft has partnered with Anaconda, a Python repository used by tens of millions of data practitioners worldwide. Python in Excel uses Anaconda Distribution for running in Azure, including Python libraries such as pandas for data manipulation, statsmodels for advanced statistical modelling, and Matplotlib and seaborn for data visualisation. https://fudzilla.com/news/57466-micr...ython-in-excel

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to Show the Ribbon in Microsoft Excel, Word, and Outlook	Stefan Mileschin	WebNews	0	11th May 2023 09:44
How to Get the Month or Year From a Date in Microsoft Excel	Stefan Mileschin	WebNews	0	7th September 2022 07:51
Microsoft kills off Excel features	Stefan Mileschin	WebNews	0	31st May 2022 13:58
Your Xbox Now Runs Microsoft Word and Excel	Stefan Mileschin	WebNews	0	27th September 2021 08:15
Python creator joins Microsoft	Stefan Mileschin	WebNews	0	17th November 2020 07:18
Master Microsoft Excel with this $40 training	Stefan Mileschin	WebNews	0	3rd November 2020 15:09
Microsoft Excel spreadsheets now take custom live data	Stefan Mileschin	WebNews	0	30th October 2020 11:12
Microsoft's new Office app for mobile combines Word, Excel and Powerpoint	Stefan Mileschin	WebNews	0	5th November 2019 09:31
Someone made a version of ‘Civilization’ that runs in Microsoft Excel	Stefan Mileschin	WebNews	0	10th September 2019 09:06
Microsoft Excel can provide real-time stock data	Stefan Mileschin	WebNews	0	6th June 2019 08:57