Home >Common Problem >Microsoft 365 enables Python in Excel

Microsoft 365 enables Python in Excel

PHPz
PHPzforward
2023-09-22 22:53:081520browse

1. Enable Python in Excel

Python in Excel is currently in the testing phase. If you want to use this feature, please make sure it is the Windows version of Microsoft 365 , and join the Microsoft 365 Insider Program, select the Beta Channel.

Click [File] >[Account] in the upper left corner of the Excel page.

You can find the following information on the left side of the page:

Microsoft 365 在 Excel 中启用 Python

Microsoft 365 在 Excel 中启用 Python

After completing the above steps, open the blank workbook:

Click the [Formula] tab and select [Insert Python]-[Python in Excel].

Microsoft 365 在 Excel 中启用 Python

Click [Trial Preview Version] in the pop-up dialog box.

Microsoft 365 在 Excel 中启用 Python

Next, we can start to experience the wonderful uses of Python!

2. To start using Python

We only need to enter = PY in the cell or edit bar, select the data, and press [Ctrl Enter] to submit the code. Call Python!

Microsoft 365 在 Excel 中启用 Python

Using Python, we can achieve visualization, data cleaning, machine learning, predictive analysis and other functions.

▋Visualization

You can quickly create charts with just one line of formulas.

Microsoft 365 在 Excel 中启用 Python

If you use famous Python chart libraries such as Matplotlib and seaborn, you can easily create various advanced charts.

Microsoft 365 在 Excel 中启用 Python

▋Machine learning, predictive analysis and forecasting

Using the functions of Python libraries such as scikit-learn and statsmodels, you can implement machine Learning, predictive analytics and forecasting techniques, such as predicting future weather.

Microsoft 365 在 Excel 中启用 Python

▋Data Cleaning

Using the data cleaning technology mentioned above, you can easily complete tasks, such as extracting dates from text.

Microsoft 365 在 Excel 中启用 Python

▋Team use

「Python in Excel is built for teams.」

Users can Share workbooks and collaborate seamlessly with comments, @ and co-authoring with colleagues.

Microsoft 365 在 Excel 中启用 Python

In addition, when using Python, you don’t have to worry about being unable to calculate because the amount of data is too large, because it is calculated on the cloud.

The above is the detailed content of Microsoft 365 enables Python in Excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:yundongfang.com. If there is any infringement, please contact admin@php.cn delete