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
Office cheat sheets - Microsoft Support
Get up to speed with Microsoft Office by using these cheat sheets for quick reference and mastering keyboard shortcuts.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 for home, Office for business, Office 365 Small Business
Stay protected with Windows Security - Microsoft Support
Tip: If you're a Microsoft 365 Family or Personal subscriber you get Microsoft Defender, our advanced security software for Windows, Mac, iOS, and Android, as part of your subscription.Learn more at Getting started with Microsoft Defender.
Microsoft Teams (free) - Microsoft Support
Get started with Microsoft Teams (free). Explore your options, find out what’s new, browse help topics, and more.
Applies To: Microsoft Teams, Microsoft Teams personal, Microsoft Teams small business
Change notification and quick settings in Windows
In Windows 10, action center is where you'll find your app notifications and quick actions—which give you quick access to commonly used settings and apps.
Zip and unzip files - Microsoft Support
Press and hold (or right-click) the file or folder, select (or point to) Send to, and then select Compressed (zipped) folder. A new zipped folder with the same name is created in the same location.
Microsoft 365 help & learning
Get Microsoft 365 support, help, and learning resources. Organize your life, expand your creativity, and protect what’s important with Microsoft 365
Applies To: Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Office 2016, Microsoft 365 for home, Microsoft 365 for Mac, Microsoft 365 for Windows
Create and print a single envelope - Microsoft Support
Click the Printing Options tab.. The printer driver tells Word which way the envelope should be loaded into the printer, and this information is displayed in the Printing Options tab of the Envelope Options dialog box.. 1. The feed method determines the position of the envelope (right, middle, left) and whether the long or short edge is being fed into the printer.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016, Word 2013
Uninstall Office for Mac - Microsoft Support
Ctrl+click the application you selected and click Move to Trash.
Applies To: Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac, OneNote 2021 for Mac, Office 2021 for Mac, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, OneNote 2019 for Mac, Office 2019 for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Microsoft 365 for Mac
Create a bibliography, citations, and references - Microsoft Support
Create a bibliography using built-in common citation formats like APA, MLA, or Chicago.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016