Teams add your own virtual background directly in Teams
Posted by Chris Menard on 06/25/2020
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
Posted on 06/07/2020
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
Posted by Chris Menard on 06/02/2020
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.
Workbook Statistics in Excel for Microsoft 365
Posted by Chris Menard on 05/09/2020
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
Posted by Chris Menard on 04/22/2020
Inviting guests to a Microsoft Teams meeting is very easy using the Teams app. Click the Calendar, and click a date for the appointment.
Teams: Announcements and Post in multiple channels
Posted by Chris Menard on 02/24/2020
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
Posted by Chris Menard on 02/10/2020
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
Posted by Chris Menard on 01/17/2020
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.