Microsoft Office Blog by Chris Menard

OneNote - SORT PAGES - New Feature - 2022

Previously, in OneNote, if you wanted to sort pages, you had to drag them around manually. Now, you can sort your pages in OneNote automatically!

Breaks in Microsoft Word: Page, Section, Column break with examples

Handling complex documents in Word couldn't be easier when you understand how section and page breaks function in Word.

Teams - Files app to find files in Teams chat, channels, downloads, and OneDrive

Microsoft Teams handles multiple file types. The files can be located in multiple locations. Chats, Channels, Meetings, and Channel Tabs. The "Files" app in Teams is located on the Navigation Bar, also known as the Sidebar.

Excel Conditional Formatting - Getting started with five examples

Conditional Formatting is one of Excel's best features. I use it daily. In this short video, I'll get you started using Conditional Formatting.

Excel Five Great Tips for Filtering Data

Five great filtering tips for Excel. Filter by selected cells value, copy and paste filtered data, delete filtered data, auto-calculate works with filtered data, and search for filtered data.

Excel - Create a custom list to sort data

Excel makes it easy to sort using built-in custom lists, you can sort data—either by days of the week or months of the year. I'll demonstrate how to create your own custom lists to sort by any other characteristic that doesn’t sort well alphabetically.

Excel VLOOKUP for Tax Brackets Year 2021 with Examples

How to calculate progressive tax with 2021 tax brackets and VLOOKUP in Excel, with examples. Tax brackets show you the tax rate you will pay on each portion of your income.

How To Show Percentages In Stacked Column Chart In Excel

With a stacked column chart in Excel, you can view partial numbers, but what do you do when you want to show percentages? Excel's pie charts show percentages, but stacked column charts do not. We are going to use a mixed reference to create a column chart with percentages.

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.