Microsoft Excel
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
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
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
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
Microsoft Excel
Microsoft has added a built-in TRANSLATE function to Excel that lets you translate text between languages directly in your spreadsheet — no copy-pasting into Google Translate or third-party tools. In this tutorial, Chris Menard demonstrates how to use this powerful new function. YouTube Video How the TRANSLATE Function
Microsoft Excel
Live Stream on M365 Copilot Function and Formula Completion in Excel. Registration is NOT required. Just join at noon ET on 03/18/2026
Microsoft Excel
Excel's REGEXEXTRACT function lets you pull numbers (or any pattern) out of a text string using regular expressions. Unlike functions like TEXTAFTER or TEXTBEFORE that depend on consistent delimiters, REGEXEXTRACT works with messy, inconsistent data — it finds the pattern wherever it appears. In this walkthrough, you'll