Microsoft Office Blog by Chris Menard

Zoom Advanced Polls - 6 new question types! New Feature | Nov 2021

Zoom has a significant update for Meeting Polls. With Zoom 5.8.3, you can do Advanced Polling. There are six new question types in addition to single and multiple answers. You can now use short answer, long answer, matching, rank answers, rating, and fill in the blank.

5 Outlook Inbox tips to be more productive

A lot of our time is spent in Outlook. Here are five inbox tips to be more productive. Tip 1 - Turn on Focus Mode. Tip 2 - Create a meeting from an email message.

Microsoft Teams - Swap Meeting to Mobile Device | Transfer to this device feature

In a Teams Meeting on your laptop or desktop and need to go meet a client? Need to go grab water? Teams now allows you to Transfer your meeting to your mobile device. This works with both Android and iPhones.

Subtotal Command in Excel - automatically calculate subtotals and grand totals

The Subtotals Command will automatically calculate subtotals and grand totals in a list for a column. Subtotals come with an automatic outline in Excel. The outline will show 1, 2, and 3 to the left of column A. I have three rules I follow before I use Subtotals - 1) Save 2) Sort and 3) Subtotal. You can also do multiple Subtotals.

Excel - How to use the Navigation pane for charts, tables, PivotTables, pictures, and worksheets

The Navigation pane in Excel is an easy way to understand a workbook's layout. With the Navigation pane, you can see charts, tables, images, and PivotTables. The Navigation Pane even shows you the elements by worksheet.

Excel NOW Function | Excel One Minute Quick Reference

The NOW function in Excel returns the current date and time. The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.

Zoom profile picture now shows in meeting chats

Zoom now features "Profile photos for in-meeting chat." When chatting in a Zoom meeting, participants' profile pictures now appear. If the participant doesn't have a profile picture, their initials appear. This is part of Zoom's update in October 2021. The version is 5.8.3, and it works with Windows, macOS, Linux, Android, and iOS.

3 AWESOME TIPS when working with OneNote & Outlook

Need to stay organized with Outlook? Use Microsoft OneNote and Outlook together. Three tips on working with OneNote and Outlook. Tip 1 - Insert your meeting invitation into OneNote. You can see a list of attendees and check that they attended, and take meeting notes.

Teams - Reply To Chats - New Feature October 2021

Microsoft Teams has a great new feature for Chat. You can now reply to specific chat messages. This is handy when you are doing a 1-on-1 chat or a group chat, and you have several messages you need to send replies to.

How to use the Subtotal Function with Filters in Excel

We love to use Filters in Excel. When filtering data, the filtered rows turn blue. To get the SUM, AVERAGE, MAX, MIN, or COUNT of the filtered data, use the SUBTOTAL function.

Excel SORTBY Function | Excel One Minute Quick Reference

The SORTBY function in Excel sorts the contents of a range or array based on the values in a corresponding range or array. Use SORTBY to see a list of employees sorted by highest paid, but you don't show their salaries. USE SORTBY to sort a customer list by the most profitable customer but not see the revenue.

Excel FILTER Function | Excel One Minute Quick Reference

The FILTER function in Excel allows you to filter a range of data based on the criteria you define. The FILTER function is a dynamic array function. The FILTER function has three arguments, but only two are required.