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.
Word and Outlook - Dictate with Auto Punctuation and Voice Commands
Posted on 01/27/2021
The Dictate feature in Word and Outlook has been greatly improved. Dictate will now allow Auto Punctuation, Voice Commands, and a Profanity Filter. The Dictate command works in the Desktop apps - Word, Outlook, and PowerPoint. Interestingly, the new improvements only work in Word and Outlook.
PowerPoint Presenter View in Microsoft Teams
Posted on 01/22/2021
Share PowerPoint slides in a meeting in Presenter View! If you're a presenter and choose to share a PowerPoint file in a meeting, you will have some behind-the-scenes capabilities with the new presenter view. As the presenter, you will see the current slide, your slide notes or speaker notes, and thumbnails of all the slides in your deck.
Today Function in Excel
Posted by Chris Menard on 01/20/2021
The TODAY function is a date/time function that shows the current date based on your computer time. The TODAY function will update automatically.