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
Sign in to SharePoint - Microsoft Support
In the upper left corner of the window, select the app launcher > All apps > SharePoint Tip: If you don't see the SharePoint app under All apps, use the Search box near the top of the window to search for SharePoint.
Applies To: SharePoint in Microsoft 365
Free up drive space in Windows - Microsoft Support
Note: If it’s been fewer than 10 days since you upgraded to Windows 10, your previous version of Windows will be listed as a system file you can delete.If you need to free up drive space, you can delete it, but keep in mind that you'll be deleting your Windows.old folder, which contains files that give you the option to go back to your previous version of Windows.
COUNTIF function - Microsoft Support
Argument name. Description. range (required). The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to select ranges in a worksheet.. criteria (required). A number, expression, cell reference, or text string that determines which cells will be counted.
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
Create films with a video editor - Microsoft Support
For fast and simple editing, we've added Clipchamp as the official Microsoft video editor. Microsoft Clipchamp comes preinstalled on Windows 11 devices. To open Clipchamp, go to the search box on the taskbar, type Clipchamp, and select it from the results.Or you can select Start , then select All apps and scroll down to find Clipchamp in the list of apps.
使用 VLOOKUP、INDEX 或 MATCH 查找值 - Microsoft 支持
使用 vlookup、hlookup 和其他函数(如 index 和 match)根据您输入的值搜索和查找数据。 本文将让您快速回顾 vlookup,然后链接到更多内容。
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Excel functions (by category) - Microsoft Support
Function. Description. CUBEKPIMEMBER function. Returns a key performance indicator (KPI) property and displays the KPI name in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, that is used to monitor an organization's performance.
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
Block or allow (junk email settings) - Microsoft Support
Safe senders and recipients. Safe senders are people and domains you always want to receive email messages from. Safe recipients are recipients that you don't want to block, usually groups that you’re a member of.
Applies To: Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
Create a PivotTable to analyze worksheet data - Microsoft Support
Get from External Data Source. Get from Data Model. Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.. Get from Power BI. Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have ...
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
Xbox Cloud Gaming in Microsoft Edge with Steam Deck
Update RECENT GAMES: Once you have used the shortcut and launched Xbox Cloud Gaming (Beta) at least once, it will appear in the RECENT GAMES section (again, within the desktop Steam client) with a blank background.Just as before, right-click, select Manage > Set custom artwork, navigate to your artwork and select Xbox_Cloud_Gaming_Capsule.jpg.
Applies To: Microsoft Edge