Microsoft Tutorials

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.

Teams: Announcements and Post in multiple channels

Announcements allow you to post either an image or a heading with a background color. With Post in multiple channels, you now have the ability to post a conversation or announcements to multiple channels at one time.

Future Value Function in Excel

The Future Value Function will give you the answer to the future value on investment. Compound interest is interest on interest vs. simple interest that interest only on the principal.

Annual Percentage Yield (APY) vs. Interest Rate

The annual percentage yield takes the interest rate and compounding periods to show what your money could earn in a year. The Future Value (FV) and EFFECT functions are shown.

Excel for Office 365: Fuzzy Matches with the Power Query Editor by Chris Menard

Power Query in Excel will now handle to do approximate matches (fuzzy matches). This is handy since you can't use VLOOKUP or XLOOKUP since you don't have exact matches.

Use the Command Box to master Microsoft Teams

The command box in Microsoft Teams is always at the top of the screen. Use slashes to access shortcuts in Teams.

Create a dynamic two color column chart in Excel to show increases and decreases

A dynamic column chart in Excel will allow you to show increases and decreases in two colors. This is great for showing the monthly trends for one year of sales data.