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.

You can use data from a Excel worksheet as the basis for a PivotTable or PivotChart. The data should be in list format, with column labels in the first row, which Excel will use for Field Names.Each cell in subsequent rows should contain data appropriate to its column heading, and you shouldn't mix data types in the same column.

Features with audio and video functionality.. Many features that come as part of Windows can be used to view or play video or audio content. Here are some examples: OneNote app (lets people record or play audio), Microsoft Edge web browser (lets people play audio and video content on the internet), the Photos app, the OneDrive app, and others.

Windows Photo Viewer isn't part of Windows 10, but if you upgraded from Windows 7 or Windows 8.1, you might still have it. To check, press and hold (or right-click) a photo in File Explorer, and select Open with.If Windows Photo Viewer isn't in the list, you cannot install it on Windows 10.

Updates to the default screen and sleep settings now help you use energy more efficiently and extend battery life. You can find efficiency settings in Windows 11 at Settings > System > Power & battery.. For a guided walkthrough of how each of the power and battery settings can improve your device's performance, click the button to open the Get Help app:

Test your camera with the Camera app. Select Start , then choose Camera from your apps. If you're asked to allow access to the Camera, select Yes.If the camera works in the Camera app, the problem might be with the app you're trying to use.

Learn how to remove malware from your PC. Use Microsoft Defender Antivirus in Windows 10 or Windows 11 to scan your PC for malware, viruses, or other threats.

Tip: If you installed the Microsoft 365 apps as part of a suite, such as Office Home and Student or Microsoft 365, search for the suite name.For stand-alone apps search by the app name, such as Project or Visio. In most cases you can't uninstall an individual app if it's included in your Microsoft 365 suite.

注意: 使用安装介质重新安装Windows 11，同时选择“不保留任何内容” (干净安装) ，如果重新安装 Windows 的分区为 20GB 或更大，则将自动启用保留存储。 保留存储空间将留出磁盘空间以供更新、应用、临时文件和系统缓存使用，因此可确保关键的操作系统功能始终可以访问磁盘空间，从而改进了电脑 ...

Notes: If you don't see an option to Cancel, but instead see a link that says Turn on recurring billing, this means your subscription is already set to expire on the date shown and you won't be automatically charged after this date. There's nothing further to do at this time, and you can continue to use the product until your Microsoft 365 subscription expires.