Microsoft Excel
The FILTER function spills back only the rows that match a condition. Three worked examples: filter by quantity, combine SORT with FILTER for sorted results, and build a between filter with two conditions.
Microsoft Outlook
Reply to email faster in Outlook with Copilot — use one-click suggested drafts for quick replies, or the Copilot task pane and Draft Assistant when you need to add details, cities, and venues the sender never mentioned.
MVPBUZZ
July 15, 2026 - Chris Menard has been named a Microsoft MVP for the second year in a row, recognized for his work in Microsoft 365, Copilot, and Teams. Here's what the award means and how he's giving back to the community.
Microsoft Teams
Microsoft Teams now lets you test your microphone and speaker right from the join screen. Here's where the Test mic and speaker link is and how to run both checks in seconds.
Windows
Windows 11 includes a free screen recorder inside the Snipping Tool. Here's how to record your screen with audio, choose the capture area, check your microphone, and save or share the result.
Microsoft Outlook
Use Copilot in the new Outlook and Outlook on the web to add 30-minute prep blocks and 15-minute hold blocks around your calendar events — with one specific prompt.
Microsoft 365 Copilot
Microsoft 365 Copilot users are noticing a major change: the model picker no longer shows options like GPT‑5.5 and other models.
Microsoft Excel
Copilot in Excel can now read a column of free-text answers — survey responses, feedback, help desk tickets — and summarize it into clean categories with a live count. Here is the exact prompt and workflow.
Microsoft Copilot
Licensed Copilot Chat now has a toggle to switch between the new Work IQ look and the classic Work and Web view. Here is where it lives and how it works.
Thoughts, stories and ideas.
I test Excel Formula Completion on real IF functions - a commission formula with absolute references and a nested IF for letter grades. Here's how Copilot did.
When the word Update appears in the top-right corner of Teams desktop, click it — except in two situations. Here's where the button lives, how to update, and what happens.
Masterminds Copilot Implementation - June 17, 2026
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.
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.
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.
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
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 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
Clean one messy Excel dataset two ways — manually and with Power Query — to see exactly when each approach saves you time.
