Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
Microsoft Excel
If you need to compare two lists or columns in Microsoft Excel, you can either use Conditional Formatting or you can you an empty column and use Countif function. You can even use both. This is handy when you want to compare 2016 customers to 2017 customers or a list
Microsoft Excel
Have you ever had a printed page of data, and needed to put the data in Excel? Typing the data is a real pain. Excel now allows you to put the data in Excel using **Data from Picture**. Data from Picture Data from Picture is a great feature and is
Zoom
Updated: _July 9, 2022_ \- Managing a zoom meeting can be challenging with a lot of people. With Zoom's **co-host feature**, you can share hosting privileges with other users. A co-host can help manage the waiting room, breakout rooms, chats, and other features. You can have more
Microsoft Teams
Recorded Meetings in Teams are stored in OneDrive for Work or School. The one exception is Channel Meetings are stored in SharePoint. Teams Meeting Recordings set to expire The recordings expire! Which could be really bad if you are relying on the recording. In this video, I'll cover
Microsoft Excel
Highlighting or shading every other row in Excel is a great way to make your data easier to read. I'll show three methods for applying color to alternate rows. **Share every other row in Excel** Method 1 is my least favorite, but I see users doing this a
Microsoft Excel
Excel's Unpivot Columns, part of Power Query, is an awesome feature. It is the easier way to fix data that isn't in a tabular format. **Power Query - Unpivot columns** You want data in a tabular format so it can be sorted, filtered, and PivotTables created. In
Microsoft Outlook
In Outlook we live in our calendar. We have three different types of calendar items - Meetings, Appointments, and Events. When do you use each? Outlook Calendar Meetings vs. Appointments We will look at scheduling meetings, appointments, and all-day events. The main distinction is Appointments are for you and have
Microsoft Outlook
Outlook **Contact Groups**, formerly called **Distribution List**, are great for saving time. Instead of typing in 20 emails, just type in the name of the Contact Group. **Outlook Contact Group added to Schedule Meeting Assistant** In this blog post with video, I'll show an awesome trick for using
Microsoft Word
Styles in Word are one of the best features in Microsoft Word. In this video, I give five tips for working with Styles. I use Draft view with advanced options. Outline view in Word is shown along with Printing Styles and quickly updating Heading Styles. **Draft View in Microsoft Word*
Microsoft PowerPoint
PowerPoint for Microsoft 365 allows you to edit your Speaker Notes while in PowerPoint Slide Show. Start your presentation and in Presenter View, you can edit your speaker notes. **Edit Speaker Notes while in PowerPoint slide show** Keyboard shortcuts even work for Bold, Italics, and Underline. You can select text
Microsoft Teams
Time Zones are now displayed in Teams. You can see if a coworker is hours ahead of you or behind you by moving your mouse over their Profile card. Hours ahead and behind show in Teams Profile Cards Tip 2 - You can send a quick message. You do not have
Microsoft Excel
The TODAY function is one of my favorite Date & Time functions in Excel. It returns the current date and will automatically update. We will use the TODAY function with Conditional Formatting and create three rules on a date field. Excel Conditional Formatting with the Today Function The date field