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
Join a meeting without an account in Microsoft Teams
Learn how to join a Microsoft Teams meeting if you don't have an account. Join a Teams meeting as a guest in the Windows app or on the web.
Applies To: Microsoft Teams
Use Microsoft Authenticator with Microsoft 365
Choose the mobile app. Open a browser on your computer and go to portal.office.com.Sign in to your Office 365 for business account.
Applies To: Office for business, Microsoft 365 admin
Phone Link requirements and setup - Microsoft Support
1. Sign in with your Microsoft account. You will be prompted to Sign in with Microsoft account. If you have an existing Microsoft account on your mobile device then you will be asked to confirm your account, then click Continue.. If you don't have an existing Microsoft account on your mobile device then you will be asked to sign into your account or create a new one, then click Continue.
Export emails, contacts, and calendar items to Outlook using a .pst ...
Note: Exporting and importing a mailbox using a .pst file isn't supported in new Outlook at this time. To export a mailbox, you need to use the desktop version of Outlook (also known as classic Outlook) following the steps below.Classic Outlook is included with Microsoft 365 subscriptions that include desktop apps such as Microsoft 365 Personal or Family or Microsoft 365 Business Standard, and ...
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin
Encrypt email messages - Microsoft Support
When you need to protect the privacy of an email message, encrypt it. Encrypting an email message in Outlook means it's converted from readable plain text into scrambled cipher text.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Create or edit a hyperlink - Microsoft Support
Optional: To customize the ScreenTip that appears when you rest the pointer over the hyperlink, click ScreenTip in the top-right corner of the Insert Hyperlink dialog box and enter the text you want. You can also create a hyperlink to a blank email message by simply typing the address in the document. For example, type someone@example.com, and Microsoft 365 creates the hyperlink for you ...
Applies To: Word for Microsoft 365, Outlook for Microsoft 365, Project Online Desktop Client, Word 2021, Outlook 2021, Project Professional 2021, Project Standard 2021, Word 2019, Outlook 2019, Project Professional 2019, Project Standard 2019, Word 2016, Outlook 2016, Project Professional 2016, Project Standard 2016, Office 2016, InfoPath 2013, InfoPath Filler 2013
How to change your Microsoft account password | Xbox Support
Important Because changing your Microsoft account password is slightly different than resetting a forgotten password, this page does not cover the steps to reset your account password.
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
How to use two-step verification with your Microsoft account
Important: If you turn on two-step verification, you will always need two forms of identification.This means that if you forget your password, you need two contact methods. Or if you lose your contact method, your password alone won't get you back into your account—and it can take you 30 days to regain access.