XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Microsoft 365 Training
Get productive quickly with Microsoft 365 videos and tutorials. Explore Microsoft 365 training guides and tips to collaborate with anyone, anywhere.
Add or manage an iCloud email account in Outlook
If prompted, enter your password. However, if you have two-factor authentication set up, you might see a window asking you to Create an app-specific password.To obtain an app-password, do the following:
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
FILTER function - Microsoft Support
The FILTER function allows you to filter a range of data based on criteria you define.
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
Get help with Outlook.com - Microsoft Support
Get more out of your email with Outlook.com. We've streamlined search to make it easier than ever to find what you're looking for. New features like Files and attachment previews let you see your pictures and files without leaving your inbox.
Applies To:
Outlook.com
Change your screen saver settings - Microsoft Support
Select the Start button, then go to Settings > Personalization > Lock screen, and select Screen saver settings.In the Screen Saver Settings window, choose a screen saver from the drop-down list. Change your screen saver settings
Download and install custom fonts to use with Office
Learn how to locate, install, and share files with custom fonts compatible with Microsoft Office applications.
Applies To:
Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Office 2016
Choose between the 64-bit or 32-bit version of Office
You're using add-ins with Outlook, Excel, or other Office apps. While 32-bit applications can work with add-ins, they can use up a system's available virtual address space. With 64-bit apps, you have up to 128 TB of virtual address space which the app and any add-ins running the same process can share. With 32-bit apps, you might get as little ...
Applies To:
Office 2021, Office 2019, Office 2016, 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, Office 365 operated by 21Vianet - Admin, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
Ändern der Browser-Startseite - Microsoft-Support
Geben Sie auf der Registerkarte Allgemein unter Startseite die URL der Website ein, die Sie als Startseite festlegen möchten. Sie können mehrere URLs hinzufügen. Für die aktuell angezeigte Website wählen Sie Aktuelle verwenden.Wenn Sie mehr als eine URL verwenden, fügen Sie jede URL in eine eigene Zeile ein.
Outlook help & learning
Get help with Outlook for Windows, the Outlook app, Outlook.com, and more. Find training videos, how-to articles, and Outlook support content