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
Remove specific prevalent malware with Windows Malicious Software ...
Microsoft generally releases the MSRT on a monthly cadence as part of Windows Update or as a standalone tool. (For exceptions, see Skipped releases.)Use this tool to find and remove specific prevalent threats and reverse the changes that they made (see Covered malware families).For comprehensive malware detection and removal, consider using Windows Defender Offline or Microsoft Safety Scanner.
Create and add an email signature in Outlook - Microsoft Support
Under Choose default signature, set the following options.. In the E-mail account drop-down box, choose an email account to associate with the signature. You can have different signatures for each email account. You can have a signature automatically added to all new messages. Go to in the New messages drop-down box and select one of your signatures. If you don't want to automatically add a ...
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business, Office 365 Small Business, Microsoft 365 admin, Outlook on the web, Outlook.com, New Outlook for Windows, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
Server settings you'll need from your email provider
Setting. Description. Write Your Setting Here. Example. Host Name. Your incoming mail server name. outlook.office365.com. Username. The email address you want to set up.
Applies To:
Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Outlook.com, Office 365 operated by 21Vianet - Admin, New Outlook for Windows, Outlook for iOS, Outlook for Windows Phone 10, Outlook Mail for Windows 10, Outlook on the web for Exchange Server 2016
Language packs for Windows - Microsoft Support
The easiest way to get language packs for Windows 8.1 and Windows RT is to download and install them using the Language Control Panel. Download and install additional languages to view menus, dialog boxes, and other user interface items in your preferred language.
Schedule an out of office status in Microsoft Teams
To clear your out of office status and turn off your automatic reply in Teams, return to the Out of Office screen, click the toggle next to Turn on automatic replies and select the Save button. Once you've scheduled an out of office status and message in Teams, you'll see automatic replies turned on in Outlook with the time range and message you set in Teams.
Applies To:
Microsoft Teams
Freeze panes to lock rows and columns - Microsoft Support
To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
How to use multiple monitors in Windows - Microsoft Support
Tip: If you're using a wireless display adapter, connect to an HDMI port on newer TVs, then wirelessly connect your PC to it.After connecting your wireless display adapter to your TV, go to your Windows 11 PC, press Windows logo key + K to open Cast, then select your wireless display adapter.
Help in File Explorer - Microsoft Support
To open File Explorer, select Windows logo key + E or go to Start and type File Explorer in the search box. Select File Explorer in the results.. Top topics. Here are answers to a few common questions about File Explorer: How can I open File Explorer and find the Windows 11 features?
Fix network connection issues in Windows - Microsoft Support
Try these things to troubleshoot network connection issues in Windows 11. Make sure Wi-Fi is on. Select Start > Settings > Network & internet, then turn on Wi-Fi.Next, select More options (>) next to Wi-Fi, then select Show available networks.If a network you expect to see appears in the list, select it, then select Connect. Open Wi-Fi settings