However, with native Python integration with Excel, users will be able to use the new “PY” function to input Python code directly into Excel cells and perform tasks such as data cleaning ...

The ability for users to enter Python code directly into Excel columns using the newly created “=PY” function is the main highlight. With this feature, Python has found a home among Excel ...

Back in 2020, Reddit user /u/KrakenOfLakeZurich created a Sudoku solver in Microsoft Excel. It only uses formulae and conditional formatting, and it's available for both Excel and LibreOffice Calc.