Hosted on MSN

Python in Excel isn't just for programmers—4 useful things you can do with it right now

For decades, if you wanted to do heavy data lifting in Excel, your options were nested formulas, VBA macros, or a trip into the Power Query Editor. But with Python now accessible directly from Excel ...
How-To Geek on MSN

I fixed my messy Excel dataset with a single formula

Reshaping wide data makes it easier to use familiar Excel tools like PivotTables and charts.

Automating Excel Bulk Replacement with Python and openpyxl: 3 Steps to Reduce 3 Hours of Company Name Changes Across 200 Files to 5 Minutes

The day I fixed "Company XX" 200 times using Ctrl+HLast October, I had to update the templates for quotes and invoices due to a client's company name change. There were just over 200 files to process.

For those who had ChatGPT write Python code but are stuck in an error loop

Have you ever thought, "I don't know Python, but can't I automate my work by having ChatGPT write the code for me?"In fact, ...

Beyond Excel: Mastering BQL with Python for Smarter Analysis

Unlock deeper analytical capabilities by integrating BQL, Bloomberg’s most advanced data API,  with Python via the BQL Object ...

Here are all the new features Microsoft added to Excel in August 2026Here are all the new features Microsoft added to Excel in August 2026Here are all the new features ...

Excel's August 2026 updates are all about Copilot, bringing new tools for change tracking, data visualization, chat history, and Python analysis.