Excel Just Got a Brain: Copilot Function & Formula Completion - Live Stream

Live Stream on YouTube and LinkedIn - March 18, 2026

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

How to Share Copilot Prompts in Microsoft Teams

Microsoft 365 Copilot now lets you share prompts and AI-generated responses directly into a Microsoft Teams group chat. Instead of copying and pasting results, you can send them to your team with a single click and start a conversation around the output. This feature requires a paid Microsoft 365 Copilot

Use Copilot to Translate Your PowerPoint Presentations Quickly

What this translation feature does and why it matters Copilot in Microsoft 365 can now translate entire presentations into another language with a few clicks. I tried it in PowerPoint on the web (it also appears in the desktop app) and found the experience fast and straightforward. Instead of copying

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

How to Ask Questions About Documents Using Copilot in Microsoft Word

Microsoft 365 Copilot in Word can do more than just draft content. You can use it to extract specific information from documents, ask questions about what is in them, and even generate standalone files from the answers. In this walkthrough, Chris demonstrates how to query an employee handbook about dress

Excel FORMULA Completion vs COPILOT(): When to Use Each Feature

I use both Formula Completion and the Copilot function in Excel every week. They require a paid Microsoft 365 Copilot license. They solve different problems, and when you combine them, you can move from repetitive calculations to higher-level text analysis and data cleanup in minutes. Below, I explain what each

Smart Reply Suggestions in Outlook with Microsoft Copilot

If you have a Microsoft 365 Copilot license, there is a small Outlook feature that cuts the time I spend replying to email by a huge margin. I use it every day at my full-time job, and it genuinely saves me minutes—sometimes hours—every week. YouTube Video - Outlook

How to Combine UNIQUE, CHOOSECOLS, COUNTA, and SORT in Excel

If you analyze data in Excel, the UNIQUE function is one of the quickest ways to cut through noise and see exactly what you have. I rely on UNIQUE every day, and when I pair it with SORT, COUNTA, and CHOOSECOLS, it becomes a powerful tool for cleanup and analysis.

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

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

How to Use the Future Value function Correctly in Excel (Monthly Compounding Fix)

If you model investments in Excel, the future value function is one of the most useful tools you have. The problem is a small but common mistake: dividing an annual return by 12 to get the monthly rate. That shortcut breaks the math when compounding is involved, leading to a