While Excel offers many formatting options to make your workbook visually appealing, manually formatting large datasets can be incredibly tedious. But Python can automate it with ease.

Microsoft Corp. is releasing a new version of Excel that will enable users to write and run Python code directly in the spreadsheet editor’s interface. Stefan Kinnestrand, a general manager for ...