INDEX function - Microsoft Support
Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.
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
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
Error 0xC0000142 when you start an Office application
Note: If you have a suite such as Microsoft 365 Family, Office Home & Student 2016, or Office Home and Student 2013, search for the suite name, even if it's just a particular application you want to repair such as Word or Excel.If you have a standalone application such as Word or Excel, search for the application name.
Options for using Windows 11 with Mac® computers with Apple® M1®, M2 ...
Virtualization-based Security (VBS), which enables customers to create and isolate a secure region of memory from the normal operating system. 32-bit Arm apps available from the Store in Windows are not supported by Mac computers with M1, M2, and M3 chips. 32-bit Arm apps are in the process of being deprecated for all Arm versions of Windows ...
Device protection in Windows Security - Microsoft Support
Windows Security provides built-in security options to help protect your device from malicious software attacks. To access the features described below, tap the Windows Start button, type windows security, select it from the results, and then select Device security.
Hide or Unhide worksheets - Microsoft Support
To select. Do this. A single sheet. Click the sheet tab. If you don't see the tab that you want, click the scrolling buttons to the left of the sheet tabs to display the tab, and then click the tab.
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
文字列として保存されている数値を数値形式に変換する - Microsoft サポート
数値が文字列として実際にセルに保存されていると、計算や並べ変えで問題が発生する可能性があります。 この記事では、この問題を解決する方法について説明します。
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 Startup Settings (including safe mode) - Microsoft Support
Safe mode starts Windows with a minimal set of drivers and services to help troubleshoot issues. If a problem doesn't reappear when you start your PC in safe mode, you can eliminate the default settings and basic device drivers and services as possible causes.
在电脑或 Mac 上下载并安装或重新安装 Microsoft 365 或 Office 2021 - Microsoft 支持
准备好安装了吗? 在开始之前,请确保电脑或 Mac 满足 系统要求。. 如果你已兑换产品密钥,只需重新安装应用,或者知道你已通过工作或学校分配了许可证,则可以跳到登录部分 ,下载并安装 Microsoft 365 或 Office。 但是,如果是 首次 安装 Microsoft 365 或 Office,可能需要先执行一些步骤。
Applies To: Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Admin, Microsoft 365 for Mac, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin, Office.com
Manage email messages by using rules - Microsoft Support
There are two types of rules in Outlook—server-based and client-only. Server-based rules When you're using a Microsoft Exchange Server account, some rules are server-based.These rules run on your mailbox on the Exchange mail server even when Outlook isn’t running.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016