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
Unlink a device in the Phone Link - Microsoft Support
To successfully remove a device, follow the steps below. You'll need to complete all steps for both your Android device and your PC in order to successfully unlink your device.
Firewall & network protection in Windows Security - Microsoft Support
Advanced settings - This will open the classic Windows Defender Firewall tool which lets you create inbound or outbound rules, connection security rules, and see monitoring logs for the firewall. Most people won't want to dig into it that deeply; adding, changing, or deleting rules incorrectly can cause your system to be more vulnerable or can cause some apps not to work.
Turn on device encryption - Microsoft Support
In the search box on the taskbar, type Manage BitLocker and then select it from the list of results. Or, select the Start button, and then under Windows System, select Control Panel.In Control Panel, select System and Security, and then under BitLocker Drive Encryption, select Manage BitLocker. Note: You'll only see this option if BitLocker is available for your device.
Recall or replace a sent email - Microsoft Support
Note: If you selected Delete unread copies and replace with a new message, the original message opens for editing.When you select Send, the original email message will be deleted from the recipient’s mailbox and replaced with the newly edited one.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016
Fix microphone problems - Microsoft Support
If you want to give access to desktop apps, make sure that Let desktop apps access your microphone is turned on.You can't turn off microphone access for individual apps. Others can't hear me. Try the following solutions:
Upgrade to Windows 10: FAQ - Microsoft Support
An upgrade moves your PC from a previous version of Windows—such as Windows 7 or Windows 8.1—to Windows 10. An upgrade can take place on your existing device, though Microsoft recommends using Windows 10 on a new PC to take advantage of the latest features and security improvements.
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
Check your device performance and health in Windows Security
The Health report starts off by showing you the last time a Device Health scan was run. The time displayed should be basically the current time, as Windows Security tries to run a Device Health scan when you open the Device performance & health page.. Beyond the time of last scan you'll see the status of the key areas that Device Health monitors:
Find and lock a lost Windows device - Microsoft Support
Turn on Find my device. When you set up a new device, you can decide whether to turn on or turn off the Find my device setting. If you turned it off during setup and now want to turn it on, make sure your Windows device is connected to the internet, has enough battery power so it can send its location, and that you're signed in to the device using your Microsoft account.
Applies To: Microsoft account dashboard