MS Forms - 3 new features: Format surveys, send to specific users, and receipt
Posted by Chris Menard on 05/06/2021
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
Posted by Chris Menard on 04/29/2021
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.
Outlook - End meetings early or start late - NEW feature 2021
Posted by Chris Menard on 04/21/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
Posted by Chris Menard on 04/20/2021
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.
Excel: Combining Unique and Sort functions
Posted by Chris Menard on 04/14/2021
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.
Share Outlook email to Teams - New Feature April 2021
Posted by Chris Menard on 04/13/2021
From Outlook or Outlook on the web, you can send emails to Team chats and Team channels. Does the email contain attachments? You have the option to share the attachments. This is a great update.