Microsoft Office Blog by Chris Menard

Excel Charts - three methods for filtering Chart Data

Filtering data in Excel charts is easy to do. The method you use should be based on the amount of data you have. In this video, I show three methods of filtering chart data. Method 1 is using Chart Filters. This is the easiest method.

Zoom Security - Using and Changing your Personal Meeting ID (PMI)

Your Personal Meeting Room is a virtual meeting room permanently reserved for you to access with your Personal Meeting ID (PMI). With your PMI, you can start instant meetings, or you can schedule a meeting that uses your PMI.

Word: Insert Electronic Signature multiple ways including AutoCorrect

Need to add your electronic signature to a Word document? It is effortless to do. In this video, I'll show three ways to add your electronic signature to a Word Doc, how to correctly resize your signature, and wrap the text shows it shows correctly in the document.

Microsoft Forms - 5 things you may not know you can do in Forms

With Microsoft Forms, you can easily create surveys and polls to collect customer feedback, measure employee satisfaction, and organize team events. You can print a blank form, shuffle questions, allow receipt of responses, add a logo to your form, and use Forms in Teams.

Zoom: Block or Allow participants from countries when scheduling your meeting

Zoom has a nifty feature where you can block or allow participants from countries/regions when scheduling your meeting. For example, I'm in the U.S. and schedule a zoom meeting. I can block participants from Ireland, Italy, Spain, and the UK.

Excel: Covert decimal hours Excel's hours & minutes (8.25 to 8:15)

I'm frequently asked how do I change decimal hours to Excel's hour and minute format. A couple examples: 7.75 need to show as 7:45, and 30.25 needs to show as 30:15. The solution is to divide by 24 hours. The formula is hours/24.

Microsoft Forms - Show Progress Bar on Surveys, Polls, and Quizzes

Microsoft Forms is an excellent tool for creating surveys, quizzes, and polls. Did you know you can add a progress bar to a Forms survey or quiz? A progress bar makes it easy for users to see how many pages they have left to complete.

Zoom Polling - View all poll results at one time during a meeting

Zoom's polling is a great feature. One tip that most users don't know is that you can view all polls' results during a meeting. By default, as the host, you can easily share one poll's results during the meeting, but you can launch a web browser and see the results of every poll. This may be handy when you need to discuss the poll results or schedule breakout rooms based on poll results.

Outlook - make Teams Meeting the default and Meet Now Feature

The Outlook desktop client now allows all meetings to be Teams meetings by default. No longer do you have to remember to click the Teams Meeting add-in icon in the ribbon. Another new feature in Outlook is you can now have a Meet Now meeting in Teams.

Microsoft Word's incredible Follow-up feature!

Have you ever been in a Word document and need to mark some sections for Follow-up? For example, a bulleted or numbered list where you need to come back and some bullet points. Maybe you don't like the wording of a paragraph and want to follow-up on it later.

Teams vs. Outlook - Schedule a Teams meeting

Scheduling a Teams meeting can be done in Outlook or Teams. We examine the pros and cons of using each app to schedule meetings.

Working with Time in Microsoft Excel | Time Functions and Conversion

Do you need to add or subtract time in Excel? Some time calculations are easy, but depending on how the time is entered, you may need to use the TIME function or formula to add or subtract time. For example, if you have 9am in B2, and in cell C2, you have 3, for three hours, you can't add them with B2+C2 and get the correct answer without the TIME function.