Microsoft Tutorials

Create a Poll in an Outlook email

Outlook now allows you to quickly create a poll in an email. This works with in conjunction with Microsoft Forms, but you do NOT have to go to Forms to use this feature. You create your poll directly in the email.

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

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.

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.

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.

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.

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.

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.

8000 royalty-free images are available in Office 365 - April 2020 update

Microsoft brings 8000 royalty-free images and icons to Office 365. These images work in Word, Excel, PowerPoint, and Outlook. Right now, these are only available to Office 365 Fast Insiders.