Microsoft Excel
The FILTER function spills back only the rows that match a condition. Three worked examples: filter by quantity, combine SORT with FILTER for sorted results, and build a between filter with two conditions.
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.