Formula Completion Files and Copilot Function files

I’m excited to share a collection of Excel files from my M365 Copilot presentation delivered on June 17, 2026, for International Legal Technology Association (ILTA). Whether you attended the session or are exploring these topics on your own, this downloadable set is designed to give you hands-on examples that you can open, explore, and immediately apply in your own work.

My name is Chris Menard, and I’m a Microsoft MVP specializing in Microsoft 365, Teams, and Copilot, with a focus on practical, real-world solutions in Excel, Teams, Word, Outlook, and Power Query. As a professional trainer and speaker, I spend my time helping organizations and users simplify complex tasks, improve productivity, and take full advantage of the tools they already own. Everything I teach is built around making your day-to-day work easier and more efficient.

Inside this download, you’ll find a curated set of four Excel files that were used throughout the session.

These four Excel files demonstrate both Microsoft Copilot's Formula Completion and the COPILOT function, giving users practical, hands-on examples of each.

Copilot in Excel - Files

Thanks again for attending the session—or for stopping by to check out these resources. I hope these files provide immediate value and help you take your Copilot in Excel (and Microsoft 365) skills to the next level.

Microsoft 365 Copilot Chat’s New Look: How Work IQ Replaces the Work and Web Toggle

Microsoft 365 Copilot Chat has a redesigned interface built around Work IQ, which replaces the old Work and Web toggle. Learn how to use it, toggle it on and off, and force work-only or web-only answers.

Menard on MicrosoftChris Menard

Microsoft 365 Copilot Updates: Smart Suggestions, Docking, and Shortcut in Word, Excel, and PowerPoint

New Microsoft 365 Copilot updates in Word, Excel, and PowerPoint: smart suggestions on hover, docking the button to the far right, the Alt+C shortcut, and the upcoming Dock to the Ribbon option.

Menard on MicrosoftChris Menard

Auto-Reschedule Conflicting Meetings with Copilot in Outlook

If you have a paid Microsoft 365 Copilot license, there’s a genuinely useful new calendar feature in Outlook: automatic meeting rescheduling. When a conflict arises, Copilot detects it and moves the meeting for you — no manual back-and-forth required. Here’s exactly how to set it up. Requirements

Menard on MicrosoftChris Menard