Microsoft Excel
Excel's New List Feature: Filter and Count Multiple Items in One Cell
Excel can now hold a list of items in one cell. Create lists with Ctrl+J, filter by a single name, and summarize them with FLATTEN, UNIQUE, SORT, and COUNTIF.
Microsoft Excel
Excel COPILOT Function Is Going Away: Can Copilot Dynamic Action Button Replace It?
The COPILOT function retires on September 14, 2026. I ran three real data tasks — sentiment ratings, ZIP code extraction, and address cleanup — through both the function and the Copilot Dynamic Action Button (DAB) in Excel to see what you actually lose.
Microsoft Excel
Excel FILTER with UNIQUE and TRANSPOSE: Build Dynamic Lists
Turn a flat list of names and departments into a column per department that updates on its own. UNIQUE pulls the distinct departments, TRANSPOSE turns them into headers, and FILTER drops the right names underneath each one.
Microsoft Excel
Excel XLOOKUP: Why Tables Are Better Than Ranges for Lookups
The same XLOOKUP built two ways: against a plain range with absolute references, then against named tables with structured references. See why the table version survives new data without an edit.
Microsoft Excel
Excel FILTER Function: Filter and Sort Data with Ease
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
Summarize Text Columns in Excel with Copilot to Categorize Survey Responses
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
Excel Formula Completion with IF Functions: Commissions, Grades, and Copilot
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
Excel COPILOT Function: Advanced Prompts with Real Examples
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
How to Add Checkboxes in Excel with Claude AI (and Count Them with COUNTIF)
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
Find and Remove Duplicates in Excel: 3 Methods with UNIQUE, VSTACK, and TEXTJOIN
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
Excel Conditional Formatting: Highlight Rows Where Spend Goes Over Budget
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
Fix Blanks in Excel Data with GO TO SPECIAL and the COPILOT Function
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