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.

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 ...

Notes: If you don't see Go to Microsoft Store on the Activation page, contact your organization's support person.. If you made a substantial hardware changes to your device (such as replacing the motherboard) and you have a valid product key, try to activate Windows by phone.

Note: If your data is in an Excel table, the Transpose feature isn't available.You can convert the table to a range first, or you can use the TRANSPOSE function to rotate the rows and columns.

如果在设置中打开用与首选语言不同的语言编写的页面，Microsoft Edge会自动提示你翻译它。 转到用外语编写的网页时，“翻译”图标 显示在地址栏中。 如果语言未包含在设置中的首选语言列表中，则该语言被视为外在语言。

Check the Xbox services, games, and apps for any service outages.

Virtualization lets your PC emulate a different operating system, like Android™ or Linux. Enabling virtualization gives you access to a larger library of apps to use and install on your PC.

Click a template to see a preview. Click the arrows on the side of the preview to see more templates.

还可以转到电子邮件通知中的"浏览组"部分，查看对话以及组的日历和文件。 你创建的或受邀加入的所有组位于左侧导航栏的“组”下。单击组名称即可访问任何组。

Advanced settings - This will open the classic Windows Defender Firewall tool which lets you create inbound or outbound rules, connection security rules, and see monitoring logs for the firewall. Most people won't want to dig into it that deeply; adding, changing, or deleting rules incorrectly can cause your system to be more vulnerable or can cause some apps not to work.