Zoom
Zoom Passcodes will be required for all meetings or a Waiting Room enabled starting July 19th
Zoom Passcodes are going to be required, OR a waiting room must be enabled for all zoom meetings from July 19, 2020.
Latest
Microsoft Teams
Teams Add Your Own Virtual Background Directly in Teams
Teams is known for the popular blurry background effect and soon added pre-installed backgrounds. Now Teams allow custom backgrounds to be added.
Youtube
Announcing a new collaboration series on creating a YouTube channel in 2020
June 20, 2020 - Today we are announcing a new collaboration project, **A BEGINNER COURSE** series on how to start a YouTube channel in 2020. Let us know in the comments if you are interested or if you have questions about this. The series will walk you through the entire
Zoom
Ultimate Guide in Zoom: Mute and Unmute participants
Zoom allows the host to Mute and UnMute participants. One new feature rolled out in release 5.1.0 is the host's ability to select " **Ask All to Unmute**." This feature is due to Zoom removing Unmute All in a previous update. Unmute All would unmute
Windows
How to use the Windows clipboard
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. You can even copy items from one PC to another with a cloud-based clipboard. To access your clipboard history at any time,
Microsoft Excel
Average Function in Excel
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.
Zoom
Five Free Zoom Business Backgrounds
Posted on: 06/05/2020 We love Zoom's virtual backgrounds, but it is hard to find office or business backgrounds. Here are 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.
Microsoft Teams
Pop-out Chat in Microsoft Teams
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
Finance
Is it a good time to buy a home in the Metro Atlanta real estate market?
**I caught up with Teri Khimani, my realtor, to discuss the real estate market in general, and also deep dive in the Metro Atlanta market, particularly through the lens of the current Covid-19 situation. I wanted to find out if and how the real estate market has been affected during
Translate languages in Google Sheets with GOOGLETRANSLATE function
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. Arguments in GoogleTranslate Google Translate has three arguments
Microsoft Teams
Microsoft Teams: Create customized backgrounds for Meetings
Teams allow you to use a default set of images selected by Microsoft as the background for meetings. Unlike Zoom, you can't upload your own images inside the Teams app. Microsoft is working on the ability to upload your own images, but here is a workaround that allows
Microsoft Excel
Workbook Statistics in Excel for Microsoft 365
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. You access Workbook Statistics by going to the **Review** tab - Proofing group - **Workbook Statistics** in Excel