VLOOKUP has been the go-to function for looking up data in Excel for years, but it comes with limitations. You can only ...

Explore Excel’s new AI-powered tools and productivity features in the Fall 2025 update. Smarter, faster, and more intuitive ...

Q. I read your August 2022 JofA article about changing the case of text in Excel to upper, lower, and proper, but some of my data comes in sentence form. Is there any way to convert those text strings ...

Learn how to add, configure and use checkboxes in Excel to create interactive task lists and trigger formatting without relying on macros. Recently, Microsoft has introduced the ability to add ...

Here's how to build smarter checklists in Excel using checkboxes, conditional formatting and task dependencies to help with multi-step processes. In my previous article in this series, I walked you ...

What if you could take the chaos of a sprawling Excel spreadsheet and distill it into exactly the information you need—no fluff, no manual sifting, just precision? For anyone who’s ever wrestled with ...

Office Agent doesn’t run through all the steps as Agent Mode, but Microsoft believes it offers a dramatic improvement over ...

To try Agent Mode in Excel, you need to get the Excel Labs add-in and choose Agent Mode. In Word, you can just open Copilot ...