Microsoft 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
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
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
**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
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
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
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
Google Meet
Google Meet premium HD video conference will be available for free to everyone starting in May 2020. Google Meet is secure and easy to use. The video quality is exceptional.
Zoom
The Waiting Room feature in Zoom is a great security feature. The Waiting Room allows you, the host, to control when a participant joins your meeting. You can either admit participants one at a time or admit them all at once. The Waiting Room can be turned on for individual
A new feature in Gmail allows for multiple signatures. You can create different signatures for different emails. Examples of when to use multiple signatures: 1. You have one signature for new mail or compose 2. Signature for replies and forwards 3. Signature that contrains your direct dial or mobile number
Microsoft Teams
Inviting guests to a Microsoft Teams meeting is very easy. You can do it inside Teams. You can also do it in Outlook with the Teams Add-in. We are going to focus on inviting people outside your organiaztion inside the Teams app. Steps to invite guests 1. Click the **Calendar*
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