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
Present your data in a Gantt chart in Excel - Microsoft Support
Need to show status for a simple project schedule with a Gantt chart? Though Excel doesn’t have a predefined Gantt chart type, you can simulate one by customizing a stacked bar chart to show the start and finish dates of tasks, like this:
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Align text left or right, center text, or justify text on a page
The term "alignment" generally specifies the appearance and orientation of the edges of a paragraph -- left-aligned text, right-aligned text, centered text, or "justified" text (aligned evenly from left to right margins).
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
Introduction to Outlook Data Files (.pst and .ost)
Note: In earlier versions of Outlook, IMAP accounts also used an Outlook Data File (.pst).In Outlook 2016 and Outlook for Microsoft 365, IMAP accounts use Offline Outlook Data Files (.ost). You can also use an Outlook Data File (.pst) to backup or export items from any type of email account.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
About Windows backup and sync settings - Microsoft Support
To find Sync settings, select Start , then select Settings > Accounts > Sync your settings . Choose from settings such as language preferences, passwords, and color themes. If you turn on Other Windows settings, Windows also syncs some device settings (for things like printers and mouse options), File Explorer settings, and notification preferences.
Applies To: Microsoft account dashboard
Using your keyboard - Microsoft Support
The following illustration shows how these keys are arranged on a typical keyboard. Your keyboard layout might be different. Typing text. Whenever you need to type something in a program, e‑mail message, or text box, you'll see a blinking vertical line ( ) called the cursor or insertion point.It shows where the text that you type will begin.
Ändern oder Zurücksetzen des Kennworts - Microsoft-Support
Wenn Sie das Kennwort ändern oder zurücksetzen möchten, das Sie für die Anmeldung bei Windows verwenden, haben Sie verschiedene Optionen. In diesem Artikel werden die verschiedenen Ansätze beschrieben, die Sie verfolgen können, unabhängig davon, ob Sie ein Microsoft-Konto oder ein lokales Konto verwenden, angemeldet sind oder auf dem Anmeldebildschirm angezeigt werden.
Getting started with Microsoft Family Safety - Microsoft Support
A family group is a set of individuals connected through the Microsoft Family Safety app on their Windows, Xbox, or mobile devices. Establishing a family group is an easy, effective way to encourage healthy online habits and manage busy schedules.
Applies To: Microsoft Family Safety
Change or set the default font in Outlook - Microsoft Support
Replying or forwarding messages - You can have a different font on messages you're forwarding or replying to. This setting is mostly for the two check boxes that let you mark your comments with your name (or other text) or with a different color of text.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Create and save a PowerPoint template - Microsoft Support
On the View tab, in the Master Views group, choose Slide Master.. The slide master is the largest slide image at the top of the slide thumbnail list, to the left of your slides. Associated slide layouts are positioned beneath the slide master.
Applies To: PowerPoint for Microsoft 365, PowerPoint for the web, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016