Excel FILTER with UNIQUE and TRANSPOSE: Build Dynamic Lists

Turn a flat list of names and departments into a column per department that updates on its own. UNIQUE pulls the distinct departments, TRANSPOSE turns them into headers, and FILTER drops the right names underneath each one.

RIP =COPILOT(): Excel's Shortest-Lived Function Just Got Grounded

RIP =COPILOT(): Why Microsoft Is Retiring Excel's Newest Function Before It Ever Really Took Off. If you've been playing around with the =COPILOT() function in Excel, mark your calendar: September 14, 2026 is its last day. Microsoft quietly updated its support documentation with the retirement notice,

Excel XLOOKUP: Why Tables Are Better Than Ranges for Lookups

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.

Microsoft Teams Live Captions: A Quick Walkthrough

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

Prepare for Questions with Microsoft Copilot in 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: Microsoft 365 Copilot New Features — Thursday, August 6th at Noon ET

Join me live on Thursday, August 6th at noon ET as I walk through the newest features in Microsoft 365 Copilot — no registration required.

How to Record a Video Clip and Your Screen in 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.

Microsoft Teams Is Getting a Major Meeting Controls Redesign

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

Excel FILTER Function: Filter and Sort Data with Ease

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.

Save Hours on Outlook Replies with Microsoft Copilot

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.

Honored to Be Named a Microsoft MVP for the Second Year in a Row

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.

How to Test Your Mic and Speaker Before a Microsoft Teams Meeting

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.