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
Manage display language settings in Windows - Microsoft Support
The display language you select changes the default language used by Windows features, such as Settings and File Explorer. Select Start > Settings > Time & Language > Language.
Meet Windows 11: The basics - Microsoft Support
Try it! Universal search. Select Search on the taskbar or press Windows logo key + S, then type what you want to find.You'll get personalized search results for people, email, and files in local and shared sites, or from the web. Desktop groups
Introduction to lists - Microsoft Support
The following are some ways you can work with lists to help you to manage information for your group. Track versions and detailed history Track versions of list items, so that you can see which items have changed from version to version, as well as who changed the list items.If mistakes are made in a newer version, you can restore a previous version of an item.
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013, SharePoint in Microsoft 365, Microsoft Lists
Enable or disable macros in Microsoft 365 files
Disable all macros except digitally signed macros Macros are disabled, and security alerts appear if there are unsigned macros present.However, if the macro is digitally signed by a trusted publisher, the macro just runs. If the macro is signed by a publisher you haven't trusted yet, you are given the opportunity to enable the signed macro and trust the publisher.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Visio Professional 2021, Visio Standard 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, Visio Professional 2016, Visio Standard 2016
What's new in recent Windows updates - Microsoft Support
Windows share window: Select the Outlook icon in the “Share using” section of the Windows share window to email your files using Outlook directly within the windows share window.It also has a search box. So, you can now search for contacts across Outlook to share a file. The Windows share window also displays 8-10 suggested contacts to quickly share to–including emailing yourself a file.
Using the Windows Activation troubleshooter - Microsoft Support
To activate using your digital license, you'll need to upgrade to Windows 11 Pro: Save your work and close any open apps.
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
Find and open File Explorer - Microsoft Support
File Explorer in Windows 11 helps you get the files you need quickly and easily. To check it out in Windows 11, select it on the taskbar or the Start menu, or press the Windows logo key + E on your keyboard.. How to use File Explorer:
Create and add an email signature in Outlook.com or Outlook on the web
To get support in Outlook.com, click here or select Help on the menu bar and enter your query. If the self-help doesn't solve your problem, scroll down to Still need help? and select Yes.. To contact us in Outlook.com, you'll need to sign in.
Applies To: Outlook on the web, Outlook.com, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019