UNIQUE function - Microsoft Support
Examples. Example 1. This example uses SORT and UNIQUE together to return a unique list of names in ascending order. Example 2. This example has the exactly_once argument set to TRUE, and the function returns only those customers who have had service one time.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Insert data from picture - Microsoft Support
Take a picture of some printed data Maybe you’d like to get data from your previous tax returns into Excel and you only have printed copies.Just take a picture of each one, transfer the pictures to your computer (OneDrive is great for this). Then, click Data > From Picture > Picture From File and follow the on-screen instructions to convert picture to data.
Applies To: Excel for Microsoft 365
如何登入 Hotmail - Microsoft Support
提示: 登入時,如果您下次想要直接移至信箱,請在 [保持登入?] 提示中選取 [是] (不建議用於共用電腦)。 或者,選取 [不要再顯示這個] 方塊,然後選取 [否],這樣每次都會提示您輸入密碼。. 如果您無法登入或忘記您的使用者名稱或密碼,請使用我們的 [登入疑難排解員]。
Applies To: Outlook.com
External or guest sharing in OneDrive, SharePoint, and Lists
If you want to secure your content and get a link that only works for the people you invite, select Specific people in Link settings when creating the sharing link.. The recipients' experience depends on the settings you select when creating the sharing link, and the account they use to view the file.
Applies To: Microsoft Lists, OneDrive (work or school), OneDrive for Mac, OneDrive for Windows
What is SharePoint? - Microsoft Support
SharePoint Server Organizations can deploy and manage SharePoint Server on-premises or with an Office 365 Enterprise subscription to take advantage of all the latest features.And it offers additional features and capabilities, such as modern site pages, modern web parts and authoring, modern lists and libraries, modern search, integration with PowerApps, Power BI and MS Flow, and SharePoint ...
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint in Microsoft 365, Microsoft 365 admin, SharePoint Foundation 2013, SharePoint Foundation 2010, SharePoint Server 2010
Customize permissions for a SharePoint list or library
Important: While SharePoint allows considerable customization of site permissions, we highly recommend using the built-in SharePoint groups for communication sites and managing team site permissions through the associated Microsoft 365 group.You can add, change, or remove permissions for an individual document or folder by following methods mentioned in Share files or folders in Microsoft 365.
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint in Microsoft 365, SharePoint Server 2010, Microsoft Lists, SharePoint admin center, SharePoint in Microsoft 365 Small Business, SharePoint operated by 21Vianet
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
Cancel your Microsoft subscription - Microsoft Support
Note: In the following countries, you can cancel your subscription, and depending on the subscription length you may be entitled to a prorated refund.See Countries with prorated refunds for Microsoft subscriptions for more information. Any subscription length - Canada, Israel, Korea, and Turkey Subscriptions longer than 1 month and renewed - Denmark, Finland, Germany (purchases on or after ...
Applies To: Microsoft account dashboard
Change TCP/IP settings - Microsoft Support
TCP/IP defines how your PC communicates with other PCs. To make it easier to manage TCP/IP settings, we recommend using automated Dynamic Host Configuration Protocol (DHCP).
Get started with Copilot in Microsoft Teams meetings
From the meeting chat, select Open Copilot in the upper-right corner of the chat—you'll see the Copilot icon.From here, Copilot bases responses on the meeting transcript, not the meeting chat. You'll see the same conversation history with Copilot as the one accessed from Recap.Select View prompts to choose from the suggestions, or try the following prompts:
Applies To: Microsoft Teams