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
The **UNIQUE** function in Excel returns a list of unique values in a list or range. The **SORT** function in Excel sorts the contents of a range or array. The functions are great individually, but I frequently combine them. In the video below, I show Unique and Sort in seven
Microsoft Outlook
Do you need to send an email from Outlook to Teams? Teams and Outlook integration has a great new feature (April 2021). From Outlook or Outlook on the web, you can share emails to Team chats or Team channels. Does the email contain attachments? You have the option to share
Microsoft Excel
PivotTables are great for summarizing and analyzing data. **Report Filter Pages** is a great way to generate multiple reports. For example, we have a list of 12 Salespeople and their customer and their orders. We can use Report Filter Pages to create 12 additional reports, one for each rep quickly.
Finance
Posted on: 04/08/2021 Simple Bank is closing on May 8, 2021. Simple is transitioning to BBVA USA. The good news is your money is safe. It is already with BBVA. You won't lose any money! You can continue to use your Simple debit card and checking
Microsoft Excel
Trying to decide what University or College to attend is a big life decision. Microsoft is helping out with these big life decisions with their Excel **College Decision Helper Template**. The template uses Excel's new linked data types. Type in a college and see data for location, tuition,
Do you use Google Chrome and have too many tabs open? The solution is to use Tab Groups. Tab groups in Chrome help you organize your tabs. You can use tab groups to groups tabs, name the tab group, and even add color to the group to make it easy
Finance
**Simple Bank is closing on May 8, 2021. This article is part of a series of personal finance articles centered around the transition of Simple Bank accounts to BBVA. This article has a specific audience: Simple Bank customers who may not want their accounts to be taken over by BBVA
Microsoft Word
Microsoft has a new feature where you can EXPORT your Word document into PowerPoint. It is just a few clicks to convert your Word doc to a slide deck. It is in preview mode right now, but it worked great in all my test. Exporting Word into PowerPoint is a
Microsoft Excel
Need to quickly access an Excel file or Word document in a Teams Channel? It is easy to add a file as a documents tab in a channel. This is so much easier than trying to find a file. If there is an Excel file you access daily or frequently
Microsoft Outlook
You can easily make a contact group, formerly known as a distribution list, in Outlook by copying and pasting Excel data into Outlook. A Contact Group is handy if you email the same group of people frequently. The group can be your team, a project team, a committee, or even
Teams
**Microsoft Teams March 2021 update includes a few great features, most of them have to do with the New Look of Teams which not only brings a slight color scheme change, but also convenience and streamline enhancements.** If you recall, the previous versions of Teams had a kind of blue
Microsoft PowerPoint
Microsoft Teams keeps rolling out the cool features for Teams Meetings. Today, I’d like to tell you about new improvements for presenting PowerPoint slide decks, during a Teams meeting. Speaker notes are visible by default When you're in a Teams meeting and click Share content, you can