Microsoft Office Blog by Chris Menard

Microsoft Teams Improved Screen Sharing Interface | May 2021 Update

Microsoft Teams improves the sharing window, making it easier to select which resource you are sharing - screen, window, application, whiteboard, in the May 2021 update.

How to Import Excel Events CSV into Google Calendar: Tips, Supported Fields, How-to

Save time adding your Google Calendar events by importing them in bulk using a CSV you can easily create in Excel.

Zoom Immersive View: New Feature in Zoom 5.6.3 - May 2021

Zoom includes Immersive View, starting from version 5.6.3, which puts all your participants inside the same scene with a beautiful and casual decor or background.

MS Forms - 3 new features: Format surveys, send to specific users, and receipt

Microsoft Forms has three new features that were recently rolled out. I'll cover all three in under three minutes. You can now format your surveys or quizzes using bold, italics, or underline. You can also send a survey out to specific users or groups in your organization, and you can have users get a receipt of their responses.

The Rule of 72 explained using Excel and the NPER Function

Need to know when your investment will double? In finance, the rule of 72 is an easy method for deterring when an investment will double. Take the number 72 and divide it by the interest rate, which gives you the number of years.

Word - How to correctly select a paragraph, sentence, word, or the entire document with the mouse

Selecting a word, sentence, paragraph, or the entire document in MS Word is easy. Here is a short video on how to correctly select with the mouse.

How to use the SUM Function and AUTOSUM in Microsoft Excel | Tutorial for Absolute Beginners

The SUM function is the most popular and widely-used function in Microsoft Excel, along with its automated version: AutoSum. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.

Zoom Vanishing Pen Annotation | Draw on Screen during meetings or webinars while sharing. Zoom 5.6.3

You can annotate your screen sharing, window sharing or webinars in Zoom by using a 'vanishing pen annotation'. Zoom had annotation features before, but in this update for Zoom version 5.6.3 you can draw anywhere on screen and in a few seconds that annotation disappears automatically.

Outlook - End meetings early or start late - NEW feature 2021

If you're using Outlook for Microsoft 365, you can now have Outlook end your meetings a few minutes early or start late. I prefer to end early, but it's up to you. This can help you build in travel time between meetings.

Excel compare two or more text strings

To compare two text strings in Excel, you can use the EXACT Function or you can use =A1=B1. The EXACT function checks for case sensitivity. Example "Chris" is not the same as "CHRIS" if you use the EXACT function. With =A1=B1, Chris would appear as the same.

Presenter Coach in PowerPoint - Rehearse your slide show

Microsoft PowerPoint includes a great feature or presentation coach that allows you to rehearse your presentation using the automated 'Rehearse with Coach' functionality.

Excel: Combining Unique and Sort functions

The UNIQUE function in Excel is one of my favorite functions. Unique returns a list of unique values in a range. The SORT function in Excel sorts the contents of a range or array.