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 Works The syntax
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
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
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
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
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
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
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'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
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
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. The
Microsoft Excel
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