Switch to the new Microsoft Teams - Microsoft Support
When in the new Teams, turn on (or off) notifications by selecting Settings and more at the top of the new Teams, then selecting Settings > Notifications > Open Windows notifications settings.Find Microsoft Teams (work preview) in the apps list and set your preference.
Applies To: Microsoft Teams
Download free, pre-built templates - Microsoft Support
Find and download free templates to create documents like calendars, business cards, letters, greeting cards, brochures, newsletters, or resumes.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio 2010, InfoPath 2013
COUNTIF function - Microsoft Support
Argument name. Description. range (required). The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to select ranges in a worksheet.. criteria (required). A number, expression, cell reference, or text string that determines which cells will be counted.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
FILTER function - Microsoft Support
The FILTER function allows you to filter a range of data based on criteria you define.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Pair a Bluetooth device in Windows - Microsoft Support
In quick settings: To find the quick setting for Bluetooth, select the Network, Sound, or Battery icons ( ) next to the time and date on the right side of your taskbar.Select Bluetooth to turn it on. If it's turned on without any Bluetooth devices connected, it might appear as Not connected . If you don't see Bluetooth in quick settings, you might need to add it.
Desktop Themes - Microsoft Support
A theme is a combination of desktop background pictures, window colors, and sounds. Get a theme. To get a theme, expand one of the categories below, select a link for the theme, and then select Open.This saves the theme to your PC and puts it on your desktop.
Add a Gmail account to Outlook for Windows - Microsoft Support
If you need instructions for adding an email account using advanced settings, go to Use advanced setup to add a POP or IMAP email account in Outlook for PC. Outlook won't accept my password. If Outlook won’t accept your password and you know you’re using the right password for your Gmail account, you might have an older version of Outlook that doesn't currently support this faster Gmail ...
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
Back up your Windows PC - Microsoft Support
Step 2: Back up your folders. Windows Backup is an easy, single stop for all of your backup needs. Your free Microsoft account comes with 5 GB of OneDrive cloud storage (and more storage is available if you need it), and backing up your folders syncs the folders you specify to your OneDrive account, making them instantly accessible on all computers that you use with this Microsoft account.
Save or forget passwords in Microsoft Edge - Microsoft Support
Note: The Automatically save passwords setting has been retired with Microsoft Edge version 124 and later. Instead, Edge will offer to save your passwords each time you enter new credentials in the Edge browser. All your previously autosaved passwords will continue to be available for a seamless login.
IF function - Microsoft Support
In this example, the formula in cell D2 says: IF(C2 = 1, then return Yes, otherwise return No)As you see, the IF function can be used to evaluate both text and values.It can also be used to evaluate errors.You are not limited to only checking if one thing is equal to another and returning a single result, you can also use mathematical operators and perform additional calculations depending on ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016