IFS function - Microsoft Support
The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.
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
Turn on device encryption - Microsoft Support
In the search box on the taskbar, type Manage BitLocker and then select it from the list of results. Or, select the Start button, and then under Windows System, select Control Panel.In Control Panel, select System and Security, and then under BitLocker Drive Encryption, select Manage BitLocker. Note: You'll only see this option if BitLocker is available for your device.
Send large files with Outlook - Microsoft Support
Compress the file. When you compress, or zip, your file, it decreases its size, and it might decrease it enough to fit within the Outlook size limits for attachments.The following articles describe how to compress and extract files for different Windows operating systems.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
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
Troubleshoot problems updating Windows - Microsoft Support
Important: Before trying any of the solutions below, make sure you back up your personal files. You can back up your Windows PC, or insert a USB drive and use File Explorer to drag and copy important files to the USB drive.If you’re signing into Windows with a Microsoft account, your system settings will be automatically restored after updating, once you’re connected to the internet.
How to sign in to Hotmail - Microsoft Support
Tips: While signing in, select Yes at the "Stay signed in?" prompt if you want to go straight to your mailbox next time (not recommended for shared computers). Alternatively, check the "Don't show this again" box and select No to be prompted for your password each time.. If you can't sign in, or have forgotten your username or password, use our sign-in troubleshooter.
Applies To: Outlook.com
Find the serial number on your Microsoft or Surface device
If you have this Surface. Find it here. Surface Laptop, any Surface Laptop Go, and Surface Laptop SE. Look under your keyboard near the hinge. Any Surface Laptop Studio. Starting in Laptop mode, gently rotate the top of the display backwards 180 degrees.
Create a simple formula in Excel - Microsoft Support
You can create a simple formula to add, subtract, multiply or divide values in your worksheet. Simple formulas always start with an equal sign (=), followed by constants that are numeric values and calculation operators such as plus (+), minus (-), asterisk (*), or forward slash (/) signs.The following is an example of a simple formula.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Create and add an email signature in Outlook.com or Outlook on the web
To get support in Outlook.com, click here or select Help on the menu bar and enter your query. If the self-help doesn't solve your problem, scroll down to Still need help? and select Yes.. To contact us in Outlook.com, you'll need to sign in.
Applies To: Outlook on the web, Outlook.com, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
Convert numbers stored as text to numbers - Microsoft Support
Most of the time, Excel will recognize this, and you'll see an alert next to the cell where numbers are being stored as text. If you see the alert:
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel Web App