Over the past six months, we’ve learned how AI can be used for many tasks: creating art, powering a sophisticated chatbot, and so on. But what if you could use it to actually assist you in your job?

I traded the static results of Flash Fill for dynamic formulas that update automatically.

In September 2023, Microsoft revealed it was launching a Python Editor add-in program for its Excel spreadsheet app in Windows. The optional and experimental add-in came from its Excel Labs division.

BYROW replaces thousands of table formulas with one spill formula, making spreadsheets leaner and much more robust.

Q. I usually like Excel PivotTables, but because they don’t allow me to do certain things, such as delete cells or insert new columns or rows, I’m wondering if there is a reasonable alternative? A.