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
Change your profile picture in Microsoft Teams
Select your profile picture at the top right of Teams. When your account manager opens, select your profile picture again.
Applies To: Microsoft Teams
Windows Media Player - Microsoft Support
Learn how to download, customize, and troubleshoot Windows Media Player 12 with helpful guides and tips.
Create professional slide layouts with Designer - Microsoft Support
This is a subscriber-only, Microsoft 365 feature. Find your version. Design ideas for one photo Applies to: PowerPoint for Microsoft 365 Current Channel: Version 1511 or later Semi-Annual Enterprise Channel: Version 1602 or later Multiple photos, color extraction, and facial recognition
Applies To: PowerPoint for Microsoft 365, PowerPoint for Microsoft 365 for Mac, PowerPoint for the web, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016, PowerPoint for iPad, PowerPoint for Android tablets, PowerPoint Mobile
Use your Windows PC as a mobile hotspot - Microsoft Support
Turn your Windows PC into a mobile hotspot by sharing your internet connection with other devices over Wi-Fi. You can share a Wi-Fi, Ethernet, or cellular data connection.
View your PC info - Microsoft Support
Learn how to view your PC information on Windows with Microsoft Support's step-by-step guide.
Switch from working offline to online - Microsoft Support
In Outlook, you have the flexibility to make Outlook work online or offline with your mail server. Select a tab option below for the version of Outlook you're using.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
Share your Microsoft 365 Family subscription - Microsoft Support
Manage invitations to share Microsoft 365. On the Microsoft account, Sharing page, under the section Other people, you can view and manage invitations you’ve created.You can check the status of an invitation, resend, or delete invitations. If the person you sent an invitation to can't find it, see Can't find an invitation to share Microsoft 365 Family.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Microsoft 365 for home, Office for business, Microsoft account dashboard
Customize the Outlook window - Microsoft Support
Customize the reading pane. The reading pane, sometimes called the preview pane, lets you read items without opening them. You can customize the reading pane according to your preferences.
Applies To: Outlook for Mac 2011
Focused Inbox for Outlook - Microsoft Support
To move a message from Focused to Other: Select Move > Move to Other inbox.Select Always move to Other inbox if you want all future messages from the sender to be delivered to the Other tab.. To move a single message from Other to Focused: Select Move > Move to Focused inbox.Select Always move to Focused inbox if you want all future messages from the sender to be delivered to the Focused tab.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, Outlook.com, New Outlook for Windows, Outlook on the web for Exchange Server 2016