pandas is the premier library for data analysis in Python. Here are some advanced things I like to do with pandas DataFrames to take my analysis to the next level. Change the index of a DataFrame On a ...

I used to pride myself on being an Excel wizard, but the reality was that I was spending more time fixing broken links and debugging #REF! errors than actually analyzing data. That cycle ended the ...

Have you ever panicked because you updated your source data in Excel, but the pivot table results remained old? I once turned pale when it was pointed out to me during a meeting. Here are the causes ...

Compare the best free Microsoft Excel alternatives for 2026, including features, pricing, pros and cons, and use cases for each spreadsheet tool. The kinds of features you need from your spreadsheet ...

In my previous note, I wrote about how I studied Python for about 1000 hours. I automated Excel tasks with Python, turning work that took hours into something that finished in seconds. After that, ...

Modern business intelligence demands speed, and utilizing AI tools for Excel is the ultimate way to hyper-charge your data workflows this year.

Expert at the Conservancy of Southwest Florida topped their own record for the most tonnage of Burmese python removed from the wildlife.

A curated collection of Agent Skills for working with PyXLL, the Python Excel add-in. These skills help AI agents understand and use PyXLL APIs accurately. These skills are not slash commands or ...