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
打开或关闭 Microsoft Defender 防火墙 - Microsoft 支持
若要将其关闭,请将设置切换为“关闭”。 关闭 Microsoft Defender 防火墙可能会使设备(以及网络,如果有)更容易受到未经授权的访问。
Poll attendees during a Teams meeting - Microsoft Support
As a meeting presenter, you can use Microsoft Forms to create polls before your Microsoft Teams meeting, then launch them during it so attendees from any endpoint (mobile, web, desktop) can view and answer. When you launch your poll, it will pop up on attendees' meeting screens as well as in the meeting chat. Attendees can also create ad-hoc polls during a meeting to get quick feedback on the ...
Applies To: Microsoft Forms, Microsoft Teams
Use mail merge for bulk email, letters, labels, and envelopes
Data sources. Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. Excel spreadsheets and Outlook contact lists are the most common data sources, but if you don't yet have a data source, you can type it up in Word, as part of the mail merge process.
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, Word 2016 for Mac
Check and share your form results - Microsoft Support
Notes: If you're using the mobile site, go to the Responses tab on the bottom of the site and select the arrow in the center. You'll be able to copy or email the link from there.
Applies To: PowerPoint for Microsoft 365, Microsoft Forms
Schedule a Microsoft Teams meeting from Outlook
Troubleshooting The people selection menus in Meeting options don't show invitees I've added to an occurrence of a meeting series. In this scenario, you will need to invite people to the meeting series, rather than to the meeting occurrence.
Applies To: Microsoft Teams
INDEX function - Microsoft Support
Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.
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
Play, share, and download a meeting recording in Microsoft Teams
Depending on the length of the video, generating closed captions can take several minutes. Once generated, you can watch the video in Stream and have captions displayed at the bottom of the screen.. When the caption have been created, the Generate button turns to Translate.Select Translate to change the spoken or screen language to automatically translate the captions.
Applies To: Microsoft Teams
Getting started with Microsoft Family Safety - Microsoft Support
A family group is a set of individuals connected through the Microsoft Family Safety app on their Windows, Xbox, or mobile devices. Establishing a family group is an easy, effective way to encourage healthy online habits and manage busy schedules.
Applies To: Microsoft Family Safety
Add an exclusion to Windows Security - Microsoft Support
If you trust a file, file type, folder, or a process that Windows Security has detected as malicious, you can stop Windows Security from alerting you or blocking the program by adding the file to the exclusions list.