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
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
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
Customize or create new styles - Microsoft Support
You can use styles to quickly apply a set of formatting choices consistently throughout your document. If you want formatting choices that are not available from the built-in styles and themes available in Word, you can modify an existing style and customize it to suit your needs. You can change the formatting (such as font size, color, and text indentation) in styles applied to titles ...
Applies To: Word for Microsoft 365, Outlook for Microsoft 365, Word 2021, Outlook 2021, Word 2019, Outlook 2019, Word 2016, Outlook 2016
Set your work hours and location in Outlook - Microsoft Support
Microsoft 365 helps you manage and share your work schedule. New features allow you to specify more details about your work schedule: from where you’re working (remotely or in office) and whether you work different hours on different days. In addition, you’ll be able to schedule meetings with others based on their work location and view work location on people’s contact cards.
Applies To: Outlook on the web, Microsoft Teams, New Outlook for Windows
How to perform a clean boot in Windows - Microsoft Support
How to determine what is causing the problem after you do a clean boot. If your problem does not occur while the computer is in a clean boot environment, then you can determine which startup application or service is causing the problem by systematically turning them on or off and restarting the computer.
Create an Outlook profile - Microsoft Support
Note: Before selecting New, consider selecting the check box for "Prompt a profile to be used."If this is enabled, you will get a prompt every time you start Outlook to pick which profile you want to open. This is helpful when you have multiple profiles and need to switch between them.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Change or reset Internet Explorer settings - Microsoft Support
Change Internet Explorer settings. There are many changes you can make to customize your browsing experience in Internet Explorer. To view all settings and options, open Internet Explorer on the desktop, select Tools > Internet options.. Reset Internet Explorer settings
Securely browse the web in Microsoft Edge - Microsoft Support
With online threats getting more advanced day by day, it is important to prioritize the safety of your web browsing. Microsoft Edge offers several features and practices that can enhance your online security and protect your personal information.
What to try if your touchscreen doesn't work - Microsoft Support
In Settings, select Update & Security , then Windows Update , and then select the Check for updates button. Install any available updates and restart your PC if required.