Microsoft Office Blog by Chris Menard

Teams - Delete an Entire Chat

Teams Delete Entire Chat is available! You will be able to delete the entire chat for a one-on-one chat or group chat.

Chris Menard's YouTube channel hits 43,000 Subscriber - November 2022

Chris Menard's YouTube channel hit 43,000 subscribers in November 2022. During the month of November, 11 videos were published.

Excel - Turn on Multiple Filters in a PivotTable

Filter in PivotTables only allows one filter by default. To filter by more than one field, you need to turn on the PivotTable Option - Totals and Filters tab and check Allow multiple filters per field.

American Society of Administrative Professionals - Microsoft 365 - Popular topics from my November 2022 session

I presented a Microsoft 365 session to over 500 Administrative Professionals this past week. Here are videos of some of my most popular topics.

PivotTables - 3 Annoying Things FIXED!

PivotTables are one of the best features in Excel. PivotTables allow you to summarize, analyze and chart complex data. There are 3 annoying things in PivotTables that users always ask me about.

Excel Chart Maps used with the Geography Data Type

Combine the Geography Data type with a Chart Map. The Geography Data type is located on the Data tab, and Chart Map is on the Insert tab with the other chart types.

CTRL + Shift + V to Paste Plain Text in Excel - New feature coming soon

Have you ever copied from a website and tried to paste it into Excel? It isn't a pretty picture. Excel has a new keyboard shortcut coming out soon. Using CTRL + SHIFT + V will paste plain text.

Excel - using the Scenario Manager to track house payments with skyrocketing mortgage rates

For potential homeowners, 1 year makes a HUGE difference. In 2021, we saw some of the lowest mortgage rates in the last 30 years. In July 2021, the average rate on 30-Year Fixed-Rate Mortgages was 2.87% (source FreddieMac). Today, July 2022, we are looking at rates around 5.8%.

YouTube Channel hits 42,000 subscribers

Chris Menard's YouTube channel hits 42,000 subscribers on October 30, 2022

Excel Images - Two New Features - IMAGE function and Data from Image

Excel has two new image-related features coming out. In this video, a preview of my teaching session at ASAP (American Society of Administrative Professionals) Virtual Event in November, I walk you through these two new Excel functions.

Teams Meetings - Captions in your preferred language

Teams Meetings allows live translated captions in the language you are most comfortable with. By default, live captions are displayed in the language that’s spoken during the meeting, but you can change the language of the captions.

OneDrive - Teams and Outlook folders automatically created in OneDrive

Microsoft OneDrive for Work or School, formerly known as OneDrive for Business, creates folders for Teams and Outlook files.