Microsoft Office Blog by Chris Menard

Chris Menard's Training Roundup | Issue #1

The first (welcome) issue of Chris Menard's Training Roundup - Free Email Newsletter.

Excel Automatic Data Type: Dog Breeds and Diseases

Excel's Automatic Data Types recognizes similar data. In this video, I type in different dog breeds in columns A and Excel finds the breeds and returns data information.

Zip Code data type in Excel

To use the Zip Code data type, select your zip codes, and Excel will return important information. Data includes the median household income, latitude, longitude, population by marital status

DeKalb Chapter of CPAs - Technology tips in the shift to the virtual world

Chris Menard will present a Zoom training session to the DeKalb Chapter of CPAs on June 30, 2020, at 5:30 pm. Covered in the 1-hour session will be advanced Zoom hosting tips.

Teams download custom background images for Family Guy, the Simpsons and other shows

Fox has created backgrounds you can use as custom images in Teams meetings. The background images include The Simpsons, Family Guy, The Masked Singer, LEGO Masters, Bob's Burgers, and others.

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. Yes, that is a new term from Zoom: Passwords are now called Passcodes.

Teams add your own virtual background directly in Teams

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.

Announcing a new collaboration series on creating a YouTube channel in 2020

A new collaboration project, A BEGINNER COURSE series on how to start a YouTube channel in 2020.

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 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

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

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.