Microsoft Office Blog by Chris Menard

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.

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Dictate in Word, Outlook, OneNote, and PowerPoint allows users to use speech-to-text to author content in files.

Teams - Record a Video Clip in Chat

Teams allows you to "Record a video clip" in Chat. This is possible for one-on-one chats and group chats.

Excel Image Function

The new Excel IMAGE function enables you to insert images into cells with a formula. This great function allows you to sort, filter, and rearrange images.

Using Meeting CO-ORGANIZERS in Microsoft Teams Meetings

Using Meeting CO-ORGANIZERS in Microsoft Teams Meetings

Excel Highlight Every Nth Row with Conditional Formatting - Every 3rd, 4th, or 5th row.

Conditional Formatting in Excel allows you to highlight every 2nd, 3rd, 4th, or 5th row. Writing a formula using the MOD function and ROW function together allows us to do this.