Microsoft Office Blog by Chris Menard

Word track changes - Just Mine - Track only your changes - New feature - August 2021

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.

How to use the TODAY function in Excel

The TODAY function returns the current date and is updated automatically when you open an Excel file. The TODAY function has no arguments. In this video, I'll use the TODAY function in an accounting exercise using Accounts Receivable. You would use the same for Accounts Payable.

Excel Convert Text to Numbers - Four easy methods

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 - 5 easy ways to identify numbers stored as text

In Excel, numbers that are stored as text can cause unexpected results. It is important before you analyze numbers to make sure there are not stored as text. In this video, I'll demonstrate five methods to quickly find numbers stored as text. Numbers as text usually happens when you pull data from another data source into Excel.

PMT Function in Excel - how to use it to calculate loan payment

The PMT function will calculate your payments for a loan based on the interest rate, loan amount, and the number of periods.

Outlook Calendar Meeting Template

Need a great time saving Outlook tip? Use Outlook calendar meeting templates. Calendar meeting templates are a great way to schedule meeting that happen frequently, but do not have a recurring pattern.

Zoom - Add Video to the Waiting Room

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.

Excel file size out of control? Learn how to reduce Excel spreadsheet file size

Sometimes Excel spreadsheet file size can get out of control, for no reason, despite not having a lot of data. Find out what to do to reduce the size again.

Teams: Live transcription in Teams meeting - 2021 New Feature!

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 are not recorded. You could use Live transcription if you joined a meeting late and you need to quickly catch up on what is happening.

Margin of Safety vs. Break-even point in 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 breakeven sales.

Excel MONTH Function - extract the month from a date | Excel One-Minute Quick Reference

The MONTH function in Excel allows you to extract the month from the date. In this video, I show you how the month function works in Excel, the formula to use, reference the fields, formatting it so that you only see the month and nothing else.

Excel LARGE function | Find the second, third, n-th largest value | Excel One-Minute Quick Reference

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.