Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
Teams
Posted on: 05/21/2021 **Microsoft Teams has a new feature in May 2021 update that I love. This has to do with sharing your screen, whether you're in a video call or in a meeting. Screen sharing is now much easier, particularly the part where you select
Microsoft Excel
**If adding events to your Google Calendar is tedious or you have many events you need to add quickly, you can use a CSV file you can generate in Microsoft Excel, to populate your calendar quickly and easily. Read below to find out how to do it, what fields are
Zoom
**Zoom Immersive View is a step up from Virtual Backgrounds. It allows you to arrange your meeting participants (whether it's a normal meeting or a webinar) into a single virtual background, making them look like they are in the same scene, room, classroom and so on.** How to
Microsoft Forms
Microsoft Forms has three new features that were recently rolled out. I'll cover all three in under three minutes. You can now format your surveys or quizzes using bold, italics, or underline. You can also send a survey out to specific users or groups in your organization, and
Microsoft Excel
Need to know when your investment will double? In finance, the rule of 72 is an easy method for determining when an investment will double. Take the number 72 and divide it by the interest rate, which gives you the number of years. For example, a 5,000 investment at
Microsoft Word
Selecting a word, sentence, paragraph, or the entire document in MS Word is easy. Here is a short video on how to correctly select with the mouse. **Word - triple click a word to select a paragraph** How do I select text in Word with the mouse? - Paragraph -
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