Microsoft Excel
1. Microsoft just added the Zip Code Data Type in Excel. Unlike the Geography Data Type, which only shows data for countries, states and cities, the Zip Code Data Type returns things like household income, latitude, longitude, population by marital status, water and land areas and much more. Watch the
Microsoft Excel
Excel's Automatic Data Types is an awesome feature. There are over 50 different data Automatic data types, not including the specific types listed when you go to Data - Data Types group. Excel's Automatic data types can recognize similar data. In this video, I type in different
Microsoft Excel
Excel now has a **Zip Code data type**. The Zip Code data type is new and is currently available to only Beta Channel Excel users. It should be released soon to all Microsoft 365 subscribers and Excel for the web. To use the Zip Code data type 1. Select your
Microsoft Teams
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. Fox's webpage to get images to download to Teams https://www.fox.com/article/fox-microsoft-
Zoom
Zoom Passcodes are going to be required, OR a waiting room must be enabled for all zoom meetings from July 19, 2020.
Microsoft 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
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 process,
Zoom
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
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
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