Microsoft Office Blog by Chris Menard

Excel - Using TextBefore and TextAfter Functions

Using Excel's TEXTBEFORE and TEXTAFTER together. TEXTBEORE and TEXTAFTER work like Flash Fill, the Left and Right functions, but they are easy to use and dynamic.

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. In this guide, we delve into the world of conditional formatting with the help of Excel's Copilot feature.

Creating a PowerPoint Presentation with Microsoft Copilot

Microsoft Copilot is one of the latest features that has caught the attention of PowerPoint users. In this blog, we will explore the capabilities of Copilot and how it can help you create a PowerPoint presentation effortlessly.

Copilot for Excel - Is it Accurate? 11 Tests Performed

Here's a detailed analysis of Microsoft Copilot in Excel. I delve into Copilot's functionalities with a series of tests, emphasizing its precision and capability in handling a variety of tasks within Excel.

Advanced Excel Conditional Formatting with Mixed and Absolute References

We use an advanced method of Conditional Formatting in Excel to identify numbers over a specific value. Unlike the conventional approach, I employ Mixed and Absolute References to enhance precision and flexibility.

March 14, 2024 - Beginner’s Guide to Microsoft Copilot

March 14, 2024 - Join our webinar to explore Microsoft Copilot for Microsoft 365. Discover how administrators can leverage its time-saving features across Word, Excel, PowerPoint, Outlook, and Teams.

Extract Emails from Outlook to Excel using Power Query

Step-by-step tutorial on using Power Query in Excel to extract and format email addresses from Outlook.

April 13, 2024 - Excel Training for MBA Students from the University of Georgia

I'm proud to announce I'll train the University of Georgia MBA students from the Terry College of Business in Excel on Saturday, April 13, 2024. Excel training will be hands-on.

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.

NEW Teams - Two New Features - October 2023

Teams see new posts at bottom and pop-out conversations - two new features in Teams 2.0.

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.

Excel - IF Function using AND and OR

One of my favorite functions is the IF function. The IF function allows you to use true and false conditions. For example, if the value in cell B2 is over $5,000, give them a 2% discount.