Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
Microsoft 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
Zoom
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 1. Short answer 2. Long answer 3. Matching 4. Rank order 5. Rating 6. Fill
Microsoft Outlook
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. Tip 3 - Create a task from an email message. Tip 4 - Send an
Microsoft Teams
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. Join Teams from mobile phone Transfer to this device -
Microsoft Excel
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 follow three rules before I use Subtotals - 1) Save, 2)
Microsoft Excel
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. Navigation Pane in Excel - Worksheets show and elements on the worksheet
Microsoft Excel
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
Zoom
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 - Zoom version 5.
OneNote
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. Insert Outlook Meeting Details into
Microsoft Teams
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. Reply to a specific chat in MS Teams
Microsoft 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. Subtotal Function in Excel If you use one of the functions with one argument - SUM, AVERAGE, MAX,
Microsoft Excel
The SORT function in Excel sorts the contents of a range or array. Example, =SORT(B2:B20). You can also sort in ascending or descending order with the SORT function. =SORT(B2:B20,,-1) would sort descending or highest to lowest. The number 1 would sort ascending, which is the