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
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.