使用 VLOOKUP、INDEX 或 MATCH 查找值 - Microsoft 支持
下面是如何使用 VLOOKUP 的示例。 =VLOOKUP(B2,C2:E7,3,TRUE) 在此示例中,B2 是第一个 参数,即函数运行所需的数据元素。VLOOKUP 第一个参数是要查找的值。 此参数可以是单元格引用,也可以是固定值,例如“smith”或 21,000。
适用于: Microsoft 365 专属 Excel, Excel 网页版, Excel 2024, Excel 2021, Excel 2019, Excel 2016
安装 Windows 11 的方法 - Microsoft 支持
开始之前 确保要安装 Windows 11 的设备满足最低系统要求。如果设备当前正在运行 Windows 10,建议使用电脑健康状况检查应用验证最低系统要求。 我们不建议在不符合要求的设备上安装 Windows 11。 有关详细信息,请参阅在不符合最低系统要求的电脑上安装 Windows 11。
Change your default search engine in Microsoft Edge
Keeping Bing as your default search engine provides an enhanced search experience in the new Microsoft Edge , including direct links to Windows apps, relevant suggestions from your organization if you’re signed in with a work or school account, and instant answers to questions about Windows.However, you can change the default search engine to any site that uses OpenSearch technology.
更改或重置密码 - Microsoft 支持
重要: Microsoft帐户、Windows 操作系统和其他Microsoft产品包括密码,以帮助保护你的信息。本文提供了一些选项,可用于在忘记密码时重置或恢复密码。 请注意,如果这些选项不起作用, Microsoft支持无法帮助你检索或绕过丢失或忘记的密码。
Troubleshoot problems updating Windows - Microsoft Support
Important: Before trying any of the solutions below, make sure you back up your personal files. You can back up your Windows PC, or insert a USB drive and use File Explorer to drag and copy important files to the USB drive.If you’re signing into Windows with a Microsoft account, your system settings will be automatically restored after updating, once you’re connected to the internet.
File sharing over a network in Windows - Microsoft Support
Learn about file sharing over a network in Windows. Note: This article focuses on how to share files or folders over a Local Area Network (or LAN), such as connected computers within your home or workplace.If you are trying to find out how to share a file over the Internet, for example with a friend or family member, OneDrive provides easy ways to accomplish this.
下载并安装或重新安装 Office 2019、Office 2016 或 Office 2013
注意: 如果是通过以下任一方式获取的 Microsoft 365:Microsoft 工作区折扣计划(以前称为家用许可计划),则安装 2019、2016 或 2013 版的 Office 专业增强版、Office 标准版或独立应用(如 Word 或 Project)的步骤可能会有所不同:如果你通过公司购买了 Microsoft 365 供个人使用,请参阅通过工作场所折扣计划安装 ...
适用于: Office 2019, Office 2016, Office 2016 for Mac, Office 2013
查找 BitLocker 恢复密钥 - Microsoft 支持
如果找不到恢复密钥,该怎么办? 如果设备由组织管理,请与 IT 部门联系以检索恢复密钥。 如果找不到 BitLocker 恢复密钥,并且无法撤消导致需要它的任何更改,则必须使用 Windows 恢复选项之一重置设备。 重置你的设备将删除所有文件。
Update Windows - Microsoft Support
Learn how to update Windows to ensure your device operates smoothly and securely with the latest features.
Block pop-ups in Microsoft Edge - Microsoft Support
The Microsoft Edge feature that blocks pop-ups is effective in preventing websites from automatically opening a new window or tab, or a partial window on top of your current web page. This feature is turned on by default. There are many different types of pop-ups, including advertisements, notices, offers, or alerts that can appear at various times on any web page. Some can be helpful, such as ...
适用于: Microsoft 帐户仪表板