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
Dictate your documents in Word - Microsoft Support
Learn how to use your voice to create and edit documents in Word with the Dictate feature. Find out how to enable, customize, and troubleshoot Dictation.
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
Dark Mode in Outlook - Microsoft Support
In Outlook, the black color theme includes dark mode, which provides a black background (instead of white) for the message window. You can switch to a white background for the message window if you prefer.
Applies To:
Outlook for Microsoft 365, Outlook on the web, Outlook.com
Track my Microsoft Rewards orders - Microsoft Support
Use a mobile or landline phone number to authenticate your account when attempting to redeem Rewards points. Do not use a VoIP phone number.
Use Microsoft Authenticator with Microsoft 365
Learn how to use Azure Authenticator with Microsoft 365. It makes 2-step verification really easy!
Applies To:
Office for business, Microsoft 365 admin
Turn on device encryption - Microsoft Support
Learn how to turn on device encryption, or standard BitLocker encryption in Windows.
Install and set up Office on an iPhone or iPad - Microsoft Support
How to install Office for iOS on your iPhone or iPad and use the apps with Microsoft 365.
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, OneNote for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac, Excel for the web, OneNote for the web, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Office 2021, OneNote 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac, OneNote 2021 for Mac, Office 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Office 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, OneNote 2019 for Mac, Office 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, OneNote 2016, Office 2016, PowerPoint for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, Office app for iOS, Outlook Web App, Skype for Business for iPad
Add or invite people outside your org to a chat in Microsoft Teams
With External Access for Teams, you can add or invite anyone outside of your Teams org who uses Teams, Teams for personal use, Skype (for consumers), and Skype for Business to a one-to-one chat.
Applies To:
Microsoft Teams
Create a flow chart with SmartArt - Microsoft Support
A flow chart shows sequential steps in a task or process. There are many different SmartArt layouts that you can use to illustrate the steps in a process, including layouts that can contain pictures.
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel 2021, Word 2021, PowerPoint 2021, Excel 2019, Word 2019, PowerPoint 2019, Excel 2016, Word 2016, PowerPoint 2016
Eingabeort für den Office-Product Key - Microsoft-Support
Wenn Ihr Kauf von Office oder Microsoft 365 mit einem Product Key verbunden war, geben Sie Ihren Product Key auf einer der Websites ein, die nachstehend für Ihr Produkt aufgeführt sind.
Applies To:
Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Office 2016, Microsoft 365 for home, Office.com