Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
Microsoft Word
Microsoft Word has a new feature for track changes. You can track just your changes. The feature is called **Just Mine** and is on the Review tab under Track Changes. With this new functionality, you can only track your changes ("Just Mine"). This keeps you from forcing others
Microsoft Excel
The **TODAY** function returns the current date and is updated automatically when you open an Excel file. The TODAY function has no arguments. I'll use the TODAY function in an accounting exercise using Accounts Receivable in this blog post and video. You would use the same for Accounts
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
Microsoft 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,