Microsoft Office Blog by Chris Menard

Excel SORTBY Function | Excel One Minute Quick Reference

The SORTBY function in Excel sorts the contents of a range or array based on the values in a corresponding range or array. Use SORTBY to see a list of employees sorted by highest paid, but you don't show their salaries. USE SORTBY to sort a customer list by the most profitable customer but not see the revenue.

Excel FILTER Function | Excel One Minute Quick Reference

The FILTER function in Excel allows you to filter a range of data based on the criteria you define. The FILTER function is a dynamic array function. The FILTER function has three arguments, but only two are required.

Excel SORT Function | Excel One Minute Quick Reference

The SORT function in Excel sorts the contents of a range or array. Example, =SORT(B2:B20). You can also sort in ascending or descending order with the SORT function.

Excel DATEDIF Function | Excel One Minute Quick Reference

Need to know the number of years, months, or days between two dates? Excel's DATEDIF function will calculate it for you. This is a great function if you work in Human Resources (HR), or any job position where you need the difference in dates.

How to use XLOOKUP function in Excel

Quick introduction to the XLOOKUP function in Excel, with easy examples. XLOOKUP looks both left and right. XLOOKUP also allows column to be inserted to deleted. VLOOKUP will not look left and right and you can't insert and delete columns.

Outlook Speed Up Emailing by Using Voice Commands and Dictation

The Dictate feature in Microsoft is great. Outlook has a new feature with Dictate. You can now dictate the subject, add people to the To, CC, and BCC line, and at mention people. Several commands you can use are "add [Name] to email", "add [Name] to bcc", and "send email".

Import CSV into Google Calendar: 7 Troubleshooting Tips

If you have trouble importing events from CSV into Google Calendar, some of these tips might help troubleshoot what's wrong with your file.

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!