Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
Microsoft Teams
Microsoft Teams now has virtual backgrounds. There are 24 to pick from while on a video call in Teams. One of the most popular features in Zoom is virtual backgrounds. Now, Microsoft has added that ability to its own Teams collaboration app. Steps to turn on a virtual background in
Microsoft Excel
Microsoft brings 8000 royalty-free images and icons to Office 365. These images work in Word, Excel, PowerPoint, and Outlook. Right now, these are only available to Office 365 Fast Insiders. Steps to use the images and icons 1. Click the Insert Tab 2. Click Picture 3. Select Stock Images.
Zoom
Zoombombing has caused Zoom to make a new update that requires passwords for all meetings. According to Zoom support, passwords are mandatory for all meetings effective on April 4, 2020. Zoom meetings, whether scheduled or instant (join now meeting), will require a password. When you schedule a Zoom meeting, you
Zoom
Zoom virtual backgrounds are extremely popular. Many users have commented on my channel that their virtual background is not working. Many users have asked if virtual backgrounds only work with a paid Zoom account. Virtual backgrounds do work with the free account, and if you are having issues getting virtual
Zoom
Zoom Virtual Video Background is a great feature. One of the issues with the video backgrounds is Zoom only gives you two video backgrounds. You can add video backgrounds, but they have to be the correct size. We have developed over 20 video virtual backgrounds you can use in Zoom.
Zoom
The number of remote workers is rapidly growing. Some companies are 100% remote, and many other companies allow their staff to work several days a week remotely. There are many advantages of working remotely and using video conference or online meetings. Just a few examples of the advantages of video
Microsoft Teams
Microsoft Teams has two great features: 1. Announcements 2. Post in multiple channels Below is an Announcement that was marked as Important, contains an image and a Heading over it, and has the announcement icon on the far right. Announcements allow you to post either an image or a heading
Microsoft Excel
The Future Value function in Excel, or the FV function, will give you the future value on an investment. It is one of the financial function in Excel. Future Value Function - arguments The Future Value function has five arguments. Three of the five are required. Two arguments are optional. **=FV
Microsoft Excel
You should know the difference between the Annual Percentage Yield (APY) and the Interest Rate. APY takes compounding into account while the interest rate does not. APY is a better reflection on what you will earn on a savings or CD account and even some checking accounts. APY is based
Microsoft Excel
Power Query in Excel for Office 365 performs fuzzy matches. Imagine you need to compare two lists of customers. One list is the master list, and the 2nd list is also a customer list, but not an exact match. For example, the master list has "The Home Depot"
Microsoft Teams
The Command Box in MS Teams allows you to perform commonly used tasks in Teams. You can quickly start a chat or jump to a channel in a Team. You can change your status from available to do not disturb (DND), away, or be right back (BRB). Looking for a
Microsoft Excel
Creating a two-color column chart in Excel can be done with an IF statement to make it dynamic. You can manually change the column colors by right-clicking each column you want to change, but that is a lot of work, and if the numbers change, the column could