Formula Completion Files and Copilot Function files
Masterminds Copilot Implementation - June 17, 2026
Microsoft Teams
Microsoft Teams lets you pull all your meeting chats into their own dedicated, collapsible section in the chat list. Here's how to turn it on and move it where you want.
Microsoft Teams
My Microsoft Teams online training is getting a full revamp by July 28, 2026 — a current-look rebuild, better-organized lessons, written steps with every video, more quizzes, and live streams for students.
Microsoft 365 Copilot
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.
Microsoft Excel
Push the Excel COPILOT function with five advanced prompts on a real sales dataset — regional totals, ranking, category comparisons, and finding the top improver by dollars and by percentage — plus how to verify every answer.
Hands-on Excel Training with Chris Menard | Microsoft MVP
Microsoft Excel
Two people can put the exact same amount of money into the market and still end up with different numbers of shares — and different returns when they sell. That comes down to how the money goes in. The two methods are lump sum investing and dollar cost averaging, and I
Free PowerPoint presentation from Chris Menard - Microsoft MVP
Microsoft 365 Copilot
Microsoft 365 Copilot Chat is getting a redesign, and I got it early at the end of May. This is the layout that rolls out to all users in July 2026, with an opt-in toggle available in June if you want to try it sooner. If you use Copilot
Microsoft Excel
Clean one messy Excel dataset two ways — manually and with Power Query — to see exactly when each approach saves you time.
Thoughts, stories and ideas.
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
I wanted to see whether Claude inside Microsoft Excel could handle something visual instead of a formula: adding a column of real, clickable checkboxes. One short prompt, no fiddling with Form Controls — that was the test. Here's how it went, plus the manual fallback and the formula I
Microsoft Teams just added a new Muted section to the chat list that automatically groups your muted meeting chats. Here's how to turn it on, how it behaves, and the one limitation to know about.
Finding duplicates, highlighting them, and removing them is something I do all the time in Excel. There's no single best tool for the job — the right approach depends on whether your data has a unique identifier, whether you need to compare one list or two, and whether you
Use a formula-based conditional formatting rule with a mixed reference to highlight every row where the spend column exceeds the budget column.
I wanted to see how well Claude in Excel can actually clean data — not just a row or two, but a genuinely messy spreadsheet with broken dates, inconsistent states, extra spaces everywhere, dollar signs glued to text, and possible duplicates lurking in the rows. So I built a fictitious order
Microsoft Copilot Cowork is the most exciting addition to Microsoft 365 Copilot I have used in a while. It is a multi-step agent that works across Outlook, Word, PowerPoint, and your other apps at the same time — give it one prompt and it can search your mailbox, build deliverables
Microsoft Copilot in Word has a great new feature that just rolled out: the Legal Agent. It can review a contract, leave clause-level comments, and apply insertions and deletions with track changes — all from a prompt inside Word. I am not an attorney, so consider this a demo of
Microsoft Copilot in Excel just picked up three updates I think you'll want to know about. I caught these on Saturday, May 2nd, 2026, and they change how I use Copilot day to day. Let's walk through each one. Update 1: The Copilot Icon Moved Out
September 13-16, 2026 in Nashville, TN
Two real tests of the Claude add-in for Excel: a cross-sheet XLOOKUP profit calculation, and building an HR spreadsheet from scratch with data validation dropdowns, hidden source lists, and dynamic tables.
Chris Menard - Microsoft MVP