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
Need to convert text to numbers in Excel? I'll demonstrate four methods in the easy-to-follow article and video. If you need to analyze data in Excel, numbers frequently come in as text and need to be converted. **Excel convert text to numbers** The four methods to convert text
Microsoft Excel
In Excel, numbers that are stored as text can cause unexpected results. It is important before you analyze numbers to make sure there are no numbers or values stored as text. This detailed article with a video shows 5 methods for identifying numbers stored as text. **Identify numbers stored as
Microsoft Excel
One of Excel's most popular financial functions is the PMT function. The PMT function will calculate your payments for a loan based on the interest rate, loan amount, and the number of periods. You would use the PMT function to calculate a car or house loan. **PMT function
Microsoft Outlook
Need a great time-saving Outlook tip? Use Outlook calendar meeting templates. Calendar meeting templates are a great way to schedule meetings that occur frequently but do not have a recurring pattern. With templates, you can put in as much detail as you want and never have to retype it. For
Zoom
The Zoom Waiting Room is very popular. You have always been able to customize the waiting room with your logo and a description. Now, with the release of Zoom 5.7.3, you can add a video to your waiting room. **Zoom waiting room - add video** This is a
Microsoft Excel
**Sometimes working in Excel, moving data around, creating worksheets and removing, copy pasting, all that work can lead to huge file sizes, without realizing. I've had a situation like this recently, with an Excel spreadsheet that didn't have a lot of data, but the file size
Teams
Teams Meetings now has **Live transcription**! Live transcription is a written record of the spoken text that occurs during a meeting. It identifies each speaker, is captured automatically in near real-time, and is available during and after the meeting. Live transcription is different from the meeting feature **Live captions.** Captions
Microsoft Excel
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
Microsoft Excel
The MONTH function in Excel allows you to extract the month from the date. The MONTH function returns a number from 1 to 12. - January would be the number 1 - July would be the number 7 - December would be the number 12. In this article and video
Microsoft Excel
The LARGE function in Excel returns the k-th largest value in a data set. For example, you can use LARGE to return the customer with the highest revenue, 2nd highest revenue, third-highest revenue, and so on. Another example is to use the LARGE function to see the highest test score,
With a market share of over 60%, Google Chrome keeps its top spot in users' preferences. I use it all the time. I also use other browsers but somehow, I always circle back to Chrome. And in case you're wondering I'm on a PC, but
Teams
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. **Teams - Hide Chat** Hide a chat