Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
Microsoft Excel
When your Excel data has multiple values crammed into a single cell — like office locations separated by commas — sorting and filtering become impossible. Power Query can split those values into separate rows, giving you clean, usable data. The Problem: Comma-Separated Values in One Cell Consider a table with employee names,
Microsoft Outlook
Managing emails efficiently is crucial, especially when it comes to handling attachments. I demonstrate an exciting new feature that has rolled out in Microsoft Outlook’s Copilot — the ability to summarize Outlook attachments with Copilot. While Copilot has long been capable of summarizing email bodies, this new enhancement now extends
Microsoft Excel
When multiple people work on the same Excel file, filtering and sorting can cause conflicts — one person's filter changes what everyone else sees. Sheet View solves this by allowing each person to create a personalized view of the data without affecting anyone else. What Is Sheet View? Sheet
Microsoft
Microsoft Teams now has a built-in countdown timer for meetings. Available starting July 2025, it lets you set a visible countdown that all participants can see — useful for keeping presentations, breakout discussions, and Q&A sessions on schedule. How to Access the Timer During a Teams meeting, click the
Microsoft Copilot
If you're a Microsoft 365 Copilot user, you're in for a treat. This tool offers a feature that can significantly streamline your workflow by turning a simple list of names into a comprehensive list of email addresses. In this article, we'll explore how to
Microsoft Excel
Extra spaces in Excel data cause real problems — inconsistent sorting, broken lookups, and formulas that return unexpected results. The tricky part is that extra spaces are invisible. Here's how to use conditional formatting with the TRIM function to find them, and then fix them. The Problem: Hidden Extra
Microsoft Teams
Microsoft Teams is a powerful collaboration tool, but navigating through numerous teams and channels can sometimes be overwhelming. In this guide, we'll explore how you can streamline your experience by focusing on channels alone, without the clutter of team names. This is particularly useful for users who want
Microsoft Excel
Handling data efficiently is crucial. Whether you're a business analyst, an administrative professional, a data scientist, or simply someone who deals with spreadsheets regularly, having the right tools can make all the difference. Enter Microsoft Copilot, a revolutionary tool designed to streamline data cleaning in Excel. In this
Microsoft Excel
Starting in May 2025, Microsoft Excel's Copilot will have a new game-changing feature: It will allow users to create worksheets from prompts. This innovative tool simplifies data management by generating tables and workbooks through intuitive prompts. This article will explore how to use Excel Copilot to maximize efficiency
Microsoft Word
Microsoft Copilot continues to evolve, bringing powerful new capabilities to improve productivity in Word. One of the most exciting recent updates is the ability to reference an entire folder in Copilot for Word instead of being limited to referencing individual files. Alongside this, Copilot now supports working with massive documents
Microsoft Word
As a Microsoft Word user, have you ever found yourself faced with a list of numbers that need to be added up quickly? Perhaps you've resorted to manually calculating them or exporting the data to Excel for a simple sum. Well, I'm excited to share with
Microsoft Excel
If someone sends you Excel data where they have manually added total rows for each group, it causes real problems with PivotTables, sorting, and filtering. Here are three ways to handle it. YouTube Video Method 1: PivotTable with Filtering Insert a PivotTable from the data (Insert → PivotTable). Add Rep to