Over a year later and I still do not understand what the use case for this is.
A lot of the examples/documentation that was made by Microsoft for this seems to focus on data analysis and data visualization. Anyone in those fields would probably prefer to get the data out of Excel and into their tool/pipeline of choice instead of running their Python code in Excel. That also makes the big assumption that the data being used is fully contained within the Excel file and that the libraries used within the code are avalaible in Excel (including the library version).
For anyone looking to learn/use Excel better, I doubt the best use of their time is learning a new programming language and how Excel implements that programming language. They would likely be better off learning Excel's formulas, pivot tables, charts, etc. They could even learn Power Query to take things to another level.
For anyone looking to learn Python, this is absolutely a terrible way to do so. For example, it abstracts away library maintenance, could provide modified error messages, and makes the developer feedback loop more complicated.
If you want to automate Excel then this realistically allows for very little new functionality that did not exist prior to this feature. Using other Python libraries like OpenPyxl and xlWings will still be required to automate Excel.
I am sure there are edge cases where this iteration of Python in Excel is perfect. However, this feels like a checkbox filler ("yeah, Excel supports Python now") than an implementation of an actual useful feature. A fully featured and supported Python library that manipulates Excel/Excel files would have been a much more exciting and useful feature - even if it had to be executed outside of Excel, like OpenPyxl.
You could use the web version of each of those apps. They may not have complete feature parity with the corresponding Windows desktop versions and the web versions may be a little more challenging to use, but you should be able to get by in most situations. The nice thing is that you can try it out right now on your Windows device to see what your experience would be like on Linux - just make sure you use the same/similar browser you would use on Linux.
The bigger issue with switching to Linux for school is likely going to be non-Microsoft software that one or some of your classes requires you to use that only supports Windows. If you are not able to get it to run with WINE or a Windows VM, you may be stuck running Windows for a few more years.