Margin of Safety vs. Break-even point in Excel
Posted by Chris Menard on 06/25/2021
Break-even point (BEP) is the level of sales where the total cost - fixed cost and variable cost - equals total revenues. Break-even is where Net Income is zero. There is no profit and no loss.
The Margin of Safety (MoS) is a difference between actual/budgeted sales and the level of breakeven sales.
Teams chats: hide chats, delete messages and organize your chats
Posted by Chris Menard on 06/10/2021
Microsoft Teams chats are used daily. To help you manage your chats, I created this short video on hiding and unhiding chats, deleting messages, and pin and unpin chats. This will help you stay organized if you have a lot of chat history.
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.