Microsoft Office Blog by Chris Menard

Mail Merge: How to change default sending account in Outlook

Learn how to change the default email account used for sending mail merges in Outlook.

Outlook - 7 Calendar Tips Every User Should Know

We spend a lot of time in our Outlook calendar. With these calendar tips and tricks, you'll learn how to use your calendar efficiently. I'll demonstrate to you how I use my Outlook desktop calendar to be more productive.

Excel - Find & Highlight Duplicate Rows - 3 Methods | Conditional Formatting

Microsoft Excel can find duplicates easily with Conditional Formatting. The issue is Conditional Formatting finds duplicates based on the cell value, but I want to find duplicate rows. I use three methods in the video to find duplicate rows. I start off with CONCATENATE, then use the TEXTJOIN function, and finally COUNTIFS with no helper column. To highlight the rows I use Conditional Formatting using a formula.

Teams - Why can't I record? Video call vs. meeting

Microsoft Teams allows you to easily record meetings. I'm frequently asked, "Why can't I record?" or "Why is recording disabled?" The answer is that you are doing a video call. Most likely, you were chatting with one person (1-on-1 chat) or doing a group chat. A video call looks similar to a meeting, but it is a call, so the recording feature is disabled.

Three Great OneDrive Tips and Features You Might Not be Using

OneDrive has great features but here are three you might love - time savers, life savers, convenient and more!

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.