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 airplane mode on or off - Microsoft Support
Note: Airplane mode retains the settings you used last time.When you turn on airplane mode, Windows remembers if you had Wi-Fi or Bluetooth on last time, and keeps that setting so your Wi-Fi or Bluetooth will be on again.
Change the line spacing in Word - Microsoft Support
This overrides the settings of the style you’re currently using. If you decide later to return to the original settings, go to Design > Paragraph Spacing and choose the option under Style Set.The option might be Default, as shown above, or it will show the name of style you’re currently using.. Change the line spacing in a portion of the document
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Sync your account in Outlook to the Microsoft Cloud
To enhance your Microsoft 365 experience in new Outlook for Windows, Outlook.com, Outlook for iOS, Outlook for Android, and new Outlook for Mac, you can now sync your non-Microsoft accounts (including their emails, contacts, and events) to the Microsoft Cloud.
Applies To: Outlook 2021 for Mac, Outlook 2019 for Mac, Outlook.com, New Outlook for Windows, Outlook for Android, Outlook for iOS
Ändern der Browser-Startseite - Microsoft-Support
Geben Sie auf der Registerkarte Allgemein unter Startseite die URL der Website ein, die Sie als Startseite festlegen möchten. Sie können mehrere URLs hinzufügen. Für die aktuell angezeigte Website wählen Sie Aktuelle verwenden.Wenn Sie mehr als eine URL verwenden, fügen Sie jede URL in eine eigene Zeile ein.
Surface help & learning
Choose from a variety of Surface devices and accessories to get help.
Set up rules in Outlook - Microsoft Support
Select a condition, and what to do with the message based on the condition. For example, to move messages with a certain title to a specific folder, select the Subject contains condition, select Move the item to folder, select or create a New folder, and then select OK.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Use voice recognition in Windows - Microsoft Support
Tip: If you've already set up speech recognition, pressing Windows logo key +Ctrl+S opens speech recognition and you're ready to use it. If you want to retrain your computer to recognize your voice, press the Windows logo key , type Control Panel, and select Control Panel in the list of results. In Control Panel, select Ease of Access > Speech Recognition > Train your computer to better ...
Filter junk email and spam in Outlook - Microsoft Support
When you mark email as junk, you can report the message to Microsoft to help improve the accuracy of the junk email filter. To set junk email reporting options, select Settings > Mail > Automatic processing > Junk email reporting.. Specify when to send junk email reports
Applies To: Office for business, Office 365 Small Business, New Outlook for Windows, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
IF function – nested formulas and avoiding pitfalls
Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False.
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, Excel Web App, Excel for Windows Phone 10