Microsoft 365 enables Python in Excel

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:

After completing the above steps, open the blank workbook:

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

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

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!

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.

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

▋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.

▋Data Cleaning

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

▋Team use

「Python in Excel is built for teams.」

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

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!