The new Anaconda Python Distribution in Excel, which is currently in beta, will bring Python data analysis and data science capabilities to the popular spreadsheet program from Microsoft. The ...

A dataframe named “DF1” is created via cell reference, using the new Excel function with an auto-generated headers parameter. The code can be outputted as a Python object or an Excel value.

But Python can automate it with ease. Let's say you're a teacher who uses Excel to track student grades. You have a sheet with columns for student names, assignments, scores, and overall averages.