Microsoft Excel
The same XLOOKUP built two ways: against a plain range with absolute references, then against named tables with structured references. See why the table version survives new data without an edit.
If you're not using live captions in Teams meetings yet, here's a quick rundown of what's possible — it's more customizable than most people realize. Why Turn On Live Captions? Live captions in Microsoft Teams are one of the most underused features in
Microsoft PowerPoint
Microsoft Copilot's new Prepare for questions skill in PowerPoint reads your whole deck and predicts the objections your audience will raise, with slide-level evidence for each one.
Join me live on Thursday, August 6th at noon ET as I walk through the newest features in Microsoft 365 Copilot — no registration required.
Microsoft Teams
Microsoft Teams video clips now record your screen and run up to five minutes. Here's where the feature lives, how to set up the camera bubble, and how to trim, send, and download the clip.
If you spend your day in Microsoft Teams meetings, get ready for a noticeable change. Microsoft is rolling out a redesigned meeting experience that simplifies the meeting toolbar, makes screen sharing safer, and gives users more control over the arrangement of meeting buttons. The goal is straightforward: reduce accidental clicks
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.
Thoughts, stories and ideas.
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 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.
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 users are noticing a major change: the model picker no longer shows options like GPT‑5.5 and other models.
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.
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.
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.
