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,
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
Microsoft Excel
Excel Copilot AGENT MODE: Build Dashboards and Apply Formatting Hands-Free
Microsoft is rolling out Agent Mode for Copilot in Excel, and it represents a major step forward from the standard Copilot experience. Agent Mode doesn't just suggest changes—it executes them directly, without requiring you to click Apply after every action. In this guide, we walk through where
Microsoft Excel
How to Extract Numbers from Text in Excel with REGEXEXTRACT
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
Microsoft Excel
I Asked Microsoft Copilot to Calculate My Taxes — Here's What Happened
Can Microsoft Copilot accurately calculate your federal taxes? I put it to the test by first walking through a manual tax calculation in Excel using the 2025 federal tax brackets, then asking Copilot the same question to compare results. Part 1: Manual Tax Calculation in Excel The process starts with
Microsoft Excel
Excel Formula Completion: How to Extract Zip Codes from Text with REGEXEXTRACT
Excel's Formula Completion feature can write formulas for you. Just press the equal sign, and Excel suggests the formula based on your data and column headers. In this tutorial, I demonstrate how it works by tackling a common challenge: extracting zip codes from messy address data where the
Microsoft Excel
How to Convert Seconds to Hours, Minutes, and Seconds in Excel
If you have a column of raw seconds in Excel — from video durations, call logs, workout times, or data exports — you need the right formula and formatting to display them as actual time values. Chris walks through the correct approach and explains why the obvious method doesn't work.
Microsoft Excel
Using Copilot's Think Deeper Mode for Financial Calculations and Investment Projections
Microsoft 365 Copilot Chat now has a "Think Deeper" mode designed for complex, multi-step problems. I demonstrates it with a real financial scenario: calculating investment returns and projecting future account values with different contribution amounts. The New Modes in Copilot Chat Copilot Chat offers multiple processing modes.
Microsoft Excel
How to Add Filter by Selection to Excel's Quick Access Toolbar
Excel's Filter by Selection feature lets you click a cell and instantly filter the entire column to show only matching values — no dropdown menus needed. The catch is that it's hidden by default. Here's how to add it to your Quick Access Toolbar for
Microsoft Excel
Count Unique Values in Excel with UNIQUE, SORT, and COUNTIF Functions Tutorial
Table of Contents * 📋 Why this method works and when I use it * 📋 Setting up the table * 🔎 Extract distinct values with UNIQUE * ↕️ Sort the unique list with SORT * 🔢 Count occurrences using COUNTIF * ✅ Why tables beat ranges for this task * 🔁 When to use this instead of a pivot table * 🔧 Quick checklist to