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
How to use two-step verification with your Microsoft account
Important: If you turn on two-step verification, you will always need two forms of identification.This means that if you forget your password, you need two contact methods. Or if you lose your contact method, your password alone won't get you back into your account—and it can take you 30 days to regain access.
Surface Recovery Image Download - Microsoft Support
Learn how to download a recovery image for your Surface device and restore it to factory settings.
Change colors in Windows - Microsoft Support
You can personalize the color or accent color for window title bars and borders, the Start button, or the taskbar. The Dark mode has colors that are designed to work well in a low-lit environment. This option is for the Start menu, taskbar, and action center.
Check or change language settings - Microsoft Support
Microsoft's products and services work best if you use the same language and region across all your devices, and in all of your app and Store settings.
Applies To: Outlook.com, Microsoft Edge, OneDrive (home or personal)
Get started with the Outlook Calendar - Microsoft Support
Note: If you want to let someone know about a meeting, but not invite them, simply drag the meeting request from your calendar to the Mail icon on the lower left side of Outlook. This opens an email with information about the meeting that you can send out. Note that this email doesn't add the recipient(s) to the meeting, and it only contains meeting information such as date, time, subject, and ...
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Как найти ключ продукта Windows - Служба поддержки Майкрософт
Если вы приобрели Windows 10 или Windows 11 Pro обновление в приложении Microsoft Store, вы получите цифровую лицензию вместо ключа продукта в письме с подтверждением, отправленном для подтверждения покупки.
Applies To: Microsoft account dashboard
July 9, 2024—KB5040442 (OS Builds 22621.3880 and 22631.3880)
Windows 11, version 21H2; July 9, 2024—KB5040431 (OS Build 22000.3079) June 11, 2024—KB5039213 (OS Build 22000.3019) May 14, 2024—KB5037770 (OS Build 22000.2960)
New Office theme - Microsoft Support
Default Office theme colors. The color palette of the Office theme prioritizes the creation of modern and accessible content. The previous Office theme has been renamed Office Theme 2013–2022 and can still be accessed in the theme galleries of each Office application.. Change a theme and make it the default in Word or Excel
Troubleshoot Outlook email setup - Microsoft Support
If you try to add an IMAP account to Outlook, for example a Gmail account, Apple account, Yahoo account, or an account from your local ISP, and you're not prompted to enter your password, use the following steps to work around the problem.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin