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
Create and use modern pages on a SharePoint site
Learn how to add a page to a SharePoint Online site. Add web parts. Web parts are the building blocks of your page. For more information on the different types of web parts and how to use them, check out Using web parts on pages.. If you have the content pane enabled:
Applies To:
SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Microsoft 365 admin, SharePoint operated by 21Vianet
Set up your Microsoft 365 sign-in for multi-factor authentication
By setting up MFA, you add an extra layer of security to your Microsoft 365 account sign-in. For example, you first enter your password and, when prompted, you also type a dynamically generated verification code provided by an authenticator app or sent to your phone.
Applies To:
Office for business, Microsoft 365 admin
About Microsoft Authenticator - Microsoft Support
Microsoft Authenticator is a free app that helps you sign in to all your accounts without using a password - just use a fingerprint, face recognition, or a PIN.
Applies To:
Microsoft account dashboard
Installieren eines Druckers unter Windows - Microsoft-Support
Wenn der Drucker eingeschaltet und mit dem Netzwerk verbunden ist, sollte er von Windows leicht gefunden werden. Die verfügbaren Drucker können alle Drucker in einem Netzwerk umfassen, z. B. Bluetooth- und WLAN-Drucker oder Drucker, die an einen anderen Computer angeschlossen und im Netzwerk freigegeben sind.
Create a new folder - Microsoft Support
For Windows 8 or Windows 8.1, swipe in from the right edge of the screen, and tap Search. If you're using a mouse, point to the upper-right corner of the screen, move the mouse pointer down, and click Search.Type File Explorer in the search box, and then tap or click File Explorer.
Use the Tasks app in Teams - Microsoft Support
List view. A unique feature of the Tasks app how it displays tasks and information associated with them in rows and columns. This is called List view, and allows you to change many tasks at once, which wasn't as possible in either To Do or Planner before.
Applies To:
Microsoft Planner, Microsoft Teams, Microsoft To Do
Dictate your documents in Word - Microsoft Support
Dictation lets you use speech-to-text to author content in Microsoft 365 with a microphone and reliable internet connection. It's a quick and easy way to get your thoughts out, create drafts or outlines, and capture notes.
Applies To:
Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Eingabeort für den Office-Product Key - Microsoft-Support
Schritt 1: Wechseln Sie zu www.microsoftstore.com, und melden Sie sich (oben rechts) mit dem Microsoft-Konto an, das Sie für den Kauf von Office verwendet haben.. Schritt 2: Nachdem Sie sich angemeldet haben, wählen Sie oben rechts Ihren Namen und dann Bestellverlauf aus.. Schritt 3: Suchen Sie den Einmalkauf von Office oder der einzelnen Office-App, und wählen Sie dann Office installieren ...
Applies To:
Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Office 2016, Microsoft 365 for home, Office.com
Troubleshoot problems signing in to Windows - Microsoft Support
If you continue to experience issues signing in with your original profile, disable Windows Defender services: Open the Services app by typing services in the search box on the task bar and selecting it from the list of results. Then, find the Windows Defender Advanced Threat Protection and Microsoft Defender Antivirus services, right-click each of them, select Properties , and change Startup ...