Outlook on the Web - 7 cool features
Posted by Chris Menard on 03/02/2021
Outlook on the Web keeps rolling out new features. In this video, I cover seven features in Outlook that I love. Start a Teams chat in Outlook, work with sending and receiving attachments using OneDrive for Work, use undo send, suggested replies, and sent later.
Excel Charts - three methods for filtering Chart Data
Posted by Chris Menard on 02/26/2021
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.
Word: Insert Electronic Signature multiple ways including AutoCorrect
Posted by Chris Menard on 02/22/2021
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
Posted by Chris Menard on 02/21/2021
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.
Excel: Covert decimal hours Excel's hours & minutes (8.25 to 8:15)
Posted by Chris Menard on 02/17/2021
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
Posted by Chris Menard on 02/16/2021
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.
Outlook - make Teams Meeting the default and Meet Now Feature
Posted by Chris Menard on 02/13/2021
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!
Posted by Chris Menard on 02/10/2021
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.
Working with Time in Microsoft Excel | Time Functions and Conversion
Posted by Chris Menard on 02/05/2021
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.
Outlook Sweep Feature - Awesome built-in tool to keep your inbox clean
Posted on 02/01/2021
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.
Upload Files in Microsoft Forms - New Feature!
Posted by Chris Menard on 01/28/2021
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's name that uploaded the files. You can specify the number of files someone can upload and the maximum file size.