Excel functions (alphabetical) - Microsoft Support
Function name. Type and description. ABS function. Math and trigonometry: Returns the absolute value of a number ACCRINT function. Financial: Returns the accrued interest for a security that pays periodic interest ACCRINTM function. Financial: Returns the accrued interest for a security that pays interest at maturity ACOS function. Math and trigonometry: Returns the arccosine of a number
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, Excel Web App
Leave family group or remove members - Microsoft Support
There are several different ways for family members and organizers to leave or be removed from a Microsoft family group depending on their role. Before leaving, family members and organizers should remove saved places and location alerts they would not like to remain in the group. Location alerts must be removed by the individual who set them for saved places to be deleted.
How to go passwordless with your Microsoft account
Going passwordless refers to removing your password and using a passwordless method to sign in instead. Passwordless solutions such as Windows Hello, the Microsoft Authenticator app, SMS or Email codes, and physical security keys provide a more secure and convenient sign-in method. While passwords can be guessed, stolen, or phished, only you can provide fingerprint authentication, or provide ...
Applies To: Microsoft account dashboard
从“文件”菜单打开文件 - Microsoft 支持
提示: 如果要绕过“文件”>“打开”并始终使用“打开”对话框,请执行此操作:选择“文件 > 选项 > 保存”,然后选择“打开或保存文件时不显示 Backstage”框检查。然后,关闭所有打开的 Office 应用程序再重新打开。 请注意,此更改仅影响按 Ctrl+O 访问“打开文件”对话框时看到的内容。
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Excel 2021 for Mac, Word 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2019 for Mac, Word 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016
Managing parental consent - Microsoft Support
Helping users safely navigate web, app, and game content is one of Microsoft’s top priorities. If you live in a region that requires permission to create an account and access Microsoft services, you may be prompted to request or give parental consent.
Applies To: Microsoft account dashboard
Add, change, or remove error bars in a chart - Microsoft Support
On the Chart Design tab, click Add Chart Element, point to Up/Down Bars, and then click Up/down Bars.. Depending on the chart type, some options may not be available.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Excel 2021 for Mac, Word 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2019 for Mac, Word 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016
Windows Installer 4.5 is available - Microsoft Support
The following new and improved features have been implemented in Windows Installer 4.5. Multiple package transactionIn a multiple package transaction, you can create a single transaction from multiple packages.
SUBTOTAL function - Microsoft Support
This article describes the formula syntax and usage of the SUBTOTAL function in Microsoft Excel.. Description. Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.
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
Add a device to a Windows 10 PC - Microsoft Support
Windows 10 usually finds devices automatically when you plug them in or turn them on. If it doesn't, follow these steps: Select Start > Settings > Devices > Bluetooth & other devices.
Use the Analysis ToolPak to perform complex data analysis
The CORREL and PEARSON worksheet functions both calculate the correlation coefficient between two measurement variables when measurements on each variable are observed for each of N subjects. (Any missing observation for any subject causes that subject to be ignored in the analysis.) The Correlation analysis tool is particularly useful when there are more than two measurement variables for ...
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