The recent announcement from Microsoft that they have now integrated Python into it’s Excel spreadsheet software has opened up a wealth of new applications for data analytics, automation and number ...

Ever since Microsoft introduced Python in Excel, I have treated it as a ‘someday’ project. I knew Python integration was the ...

If you've ever wished Excel could handle text patterns the way Python or JavaScript does, these functions deliver exactly ...

If you work with data much, you don’t need a statistical model to predict that the odds of consistently getting data in the format you need for analysis are pretty low. Those who do a great deal of ...

If you’ve been feeling constrained by Microsoft Excel’s methods for manipulating data, you’re in luck—Python can now be used within your spreadsheets. The inclusion of the popular programming language ...

Discover 17 new Excel features and functions for 2026, so you track edits and data faster. Including auto-refreshing pivots ...