Heads up, data crunchers and code enthusiasts! Microsoft has just dropped a bombshell: Python is coming to Excel. That’s right, you can now blend Python’s robust data analysis and visualization capabilities with Excel’s tried-and-true features.
The public preview of this game-changing update is available now, and it promises to redefine how you interact with spreadsheets.
Steffan Kinnestrand, GM of Modern Work at Microsoft, laid out the scoop in a recent blog post. “Imagine diving deep into your data using Python’s powerful libraries and then polishing your insights using Excel’s formulas, charts, and PivotTables,” he explained. “It’s now all possible right from the Excel environment you’re already comfortable with.” In short, you can now toggle Python on from the Excel ribbon and unleash advanced data analysis without missing a beat.
Worried about having to install extra software? Don’t be. Excel’s got it all figured out with built-in connectors and Power Query, so Python integrates as smoothly as adding a new worksheet. Even better, Python calculations will run in the Microsoft Cloud, sparing your computer any heavy lifting.
And it’s not just about formulas and PivotTables; the visual storytelling game just got better, too. With Python’s charting libraries like Matplotlib and Seaborn, your Excel sheets can now boast snazzy heatmaps, violin plots, and even swarm plots.
Microsoft has even teamed up with Anaconda, a big name in the data science platform space, to make sure commonly used Python libraries are readily accessible within Excel. It’s pretty much plug-and-play from here on out.
Early adopters, take note: Microsoft is first rolling out this feature to its 365 Insiders in the Beta Channel, and it’s initially for Windows users only. But don’t fret, Mac and other OS users, your time will come. As for pricing, Python functionality in Excel will be part of the Microsoft 365 subscription during the preview period. However, once the public preview stage ends, you’ll need a paid license to access some of these new Python features.
So, there you have it! Python is moving into Excel, and data analysis will never be the same. Whether you’re a Python veteran or an Excel aficionado, this is the perfect opportunity to blend both worlds and take your data projects to the next level. Why not give it a try today?
