Excel上でPythonを用いたコード入力やグラフ化、解析を可能とするPython in Excelの利用ユーザー範囲が3月のアップデートで広がったことを公式ブログ ...

Enhanced Data Visualization: Use Python libraries like Matplotlib and Seaborn to create highly customizable charts and graphs, surpassing Excel’s built-in visualization tools.

Microsoft is bringing popular programming language Python to Excel. A public preview of the feature is available today, allowing Excel users to manipulate and analyze data from Python.

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.