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
How to Use Claude in Excel to Clean Messy Data (Step-by-Step Walkthrough)
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
Excel Copilot Got 3 Updates: New Icon Location, Preview Mode & Anthropic Claude Models
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
Claude in Excel: Cross-Sheet XLOOKUP and Building a Data-Validated HR Spreadsheet from Scratch
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
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
Microsoft Excel
Power Query: Remove Extra Spaces in the Middle of Words (Beyond TRIM)
Extra spaces are one of the most common data problems in Excel — leading spaces, trailing spaces, and the trickiest of all, extra spaces in the middle of words. The TRIM function handles all three. But what happens when you switch to Power Query for a larger data cleanup? Power Query&
Microsoft Excel
Copilot in Excel: When to Use a PivotTable vs Functions
Copilot in Excel can create PivotTables in seconds, and that is great for basic summaries. But when you need calculations that go beyond what a PivotTable can show — median, second highest, third highest — functions are the better approach. Here is how to use Copilot for both, and when to choose
Microsoft Excel
Excel TRANSLATE Function: Translate Text Directly in Your Spreadsheet
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 Works The syntax
Microsoft Excel
Preview: Excel COPILOT() Function and Formula Completion in Action
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
IHG Points vs. Money: How to Save Over 50% on Hotel Rooms Using Excel to Compare
If you're an IHG One Rewards member, you might be leaving serious money on the table by paying cash for hotel rooms. Let me walk you through a real example where I saved over 50% — more than $1,900 — on a four-night stay at one of Washington, DC&
Microsoft Excel
Excel Copilot Now Works on Local Files (Edit with Copilot)
Microsoft 365 Copilot in Excel just received a meaningful update. What was previously called Agent mode is now called Edit with Copilot — and the big news is that it now works on local Excel files, not just files stored in OneDrive or SharePoint. Open Edit with Copilot in Excel Start
Microsoft Excel
How to Clean Messy Data in Excel with Agent Mode and One Prompt
Excel's desktop version now has Agent Mode in Copilot, and it is incredible. I've already used it to build a complete dashboard automatically, and now I want to show you how it can clean messy data with a single prompt. Identify the Data Problems In this