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
Create a poll in Outlook - Microsoft Support
Check your poll results. You can see aggregated results in the voting card that is in the body of the email. Click Refresh to see the most updated results or click View in Forms to see detailed responses on forms.office.com.Similarly, you can click on the poll link in the body of the email to track more detailed results on forms.office.com.. Feedback for Microsoft Forms
Applies To:
Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Outlook.com, Microsoft Forms
Share OneDrive files and folders - Microsoft Support
The files on your OneDrive are private until you share them. Keep in mind that when you share folders with Edit permissions, people you share with can add the shared folders to their own OneDrive.. This lets them keep the folder alongside their own folders and items, easily move items between folders, and more easily work on it offline.
Applies To:
OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint in Microsoft 365, Office for business, Microsoft 365 admin, OneDrive (work or school), OneDrive (home or personal), SharePoint in Microsoft 365 Small Business
Quick start: Create a macro - Microsoft Support
Take a closer look at the macro . You can learn a little about the Visual Basic programming language by editing a macro. To edit a macro, in the Code group on the Developer tab, click Macros, select the name of the macro, and click Edit.This starts the Visual Basic Editor.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Create a form with Microsoft Forms - Microsoft Support
Tip: You can also format your text.Highlight a word or words in your title or questions, and then choose any of the following: Bold (keyboard shortcut - CTRL/Cmd+B), Italic (keyboard shortcut - CTRL/Cmd+I), Underline (keyboard shortcut - CTRL/Cmd+U), Font color, Font size, Numbering, or Bullets.
Applies To:
Excel for the web, OneNote for the web, OneDrive (work or school), Microsoft Forms
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
Here's an example of how to use VLOOKUP. =VLOOKUP(B2,C2:E7,3,TRUE) In this example, B2 is the first argument—an element of data that the function needs to work.For VLOOKUP, this first argument is the value that you want to find.
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Open your entire favorites bar in Microsoft Edge
Choose Open all, or Open all in new window, or Open all in new InPrivate window.
Set up the Microsoft Authenticator app as your verification method
Method. Used for. Authenticator app. Two-factor verification and password reset authentication. Text messages. Two-factor verification and password reset authentication.
Get started with Microsoft Teams - Microsoft Support
Training: Microsoft Teams is a collaboration app built for hybrid work to help you and your team stay informed, organized, and connected. Learn how in this video.
Applies To:
Microsoft Teams
Subscriptions & billing | Xbox Support
Get more information about managing your Xbox subscriptions, issues with billing, and more.