Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
Microsoft Excel
I'm frequently asked how to convert decimal hours to Excel's hour and minute format. A couple of 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
Microsoft Forms
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. The key to making the
Zoom
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
Microsoft Excel
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. YouTube Video on
Microsoft Word
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 add some bullet points. Maybe you don't like the wording of a paragraph and want to follow-up on
Microsoft Outlook
Scheduling a Teams meeting is easy to do. I get asked a lot if I should schedule from Teams or Outlook? I'll cover the pros and cons of scheduling in Teams vs. Outlook, and I'll discuss a few new features in Teams and even show how
Zoom
Zoom allows you to Mute All participants as a host and previously allowed you to Unmute all. Unmute all was removed in May 2020. It was determined it was a privacy issue to unmute all.
Microsoft Excel
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,
Zoom
Zoom has made it easy to share and play video files in a meeting. Part of the 5.5.0 update on 2/1/2021 allows you to select a video file and Zoom immediately opens the file, shares audio, and plays the video as shared content. The host has
Zoom
Zoom's latest update, 5.5.0, came out on February 1, 2021. One of the many new features is the ability to blur your background. You can still select a specific virtual background, but the blurred background is a great feature if you need added privacy. YouTube video
Microsoft Outlook
The Sweep feature in Outlook gives you options to automatically delete all incoming emails from a particular sender, to keep only the latest email, or to delete emails older than 10 days (which I use all the time). Sweep is a great way of keeping your inbox clean. YouTube video
Microsoft Forms
Microsoft Forms allows you to create a survey with multiple question types. One of the new question types is the **File upload**. So users can now upload files in a survey! This is an awesome feature. The files are stored in a SharePoint folder and automatically marked with the person&