Convert numbers stored as text to numbers - Microsoft Support
Most of the time, Excel will recognize this, and you'll see an alert next to the cell where numbers are being stored as text. If you see the alert:
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, Excel Web App
在 Windows 中查找 BitLocker 恢复密钥 - Microsoft 支持
个人设备的所有者或管理员激活了 BitLocker (在某些设备上也称为设备加密,) 通过“设置”应用或控制面板: 在这种情况下,激活 BitLocker 的用户选择了保存密钥的位置,或者在设备加密的情况下选择 (,) 自动将密钥保存到其 Microsoft 帐户。
Microsoft 365 Training
Get productive quickly with Microsoft 365 videos and tutorials. Explore Microsoft 365 training guides and tips to collaborate with anyone, anywhere.
Filter data in a range or table - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016
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
Create and use modern pages on a SharePoint site
Learn how to add a page to a SharePoint Online site. Add web parts. Web parts are the building blocks of your page. For more information on the different types of web parts and how to use them, check out Using web parts on pages.. If you have the content pane enabled:
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Microsoft 365 admin, SharePoint operated by 21Vianet
Use the News web part on a SharePoint page - Microsoft Support
News sources. When you are working with a News web part, you can specify the source for your news posts. Your news posts can come from the site you are on while using the web part (This site), a hub site that the current site is part of (All sites in the hub), or one or more individual sites (Select sites).Another option is to choose Recommended for current user, which will display posts for ...
Applies To: SharePoint in Microsoft 365, Microsoft 365 admin, SharePoint admin center, SharePoint operated by 21Vianet
Change privacy settings in Windows - Microsoft Support
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Getting the most out of your PC backup - Microsoft Support
When you back up your files, apps, and settings in the cloud using your Microsoft account, you get 5 GB of free cloud storage and other benefits that protect your files with the latest security and make everyday tasks easier.
Create, load, or edit a query in Excel (Power Query) - Microsoft Support
A Data Model typically contains several tables arranged in a relationship. You load a query to a Data Model by using the Load To command to display the Import Data dialog box, and then selecting the Add this data to the Data Model check box.For more information about Data Models, see Find out which data sources are used in a workbook data model, Create a Data Model in Excel, and Use multiple ...
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016