Overview of formulas in Excel - Microsoft Support
Download our Formulas tutorial workbook. We've put together a Get started with Formulas workbook that you can download. If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
COUNTIF function - Microsoft Support
Argument name. Description. range (required). The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to select ranges in a worksheet.. criteria (required). A number, expression, cell reference, or text string that determines which cells will be counted.
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 2019 for Mac, Excel 2016
TEXT function - Microsoft Support
Note: The TEXT function converts numbers to text, which may make it difficult to reference in later calculations.It’s best to keep your original value in one cell, and then use the TEXT function in another cell. Then, if you need to build other formulas, always reference the original value and not the TEXT function result.
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 2019 for Mac, Excel 2016
Change or reset your password - Microsoft Support
Important: Microsoft accounts, the Windows operating system, and other Microsoft products include passwords to help secure your information.This article provides some options that you can use to reset or recover your password if you forget it. Be aware that, if these options don’t work, Microsoft support can't help you retrieve or circumvent a lost or forgotten password.
Excel not responding, hangs, freezes or stops working
Important: The Assistant will, in most cases, modify the registry and move files from startup folders used by Excel. Before you run the Assistant, make sure that you back up the registry and all files in startup folders used by Excel so that you can restore the registry and backed-up files if a problem occurs.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Mouse and Keyboard Center download - Microsoft Support
The Microsoft Mouse and Keyboard Center is an app that helps you make the most out of your Microsoft keyboard and mouse. Mouse and Keyboard Center helps you personalize and customize how you work on your PC.
Create or edit a hyperlink - Microsoft Support
To create a new, blank file and link to it, click Create New Document under Link to, type a name for the new file, and either use the location shown under Full path or browse to a different save location by clicking Change.You can also choose whether to Edit the new document later or open and Edit the new document now.
Applies To: Word for Microsoft 365, Outlook for Microsoft 365, Project Online Desktop Client, Word 2021, Outlook 2021, Project Professional 2021, Project Standard 2021, Word 2019, Outlook 2019, Project Professional 2019, Project Standard 2019, Word 2016, Outlook 2016, Project Professional 2016, Project Standard 2016, Office 2016, InfoPath 2013, InfoPath Filler 2013
Change privacy settings in Windows - Microsoft Support
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Insert a signature - Microsoft Support
Scan the page and save it on your computer in a common file format: .bmp, .jpg, or .png. For information on how to use your scanner, use the manufacturer’s manual or Web site.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
检查你的 DirectX 版本 - Microsoft 支持
检查你的版本. DirectX 是许多 Windows 游戏都需要的一种多媒体技术套件。 如果你的电脑未安装正确版本的 DirectX(产品包装盒上应标有所需的版本),游戏可能无法正常运行。