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 SUM function is the most popular and widely-used function in Microsoft Excel, along with its automated version: AutoSum. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. In this video, I demonstrate the SUM function and show you a few
Zoom
You can annotate your screen sharing, window sharing or webinars in Zoom by using a 'vanishing pen annotation'. Zoom had annotation features before, but in this update for Zoom version 5.6.3, you can draw anywhere on the screen, and in a few seconds, annotation disappears automatically.
Microsoft Excel
The rule of 72 finds the number of years to double your money at a given interest rate. Doing the math in your head is easy. Take 72 and divide by the interest rate. When you divide by the interest rate use the number without decimals. Example: 8% is 8.
Microsoft Outlook
If you're using Outlook for Microsoft 365, you can now have Outlook end your meetings early or start late. I prefer to end early, but it's up to you. End early or start late can help with digital overload for remote staff. You can choose a
Microsoft Excel
To compare two text strings in Excel, you can use the EXACT Function, or you can use =A1=B1. The EXACT function checks for case sensitivity. Example "Chris" is not the same as "CHRIS" if you use the EXACT function. With =A1=B1, Chris would appear
Microsoft PowerPoint
Microsoft PowerPoint includes a great feature or presentation coach that allows you to rehearse your presentation using the automated 'Rehearse with Coach' functionality. Rehearse with Coach is there to tell you your pace, if you're going too fast or too slow. It also tells you if
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