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.

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.

To zip (compress) files. In the search box on the taskbar, type file explorer, and then select it from the list of results.Right-click the file you want to zip, and then select Send to > Compressed (zipped) folder.. To decompress files. Open File Explorer and find the compressed folder.

Inserting ASCII characters. To insert an ASCII character, press and hold down ALT while typing the character code. For example, to insert the degree (º) symbol, press and hold down ALT while typing 0176 on the numeric keypad.

Make sure User Account Control (UAC) is turned on - When changes are going to be made to your PC that require administrator-level permission, UAC notifies you and gives you the chance to approve the change.UAC can help keep viruses from making unwanted changes. To open UAC, swipe in from the right edge of the screen, and then tap Search. (If you're using a mouse, point to the upper-right ...

There are several ways to reduce your mailbox size. You can use the Mailbox Cleanup tool to view the size of your mailbox and individual folders. This tool can also help you search for older or very large messages that you might want to delete or move to an Outlook Data File (.pst).

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:

Training: Sign in to office.com with your Microsoft personal, work, or school account. Watch this video to learn how.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Learn how to log in to Microsoft Teams with your Microsoft 365 account. This step-by-step guide from Microsoft Support walks you through the process of accessing Teams on desktop, web, and mobile devices.