Microsoft Excel
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. FILTER function in Excel YouTube Video Excel FILTER Function | Excel One Minute
Microsoft Excel
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. I also use the
Microsoft Excel
One of my YouTube scribers asked me, "How to Exclude Dates With No Data From Charts in Excel?" When you chart data, months with no data appear. For example, if you chart January through December and March and August do not have any data, they will show on
Microsoft Excel
The XLOOKUP function is one of my absolute favorites in Excel. It allows you to quickly look up various values in one range and return a corresponding value from another range. Unlike VLOOKUP, XLOOKUP looks both ways, and is more versatile and flexible, particularly when you move ranges around or
Microsoft Outlook
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&
**I've covered how to [import a CSV file into your Google Calendar](https://chrismenardtraining.com/post/how-to-import-excel-events-csv-into-google-calendar-tips-supported-fields-how-to) in detail before, but as students have gone back to university, I'm getting a lot of
Microsoft Outlook
Mail Merge with Outlook is a great time-saving tool and one of the most popular videos on my YouTube channel cover this exact topic. Word and Excel in this video. However, a question I get a lot is what do you do if you've got multiple Outlook
Microsoft Outlook
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. Multiple Time Zones in Outlook YouTube Video
Microsoft Excel
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. Excel conditional formatting - duplicates are based on cell value, not row
Microsoft Teams
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)
Microsoft OneDrive
I love Microsoft's OneDrive and I use it all the time - in my work and also with my family. If you're using Microsoft Word, Excel, PowerPoint and any other software that needs storing files you might want backed up, synchronised across devices (and operating systems), OneDrive
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