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.

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, today's generative AI is quite capable. Just by telling it, "I want to ...

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 ...

Stopping Broken Inputs Early in Excel Automation: Python XLSX Inspection and Negative Testing

Python XLSX Inspection and Negative Testing What is scary about Excel automation is not just that the process might crash ...

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.
How-To Geek on MSN

6 everyday Excel tricks I discovered too late (but learned in seconds)

From duplicating worksheets to selecting cells, these simple tricks made me realize I'd been doing things the hard way.