XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a 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
Change the refresh rate on your monitor in Windows
Battery Life: Lowering your refresh rate can save battery power by reducing the amount of energy your display consumes.This can be useful when you are using a laptop or tablet and want to extend your battery life.
Learn about Microsoft Rewards - Microsoft Support
In order to obtain the details of your reward, please go to your Order History and scan through the list of your orders. Look for the reward in question and at the far-right, click the Order Details button to get your redemption code or link.
Applies To: Microsoft account dashboard
Xbox subscription cancellations and refunds | Xbox Support
In the following countries, you have the right to cancel a subscription that has recurring billing with immediate effect and receive a prorated refund as described in the Microsoft Consumer Subscription Prorated Refund Policy:
Make a checklist in Word - Microsoft Support
Add an interactive checklist. Checklist is a feature that allows you to insert an interactive list in Word for Web. You can check and uncheck the checklist and keep track of the tasks that you are performing.
Applies To: Word for Microsoft 365, Word for the web, Word 2021, Word 2019, Word 2016
如何登入 Hotmail - Microsoft Support
提示: 登入時,如果您下次想要直接移至信箱,請在 [保持登入?] 提示中選取 [是] (不建議用於共用電腦)。 或者,選取 [不要再顯示這個] 方塊,然後選取 [否],這樣每次都會提示您輸入密碼。. 如果您無法登入或忘記您的使用者名稱或密碼,請使用我們的 [登入疑難排解員]。
Applies To: Outlook.com
SUMIFS function - Microsoft Support
Problem. Description. 0 (Zero) is shown instead of the expected result. Make sure Criteria1,2 are in quotation marks if you are testing for text values, like a person's name.. The result is incorrect when Sum_range has TRUE or FALSE values.. TRUE and FALSE values for Sum_range are evaluated differently, which may cause unexpected results when they're added. ...
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 2019 for Mac, Excel 2016, Excel Web App
Find your notifications - Microsoft Support
Windows 10 puts notifications and quick actions in Action Center—right on the taskbar—where you can get to them instantly. Select Action Center on the taskbar to open it. (You can also swipe in from the right edge of your screen, or press Windows logo key + A.). Notifications at a glance
Ändern des Desktophintergrundbilds - Microsoft-Support
Hinweis: Wenn Sie die Option Windows Spotlight nicht auswählen können, hat Ihr Administrator das Feature möglicherweise deaktiviert, oder Sie haben das Update noch nicht erhalten. Dieses Feature wird über einen bestimmten Zeitraum eingeführt. Weitere Informationen finden Sie unter Wann erhalte ich die neuesten Features für Microsoft 365?.
Getting the most out of your PC backup - Microsoft Support
When you back up your files, apps, and settings in the cloud using your Microsoft account, you get 5 GB of free cloud storage and other benefits that protect your files with the latest security and make everyday tasks easier.