Allow Excel Macros to be written in PowerShell.

It would also be amazing if it could be used as an alternative to field functions such as "=PRODUCT(A1:A10))"

I believe that Microsoft Excel naively supporting PowerShell as a 21st century alternative to VBA would be the most beneficial change made to the software since release.

Almost all Microsoft products are becoming PowerShell integrated, yet Office remains only supporting VBA.

VBA is an archaic procedural language which despite its ambivalent love from the community, seems to have little to no place in the modern world.

PowerShell can directly interact with COM objects eaxctly just as VBA does, and so much more. PowerShell macros would be incredibly useful and utterly transform the scope of work which Excel is used for.

Additionally, this would be one step closer to unifying Microsoft products.