Microsoft Excel
Copilot in Excel can now read a column of free-text answers — survey responses, feedback, help desk tickets — and summarize it into clean categories with a live count. Here is the exact prompt and workflow.
Microsoft Excel
I test Excel Formula Completion on real IF functions - a commission formula with absolute references and a nested IF for letter grades. Here's how Copilot did.
Microsoft Excel
Push the Excel COPILOT function with five advanced prompts on a real sales dataset — regional totals, ranking, category comparisons, and finding the top improver by dollars and by percentage — plus how to verify every answer.
Microsoft Excel
Two people can put the exact same amount of money into the market and still end up with different numbers of shares — and different returns when they sell. That comes down to how the money goes in. The two methods are lump sum investing and dollar cost averaging, and I
Microsoft Excel
Clean one messy Excel dataset two ways — manually and with Power Query — to see exactly when each approach saves you time.
Microsoft Excel
I wanted to see whether Claude inside Microsoft Excel could handle something visual instead of a formula: adding a column of real, clickable checkboxes. One short prompt, no fiddling with Form Controls — that was the test. Here's how it went, plus the manual fallback and the formula I
Microsoft Excel
Finding duplicates, highlighting them, and removing them is something I do all the time in Excel. There's no single best tool for the job — the right approach depends on whether your data has a unique identifier, whether you need to compare one list or two, and whether you
Microsoft Excel
Use a formula-based conditional formatting rule with a mixed reference to highlight every row where the spend column exceeds the budget column.
Microsoft Excel
I wanted to see how well Claude in Excel can actually clean data — not just a row or two, but a genuinely messy spreadsheet with broken dates, inconsistent states, extra spaces everywhere, dollar signs glued to text, and possible duplicates lurking in the rows. So I built a fictitious order
Microsoft Excel
Microsoft Copilot in Excel just picked up three updates I think you'll want to know about. I caught these on Saturday, May 2nd, 2026, and they change how I use Copilot day to day. Let's walk through each one. Update 1: The Copilot Icon Moved Out
Microsoft Excel
Two real tests of the Claude add-in for Excel: a cross-sheet XLOOKUP profit calculation, and building an HR spreadsheet from scratch with data validation dropdowns, hidden source lists, and dynamic tables.
Microsoft Excel
Every serious Excel user should have Go To Special in their toolkit. It is one of the fastest ways to find blanks, formulas, constants, or other specific cell types in a worksheet — and it pairs beautifully with the new Excel COPILOT function when your data needs more than a quick