Microsoft Excel
Optimize Microsoft Excel Files for Better Performance
Did you know that one of the main culprits behind sluggish Excel files is unnecessary formatting?
Chris Menard
Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
Microsoft Teams
Maximizing Efficiency in Teams Meetings with Copilot: A Comprehensive Guide
Introduction to Copilot in Teams Meetings In today's fast-paced world, staying updated and efficient in meetings is more crucial than ever. That's where the feature "copilot in Teams meetings" comes into play. This innovative tool is designed to enhance your meeting experience by offering
Microsoft Excel
Excel - Using TextBefore and TextAfter Functions
In Microsoft 365, there are several handy functions that can make data manipulation and analysis much easier. Today, I want to focus on two of my favorite functions - TEXTBEFORE and TEXTAFTER. These text functions are exclusive to Microsoft 365 and can help you extract specific parts of a text
Microsoft PowerPoint
Creating a PowerPoint Presentation with Microsoft Copilot
Getting Started with Copilot To utilize Copilot, you can simply open PowerPoint and navigate to the Home tab. It's important to note that Copilot is located next to the Designer feature. Once you have found Copilot, you can begin using it to create stunning presentations. Creating a Presentation
Microsoft Excel
Mastering Conditional Formatting in Excel with Copilot: A Step-by-Step Guide
Mastering Excel is a critical skill for many professionals across various industries. Among the many features Excel offers, conditional formatting stands out for its ability to visually highlight important data. This feature enables users to set rules that automatically format cells based on their content, making it easier to analyze
Microsoft Excel
Copilot for Excel - Is it Accurate? 11 Tests Performed
Introduction to Copilot in Excel Excel has long been the go-to tool for managing and analyzing data. Now, with the introduction of Copilot in Excel, users have a powerful new assistant to help streamline their workflows. Copilot in Excel is designed to understand natural language queries, making it easier than
Microsoft Teams
Microsoft Teams: Workarounds for the Save Message Feature
Microsoft Teams is a powerful collaboration tool that offers a wide range of features to enhance productivity and communication within organizations. However, as with any software, there are sometimes features that were available in previous versions that do not carry over to newer versions. In this blog post, we will
Microsoft Excel
Advanced Excel Conditional Formatting with Mixed and Absolute References
The Power of Conditional Formatting In this blog post, we will explore the concept of Conditional Formatting in Microsoft Excel. Conditional formatting is a powerful feature that allows users to highlight cells that meet specific criteria, highlight numbers over or below the average, and use Data Bars. By using conditional
Microsoft Excel
Extract Emails from Outlook to Excel using Power Query
Using Power Query in Excel to Manage Email Addresses If you have emails in Outlook and need to extract the email addresses, it can be daunting, especially when dealing with many emails. In this blog, we will explore how to use Power Query to efficiently break down email addresses from
Microsoft Excel
Excel - Combine Multiple Tables - Relationships (PivotTables) and XLOOKUP
You can set up a relationship with two or more tables in Excel to create a PivotTable. XLOOKUP and VLOOOKUP also work, but you can skip those great functions and set up Relationships. For example, one Excel table contains the Employee ID and name. A second table contains the Employee
Microsoft Teams
NEW Teams - Two New Features - October 2023
NEW Teams was released in preview mode in March 2023. There are currently two versions of Teams, and depending on your settings, you can easily switch between them. Classic Teams and New Teams (aka Teams 2.0). At some point in 2024, Classic Teams will go away. Microsoft keeps launching
Microsoft Excel
Excel PivotTable - Table vs Range as Source - Which is better?
In Excel, a PivotTable can be based on a Range or on a Table. I encourage you to base your PivotTable on a Table. Initially, both a range and table will be correct. The issue comes when you add data to the source and update or Refresh your PivotTable. If