Microsoft Office Blog by Chris Menard

How to Remove Duplicates Running Left to Right in Excel Using Power Query

Removing duplicates in Excel is a common task, but it can be challenging when the duplicates are running horizontally (left to right) instead of vertically. In this blog post, we'll explore an advanced Excel technique using Power Query to efficiently remove duplicates across rows. This method is particularly useful when dealing with complex data structures where traditional duplicate removal methods fall short.

Teams: Improved People Search - November 2024

Microsoft Teams has rolled out an enhanced people search feature, providing users with more efficient ways to find and filter content related to specific individuals. This update, released in November 2024, offers a streamlined approach to searching for messages, files, and conversations associated with team members. Let's explore how to make the most of this new functionality.

Follow a Meeting" Feature in Microsoft Outlook

The "Follow a Meeting" option allows users to indicate that they cannot attend a meeting but still want to receive information about it. This feature is particularly useful for staying in the loop on important discussions and decisions without physically being present in the meeting.

Microsoft Teams: How to Add Your Name Pronunciation (NEW Feature - December 2024)

Microsoft Teams has introduced a new feature that allows users to record and share the pronunciation of their names. This helpful tool can prevent mispronunciations and improve communication among colleagues.

5 Essential Excel Tips Everyone Should Know

Excel is a powerful tool used across various industries, and mastering its features can significantly boost your productivity. In this blog post, we'll explore five essential Excel tips that every user should know.

Become an Expert at Using the TOCOL Function in Excel to Merge Columns

The TOCOL function in Excel is a powerful tool for combining data from multiple columns into a single column.

2025 Upcoming Public Speaking Events with Chris Menard

Discover my exciting public speaking events for 2025! Join me for sessions on mastering Excel, Microsoft 365 productivity tips, and advanced Excel training at conferences in Athens, GA, Boise, ID, and the University of Georgia. Learn more about these empowering workshops designed for administrative professionals, support staff, and Executive MBA students.

Exploring the New Chat & Channels Experience in Microsoft Teams

Explore the new integrated chat and channels experience in Microsoft Teams. Learn how to navigate the updated interface and maximize your productivity.

Copilot for Excel: Transforming Complex Data with Advanced Delimiter Separation

Discover how Microsoft 365 Copilot revolutionizes Excel data management by automating complex tasks like delimiter separation. Explore the benefits and a step-by-step guide in our latest blog post.

Navigating the New Microsoft Teams Refreshed View: A Comprehensive Guide

Microsoft Teams has introduced an exciting new feature in October 2024 called the "Refreshed View of all your Teams and Channels page." This centralized hub is designed to help users manage their teams and channels more efficiently. In this comprehensive guide, we'll explore how to access and utilize this new feature, including its filtering options, sorting capabilities, and search functionality.

Mastering Excel Slicers: A Comprehensive Guide

Excel slicers are powerful tools that enhance data filtering in Microsoft Excel, making it easier to visualize and analyze your data. In this blog, we will explore how to create and effectively use slicers, as well as their advantages and limitations in comparison to traditional filters.

Advanced Text-Splitting with Copilot in Excel

Excel's Copilot has evolved significantly with Wave 2, introducing powerful capabilities for advanced text manipulation. This blog post explores how to leverage Copilot for complex text-splitting tasks, specifically focusing on separating location data into distinct columns while handling special cases.