Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
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
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
Microsoft Teams
Microsoft Teams - ALWAYS name your meetings. I'll review the two meeting types in Teams, how to record your meetings, and why you should always name your Meet Now meetings. Your Meet Now meetings do not show on the calendar. **Teams Meet Now - always name your meeting*
Microsoft Excel
Accountants use Excel all the time. In this video, which is great for Accounting students, we look at the Accounts Receivable (AR) or Accounts Payable (AP) exercise. **Excel accounting exercise** Accounts Payable is what you, or your company, owe to vendors and suppliers. Accounts Receivable is what is owed to
Microsoft Excel
Recommended PivotTables in Excel is getting a great update. To use Recommended PivotTables, click the Insert Tab, and click Recommended PivotTables. The new update includes an easy method to change the data range. You also get a task pane on the right side of the screen and can add the
Microsoft Excel
If you want to calculate how many days are in each month for a year, it is easy to do with a PivotTable in Excel. I want to know how Sundays through Saturdays there are for each month of the year. **Excel PivotTable - Show days per month for the
Microsoft Excel
I recently spoke at the Administrative Professional Day Conference hosted by the University of Georgia. After reviewing my survey results in Microsoft Forms, I realized I needed to analyze the survey data. Forms results are immediately available in Excel. **Microsoft Forms - Analyze data in Excel** After opening in Excel,
Microsoft Teams
Updated: December 10, 2022 You can now delete an entire chat for one-on-one chats and group chats. In Teams, it is easy to add files in a chat. In a chat, you click the paperclip for attaching files, select your files, and click Send. The files show up in the