public speaking
Excel Just Got a Brain: Copilot Function & Formula Completion - Live Stream
Live Stream on YouTube and LinkedIn - March 18, 2026
Chris Menard
Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
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 365 Copilot
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
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 Word
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
Microsoft Copilot
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
excel
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.
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
excel
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