Microsoft Office Blog by Chris Menard

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.

Five Free Zoom Business Backgrounds

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

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.

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.

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.

Microsoft Teams - Create customized backgrounds for Meetings

Workaround for adding your own images to a Teams meeting as a background. Simply add images or pictures to the Teams Upload folder in Explorer.

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.

Google Meet premium HD video conference will be available for free to everyone starting in May 2020

Google Meet premium HD video conference will be available for free to everyone starting in May 2020

How to use the Waiting Room in 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.

Multiple signatures in Gmail

Gmail now supports multiple signatures in the free Gmail and Gmail that comes with GSuite.

Invite guests to a Teams Meeting

Inviting guests to a Microsoft Teams meeting is very easy using the Teams app. Click the Calendar, and click a date for the appointment.

Virtual Backgrounds in Microsoft Teams

Microsoft Teams now has 24 virtual backgrounds to chose from in meetings.