Microsoft Excel
Excel has dynamic array functions. Two of the dynamic array function are SORT and UNIQUE. I will combine SORT and UNIQUE and also combine them with COUNT and the COUNTA functions. This came from a user that asked how many unique zip codes were in a spreadsheet. **SORT and UNIQUE
Zoom
Zoom has a great new feature using Polls and Breakout Rooms. Now, when you launch polls, you can create breakout rooms from the poll results! This feature is part of Zoom 5.13.5 released on January 16, 2023. **Zoom Breakout Rooms from Polls** Steps to enable breakout rooms from
Microsoft OneDrive
Updated: November 23, 2025
Microsoft Teams
Microsoft Teams Channels is a great way to communicate and collaborate. I love group chat also, but one HUGE advantage a Team has over a group chat is the ability to manage files and folders. **Teams Channel - Drag and Drop to move files or folders in a channel** With
Microsoft Excel
Excel allows you to pull data on a webpage into Excel. This is a great time-saving feature. Getting data from a webpage is done in Excel on the Data Tab using Get and Transform Data group, From Web command. **Excel - Data From Web** Get Started - Find a webpage
Microsoft Excel
Frequently we have data in one format but need to convert it to another. Today's example is I have a column on seconds for the length of videos. I want to show minutes and seconds with a colon in between the minutes and seconds. **Convert seconds to minutes
Microsoft Teams
Teams now allows you to launch an Instant Poll in a meeting. This is a great feature to gather feedback or get the pulse of your audience There are three options for instant polls: 1. Yes/No 2. Thumbs up/Thumbs down 3. Like/Dislike. **Instant Polls in Teams** How
Microsoft Excel
Microsoft keeps rolling out awesome new features for M365 users. Many of the new features hit Excel in 2022. This video covers my top five favorite features in Excel from 2022. Navigation Pane - Top 5 of 2022 for Excel YouTube Video TOP 5 Excel Features Released in 2022 Chapters
Microsoft
Chris Menard achieves Microsoft Certified Trainer certification. Menard has been a Microsoft Certified Trainer for over 10 years. The certification must be renewed every year. Microsoft Certified Trainers (MCTs) are the premier technical and instructional experts in Microsoft technologies. Click **[here](https://www.credly.com/badges/81c5f438-cc53-4f27-9756-b1d9f806e239/public_url)** to
Microsoft Teams
It is finally here! You can delete an entire chat in Microsoft Teams!!! Teams users can delete an entire one-on-one chat or group chat. Delete the chat will not delete the chat for other users. This feature is rolling out to General Availability in December 2022. Feature ID is 90723
Microsoft
Chris Menard's YouTube channel hits **43,000 subscribers on November 27, 2022!** Menard has been an active YouTuber since 2018 **.** His technology videos cover: 01. Excel 02. Word 03. Teams 04. Outlook 05. Microsoft Forms 06. PowerPoint 07. Zoom 08. Google Calendar 09. Gmail 10. and other software
Microsoft Excel
Filter in PivotTables only allows one filter by default. To filter by more than one field, you need to turn on Allow multiple filters per field. To turn on, Allow multiple filters per field. 1. Right-click on a column in the PivotTable 2. Click **PivotTable Options...** 3. Click the **Totals