Microsoft Office Blog by Chris Menard

Zoom - Add Video to the Waiting Room

The Zoom Waiting Room is very popular. You have always been able to customize the waiting room with your logo and a description. Now, with the release of Zoom 5.7.3, you can add a video to your waiting room.

Excel file size out of control? Learn how to reduce Excel spreadsheet file size

Sometimes Excel spreadsheet file size can get out of control, for no reason, despite not having a lot of data. Find out what to do to reduce the size again.

Teams: Live transcription in Teams meeting - 2021 New Feature!

Teams Meetings now has live transcription! Live transcription is a written record of the spoken text that occurs during a meeting. It identifies each speaker, is captured automatically in near real-time, and is available during and after the meeting. Live transcription is different from the meeting feature Live captions. Captions are not recorded. You could use Live transcription if you joined a meeting late and you need to quickly catch up on what is happening.

Margin of Safety vs. Break-even point in Excel

Break-even point (BEP) is the level of sales where the total cost - fixed cost and variable cost - equals total revenues. Break-even is where Net Income is zero. There is no profit and no loss. The Margin of Safety (MoS) is a difference between actual/budgeted sales and the level of breakeven sales.

Excel MONTH Function - extract the month from a date | Excel One-Minute Quick Reference

The MONTH function in Excel allows you to extract the month from the date. In this video, I show you how the month function works in Excel, the formula to use, reference the fields, formatting it so that you only see the month and nothing else.

Excel LARGE function | Find the second, third, n-th largest value | Excel One-Minute Quick Reference

The LARGE function in Excel returns the k-th largest value in a data set. For example, you can use LARGE to return the customer with the highest revenue, 2nd highest revenue, third-highest revenue, and so on.

Top 18 Keyboard Shortcuts for Google Chrome You Need to Use

Are you using these top keyboard shortcuts for Google Chrome? Save time and be more efficient by learning and getting used to these.

Teams chats: hide chats, delete messages and organize your chats

Microsoft Teams chats are used daily. To help you manage your chats, I created this short video on hiding and unhiding chats, deleting messages, and pin and unpin chats. This will help you stay organized if you have a lot of chat history.

Microsoft Teams Improved Screen Sharing Interface | May 2021 Update

Microsoft Teams improves the sharing window, making it easier to select which resource you are sharing - screen, window, application, whiteboard, in the May 2021 update.

How to Import Excel Events CSV into Google Calendar: Tips, Supported Fields, How-to

Save time adding your Google Calendar events by importing them in bulk using a CSV you can easily create in Excel.

Zoom Immersive View: New Feature in Zoom 5.6.3 - May 2021

Zoom includes Immersive View, starting from version 5.6.3, which puts all your participants inside the same scene with a beautiful and casual decor or background.

MS Forms - 3 new features: Format surveys, send to specific users, and receipt

Microsoft Forms has three new features that were recently rolled out. I'll cover all three in under three minutes. You can now format your surveys or quizzes using bold, italics, or underline. You can also send a survey out to specific users or groups in your organization, and you can have users get a receipt of their responses.