How to Configure Microsoft Teams Notifications

---

• How to Configure Microsoft Teams Notifications
• How to Calculate the Sum of Squares in Excel
• How to Enable Startup Sound on Your Chromebook

How to Configure Microsoft Teams Notifications Posted: 05 Jan 2021 07:37 AM PST Microsoft Teams does a great job of informing you about new messages and other activity, but it can get a bit overwhelming if you're in lots of teams. Here's how to turn off or customize Microsoft Teams notification. Teams will provide notifications about chats, meetings, direct messages, mentions, other people's status, and even when someone you know joins your team. It will do this by adding a number to the Teams icon on the taskbar, making that same icon flash, playing a noise, and popping up a banner notification in the bottom-left corner of your screen. And if you miss any of that, it will send you a missed activity email. If you work somewhere that uses Microsoft Teams a lot, this can become a barrage of alerts that constantly interrupt you with information that you don't need to know. Getting pulled out of your focused zone by an alert telling you that Geoff from Accounts has just come online is really not helpful or productive. You should decide what's worthy of breaking your concentration, not your software. RELATED: How to Turn Off or Customize New Email Alerts in Outlook Fortunately, you can change all of these settings and make Teams alerts as loud or as quiet as you like, and it's easy to do. You can also change notifications for specific conversations and chats, or change notifications for specific periods of time. How to Manage General Notifications Open Microsoft Teams on your computer, click your profile picture, then select "Settings" in the menu. In the "Settings" panel, click "Notifications." This is where you can customize all of your notification settings. Let's start at the top and work our way down. At the top of the Notifications are three options, all of which can be turned off: Missed activity emails: The frequency of emails sent to you when you miss a chat message, channel mention, or anything else worthy of an alert. This can be set to "Off" entirely if you don't want to be bombarded with emails, or at best "Daily," so you only get one email a day. Show message preview: Whether or not a "toast" popup (the notifications that pop up in the bottom right of the screen) showing a preview of messages you've received is displayed. These are distracting at best, and they get in the way when you're trying to type messages in Teams, so turn them off. Play sound for notifications: Nothing breaks your concentration quite like a loud "ding" going off in your headphones, and whilst the Teams notification isn't the most irritating alert noise, it's still annoying. Turn it off here and get your peace and quiet back. The next section, "Teams and Channels," covers messages in the standard "Posts" tab in every channel. It's not absolutely clear what the first two options will cover and what they won't. For example, does "Mentions and Replies" alert you to reactions? It's not obvious. That's far from ideal, so instead choose "Custom." This will open up the individual settings that cover all teams and channels. All of the dropdowns (except "Personal @mentions") have three options: Banner and feed: Show the "toast" popup, and also mark the channel with an icon Only show in feed: Mark the channel with an icon Off: Don't show the toast popup and don't mark the channel with an icon. "Personal @mentions" doesn't have this option, because Teams won't let you turn off alerts entirely for mentions. You may want to choose different values for different dropdowns here. "All New Posts" is off by default and that makes sense unless you're monitoring a channel for a reason. But you probably want at least "Only show in feed" for "Replies to conversations I started." Once you've finished changing the dropdowns, click "Back To Settings." The remaining four options deal with specific areas of Teams. Chat: Covers notifications for mentions, replies, and reaction in chat messages (that's direct messages between you and someone else, not general messages in the Posts tab of a channel). Meetings: Notifications for when a meeting starts, or when someone posts in a meeting chat. People: Set up notifications to find out when specific individuals become available or go offline. Other: Choose whether to get a notification when someone in your Outlook contacts joins Teams. Click the "Edit" button next to each item and choose your notification options. When you've finished editing the notifications, close the "Settings" panel and watch as Teams no longer yells at you every few seconds. How to Manage Notifications for Specific Channels After you've set your general notifications, you can set notification rules for specific channels if you want more fine-grained control of when you get notified. Hover over a channel, click the three-dot icon to the right of the name, and then select "Channel Notifications." You can use these settings to change the notifications for this specific channel without changing the general notification settings that act as the default for all other channels. How to Manage Notifications for Specific Conversations and Chats There will be times when you have your notification settings just the way you want, but specific conversations or chats keep pinging notifications at you anyway. This often happens when someone pulls you into a channel or chat to ask a question and then you get notifications about all the replies and reactions even though you're not really involved. Rather than changing your general notifications, you can turn off notifications for a specific conversation in a channel, or mute a specific chat. To turn off notifications for a specific conversation in a channel, hover over the first message in the thread, click the three-dot icon, and select "Turn Off Notifications." From now on, you'll only get a notification about this conversation if someone mentions you directly. To resume notifications, hover over the first message in the thread, click the three-dot icon, and  select "Turn On Notifications." To mute an entire chat with someone, hover over their name in Chat, click the three-dot icon, and select "Mute." From now on, you won't get any notifications from this chat. To resume notifications, hover over their name in "Chat," click the three-dot icon, and select "Unmute." How to Stop Notifications for a Specific Period of Time If you want to completely stop notifications for a while, you have a couple of options (other than closing the Microsoft Teams app entirely, of course). The first option is to change your status to "Do Not Disturb." This will silence all notifications so you don't get any popups or noise notifications until your status changes. To change your status, click your profile picture, select your current status, then choose the "Do Not Disturb" option in the menu. Microsoft Teams will keep you in Do Not Disturb status until you change it to something else manually, enter a scheduled meeting, or close the Teams app. The other option for turning off notifications for a period of time is to use Focus Assist, a built-in Windows tool that hides alerts from any (or all) apps at times and situations you choose. We've covered Focus Assist in-depth, but here's what you need to do to make sure it does what you want for Teams. While you can open Focus Assist in a number of ways, we're going to go there through the "Settings" panel. Press Windows+i on your keyboard to open up the "Settings" panel, search for "Focus Assist," then select "Focus Assist Settings" from the dropdown menu. Scroll down to the "Automatic Rules" section and turn on the options you want to enable. Each option allows either "Priority Only" or "Alarms Only," which can be amended by clicking the option and changing the "Focus Level." "Alarms" specifically refers to alarms generated by the clock or alert apps. If you don't want to be disturbed at all, you can set the option to "Priority Only" and remove all priority apps. You can additionally customize "During These Times" by clicking on it and changing the time options. This is useful if you want Focus Assist turned on only at certain times of the day—like dedicated focus time—or just weekdays and/or weekends. See details

How to Calculate the Sum of Squares in Excel Posted: 04 Jan 2021 12:20 PM PST Finding the sum of squares in Microsoft Excel can be a repetitive task. The most obvious formula requires a lot of data entry, though there's a lesser-known option that gets you to the same place. Finding the Sum of Squares for Multiple Cells Start a new column anywhere in an Excel spreadsheet and label it. It's here that we'll output the solution of our squares. The squares don't have to be next to each other, nor does the output section; it can be anywhere on the page. Type the following formula into the first cell in the new column: =SUMSQ( From here you can add the letter and number combination of the column and row manually, or just click it with the mouse. We'll use the mouse, which autofills this section of the formula with cell A2. Add a comma and then we'll add the next number, from B2 this time. Just type in B2 to the formula, or click the appropriate cell to autofill it. Close the parenthesis and press "Enter" on the keyboard to display the sum of both squares. Alternatively, if you can keep going here, adding additional cells by separating each with a comma within the formula. To apply the formula to additional cells, look for the small filled square in the cell that contains the solution to our first problem. In this example, it's C2. Click the square and drag it down to the last row of number pairs to automatically add the sum of the rest of the squares. Finding the Sum of Squares for Just a Few Cells In our "Sum of Squares" column we created in the previous example, C2 in this case, start typing the following formula: =SUM((A2)^2,(A3)^2) Alternatively, we can just add the numbers instead of the cells to the formula, as either way gets us to the same place. That formula looks like this: =SUM((9)^2, (29)^2) You can alter these formulas as needed, changing the cells, adding additional numbers, or finding the sum of squares that aren't even in your workbook, for example. And while it's easier to follow along with the above tutorial, using the SUMSQ formula, to find the solution for multiple squares, it's often easier to just type out a quick formula like this if it's not something you'll be repeating throughout the workbook. See details

How to Enable Startup Sound on Your Chromebook Posted: 04 Jan 2021 09:16 AM PST CC Photo Labs/Shutterstock Computers traditionally have had a startup sound that plays as soon as they are up and running. Chromebooks don't have this out of the box, but if you miss that nostalgic touch of a startup chime, you can manually enable it from the settings. On your Chromebook, click the status section found in the bottom-right corner to reveal the quick settings panel. Select the gear icon to enter your Chromebook's Settings menu. Scroll down until you find the "Advanced" button and toggle it to reveal more options. Locate the "Accessibility" section, and from under that, head into "Manage Accessibility Features." At the bottom of this page, find and switch on the "Play Sound on Startup" option. In case you're facing trouble reaching this exact menu, you can look up the option's name from the search bar at the top of the Settings menu instead. That's about it. Now your Chromebook will play a brief startup chime at the login screen whenever you boot it up from a complete shutdown. Do note, though, that it won't ring when you are simply waking it from sleep. The chime's volume depends on your Chromebook's audio levels. Therefore, if you wish to mute it or make it less intrusive, all you need to do is turn down your Chromebook speaker's volume before turning the computer off. Alternatively, with the help of the Startup Sound for Chromebook Chrome extension, you can also set the startup chimes of other operating systems like macOS and even Windows XP. Once you have it installed, click its icon from the extensions tray in the top-right corner on Google Chrome. Pick a startup sound from the dropdown list, then hit "Save." Unlike Chrome OS's built-in startup sound, this extension's chime will trigger once you've logged into your Chromebook. See details

You are subscribed to email updates from My Blog. To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google, 1600 Amphitheatre Parkway, Mountain View, CA 94043, United States