Find your Windows product key - Microsoft Support
Locate your product key for Windows 10 or Windows 11. Depending on how you got your copy of Windows 10 or Windows 11, you'll need either a 25-character product key or a digital license to activate it.
Applies To:
Microsoft account dashboard
Windows Update Troubleshooter - Microsoft Support
If you get an error code while downloading and installing Windows updates, the Update Troubleshooter can help resolve the problem. Select Start > Settings > System > Troubleshoot > Other troubleshooters. Next, under Most frequent, select Windows Update > Run.
Recovery options in Windows - Microsoft Support
Learn about the recovery options in Windows. Find out how to reset your PC, go back to a previous version of Windows, or use media to reinstall Windows.
Track your PC’s performance with Game Bar | Xbox Support
Use the Performance widget to easily monitor your PC’s performance while you’re gaming. This lets you know in real time whether your system has enough resources for game-intensive moments or if something might be affecting it. Collapse all.
Using product keys with Office - Microsoft Support
If you paid for an Office product to be included on your new Windows PC, a digital product key is transmitted to your PC when you activate Windows. You won't receive a printed product key. Instead, you'll see a message similar to the following when you start Word (or any Office app).
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Microsoft 365 for home, InfoPath 2013
使用 VLOOKUP、INDEX 或 MATCH 查找值 - Microsoft 支持
其实用查找函数很容易做到。. VLOOKUP 和 HLOOKUP 函数，以及 INDEX 和 MATCH 是 Excel 中一些最有用的函数。. 注意: Excel 中不再提供“查找向导”功能。. 下面是如何使用 VLOOKUP 的示例。. =VLOOKUP (B2,C2:E7,3,TRUE) 在此示例中，B2 是第一个 参数 ，即函数运行所需的数据元素 ...
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
在工作表中对数值进行计数的方法 - Microsoft 支持
使用 SUBTOTAL 函数对 Excel 表格或单元格区域中的值数进行计数。. 如果表或区域包含隐藏的单元格，则可以使用 SUBTOTAL 来包含或排除这些隐藏单元格，这是 SUM 和 SUBTOTAL 函数之间的最大区别。. SUBTOTAL 语法如下所示：. SUBTOTAL (function_num,ref1, [ref2],...) 若要在范围中 ...
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
计算大于或小于某个数的数字数量 - Microsoft 支持
使用 COUNTIF 对满足特定条件的单元格数进行计数。. 例如，您正在准备报表，并且想要计算大于或小于特定值的销售发票数。. 使用 COUNTIF 函数对大于或小于数字的数字进行计数。. 单元格 A11 和 A12 具有公式，其中 COUNTIF 检查 B2：B7 范围内的发票值数小于 20000 且 ...
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
如何登录 Outlook 网页版 - Microsoft 支持
使用工作或学校帐户登录到Outlook 网页版. 转到 outlook.office.com 。. 如果未使用工作或学校帐户自动登录，请按照提示输入工作或学校帐户的电子邮件地址和密码。. 按照之前可能已为此帐户设置的任何双重身份验证提示进行操作。. 选择“ 登录 ”。. (如果已登录 ...
Applies To:
Office for business, Office 365 Small Business, Outlook on the web, Outlook on the web for Exchange Server 2016
筛选区域或表中的数据 - Microsoft 支持
筛选区域或表中的数据. 使用自动筛选或内置比较运算符（如 Excel 中的“大于”和“前 10 个”）显示所需数据并隐藏其余数据。. 筛选单元格或表格区域中的数据后，可以重新应用筛选器以获取最新结果，或者清除筛选器以重新显示所有数据。. Windows Web macOS ...
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016