Teams add your own virtual background directly in Teams
Posted by Chris Menard on 06/25/2020
Microsoft has released a Teams meetings update that allows meeting participants to upload their own personal backgrounds. Teams is known for the popular blurry background effect and soon added pre-installed backgrounds. Now Teams allow custom backgrounds to be added easily.
Ultimate Guide in Zoom: Mute and Unmute participants
Posted by Chris Menard on 06/19/2020
Zoom allows the host to Mute and UnMute participants. One new feature rolled out in release 5.1.0 is the ability for the host to select "Ask All to Unmute". This feature is due to Zoom removing Unmute all in a previous update.
How to use the Windows clipboard
Posted on 06/09/2020
With the Windows 10 clipboard, you can copy multiple images and text at one time. The clipboard previously held one item, but now the clipboard holds 25 items.
Average Function in Excel
Posted on 06/07/2020
The AVERAGE function is one of the most popular functions in Excel. This video shows how to use the Average function, handles zero values when using the Average function. Zero values vs. blank cells will give different results with Average. As a bonus, using the AverageIF function with zero values.
Five Free Zoom Business Backgrounds
Posted on 06/05/2020
Five free virtual backgrounds with an office setting. The images are set at the optimum dimensions of 1920x1080. We will soon make them video virtual backgrounds.
Pop-out Chat in Microsoft Teams
Posted by Chris Menard on 06/02/2020
Teams now allow you to instantly pop-out your one-on-one or group chat into a separate window. After popping out the chat, you can drag it, place it on another monitor, resize, or close the window as you wish. Pop-out chats are a great way to get a lot done when you’re in a meeting or in a call. I demonstrate in this short video how to have a meeting in Teams and then pop-out two chats.
Translate languages in Google Sheets with GOOGLETRANSLATE function
Posted by Chris Menard on 05/14/2020
Google Sheets has a translate function called GoogleTranslate. The function translates text from one language into another. It is free to use, and you can set up mixed references so you can translate the original text into many languages at one time.
Workbook Statistics in Excel for Microsoft 365
Posted by Chris Menard on 05/09/2020
Excel for Microsoft 365 subscribers now have Workbook Statistics. Workbook Statistics is a window that shows a summary of the workbook statistics including the number of sheets, tables, formulas, charts, and pivottables.