Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
OneNote
Need to stay organized with Outlook? Use Microsoft OneNote and Outlook together. Three tips on working with OneNote and Outlook. **Tip # 1** - Insert your meeting invitation into OneNote. You can see a list of attendees and check that they attended, and take meeting notes. Insert Outlook Meeting Details into
Microsoft Teams
Microsoft Teams has a great new feature for Chat. You can now reply to specific chat messages. This is handy when you are doing a 1-on-1 chat or a group chat, and you have several messages you need to send replies to. Reply to a specific chat in MS Teams
Microsoft Excel
We love to use Filters in Excel. When filtering data, the filtered rows turn blue. To get the SUM, AVERAGE, MAX, MIN, or COUNT of the filtered data, use the SUBTOTAL function. Subtotal Function in Excel If you use one of the functions with one argument - SUM, AVERAGE, MAX,
Microsoft Excel
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. =SORT(B2:B20,,-1) would sort descending or highest to lowest. The number 1 would sort ascending, which is the
Microsoft Excel
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
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 questions and emails saying that their import to Google Calendar isn't
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 accounts