Table of Contents * đ Why this method works and when I use it * đ Setting up the table * đ Extract distinct values with UNIQUE * âď¸ Sort the unique list with SORT * đ˘ Count occurrences using COUNTIF * â Why tables beat ranges for this task * đ When to use this instead of a pivot table * đ§ Quick checklist to
Writing formulas in Excel can be time-consuming and challenging, even for experienced users. Selecting the right function, referencing the correct cells, and ensuring proper syntax often slows down workflows and leads to errors. Many users spend extra time troubleshooting mistakes, searching for examples, or trying to recall the exact formula
I tested how well Excel's formula completion with Copilot handles a multi-step calculation that would normally require a nested function. The goal was simple: calculate profit by subtracting the total cost of units sold from total revenue, with unit costs stored in a separate lookup table. Instead of
Microsoft Teams has a great Copilot feature. A Microsoft 365 license is required for this feature. In a Teams meeting, I need AI assistance during a conversation, but the participants do not want the call recorded or transcribed. There are plenty of situations where privacy matters: a vendor asks for
November 4, 2025 Microsoft MVP and productivity expert Chris Menard will be presenting a highly anticipated session titled âExecutive Insights: Harnessing Excel for Strategic Analysisâ at the EA Ignite Conference, held at the Renaissance Nashville Hotel. This premier event, running from November 3â5, 2025, is tailored for executive assistants
Chris Menard will present âMastering Microsoft 365 Copilotâ at EA Ignite in Nashville on Nov 3, 2025. Learn how Copilot boosts productivity in Word, Excel, PowerPoint, Outlook, and Teams during this hands-on session.
How to use the newly returned feature that lets you save Chat and Channel Messages in Teams so you can keep important conversations at your fingertips.
OneDrive Request Files feature allows you to collect files from people inside or outside your organization, without letting those people see anyone elseâs uploads.
As a Microsoft MVP and certified trainer, Iâm always excited to share the latest productivity tools that help you work smarter. If youâre a frequent Microsoft Teams user, youâll be thrilled to hear about the new Teams Follow Threads feature rolling out in public preview as of
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
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 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 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 might
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 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
Introduction to Copilot in Excel Excel continues to evolve, and one of its most exciting new features is Copilot. This AI-powered assistant is revolutionizing the way we work with data, making complex tasks simpler and more intuitive. Today, we're going to explore how Copilot can help us combine
Microsoft Excel
Microsoft Excel is a powerhouse of features, yet many users are unaware of how much easier Copilot can make in their lives. Imagine having a personal assistant right within Excel, ready to provide insights, shortcuts, and solutions at your command. That's precisely what Copilot offers, and today, we&