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
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
Microsoft Teams
Microsoft Teams is rolling out a fantastic new feature that allows you to customize your display name during meetings. This enhancement is perfect for personalizing your presence and ensuring your name appears just how you want it to. For example, my default name is Menard, Chris, but I prefer Chris
Microsoft Copilot
Microsoft has introduced two game-changing solutions: Copilot Chat and Microsoft 365 Copilot. While these tools share similar names and some functionalities, they serve distinct purposes and offer different capabilities. This article will delve into the key differences between Copilot Chat and Microsoft 365 Copilot, helping you understand which tool
Microsoft Outlook
As a Microsoft Teams and Outlook user, I'm thrilled to share some exciting news that will revolutionize the way we manage our contacts. Microsoft has introduced a new feature that keeps your contacts in Teams and Outlook perfectly synchronized. This enhancement is set to streamline our workflow and
Microsoft Excel
Excel's GROUPBY function is a formula-based alternative to PivotTables that updates automatically and offers more aggregation options — including MEDIAN, MODE, and custom LAMBDA functions. When you need to group by columns that aren't next to each other, HSTACK lets you combine non-adjacent columns into
Microsoft Excel
When you have employee data, customer lists, or inventory records spread across multiple worksheets, identifying duplicates between them can be tricky. The COUNTIF function makes this straightforward — and with a few extra steps, you can add visual formatting and custom labels to make the results even clearer. Understanding COUNTIF Before
Microsoft Word
Have you ever wondered how to effectively use track changes in Microsoft Word? As a Microsoft certified trainer, I'm here to guide you through this powerful feature that can revolutionize your document collaboration process. In this comprehensive guide, we'll explore how to turn on track changes,
SnagIt
Snagit 2025 has arrived, and it's packed with an exciting new feature called Smart Redact. This powerful tool is designed to make your workflow more efficient and secure when dealing with sensitive information. In this blog post, we'll dive deep into the Smart Redact feature, demonstrating
Microsoft Excel
The latest rollout of Copilot in Excel brings an exciting new capability: the ability to effortlessly import data from various sources, including Word documents, PowerPoint files, PDFs, and external websites. This powerful feature promises to streamline your workflow and enhance your data analysis capabilities like never before. The Power of
Microsoft Excel
Excel's Copilot now suggests conditional formatting rules based on your data. Instead of manually writing formatting rules, Copilot analyzes your dataset and offers one-click suggestions — like highlighting dates in a specific year or cells matching certain text. How It Works Open a spreadsheet with data, click in
Microsoft Teams
Microsoft Teams Desktop now lets you control where notification banners appear on screen. By default, notifications show in the bottom right corner, but you can move them to any corner. How to Change the Position Click the three-dot menu (Settings and More) at the top of Teams, then select
Microsoft Outlook
In the new Outlook, clicking New to compose a message opens it in a side panel rather than a separate window. If you find yourself constantly clicking "Open in New Window," there is a setting to make pop-out the default. Change the Default to Pop-Out Go