COUNT function - Microsoft Support
The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20).In this example, if five of the cells in the range contain ...
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
IF function – nested formulas and avoiding pitfalls
Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False.
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, Excel for Windows Phone 10
Date and time functions (reference) - Microsoft Support
Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.
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
在 Windows 中查找 BitLocker 恢复密钥 - Microsoft 支持
个人设备的所有者或管理员激活了 BitLocker (在某些设备上也称为设备加密,) 通过“设置”应用或控制面板: 在这种情况下,激活 BitLocker 的用户选择了保存密钥的位置,或者在设备加密的情况下选择 (,) 自动将密钥保存到其 Microsoft 帐户。
Set your display for night time in Windows - Microsoft Support
To schedule night light so it turns on automatically: Select Start , then enter settings in the search box. Select Settings > System > Display > Night light. If your night light toggle is grayed out, you may need to update your display driver.
Using the Windows Activation troubleshooter - Microsoft Support
To activate using your digital license, you'll need to upgrade to Windows 11 Pro: Save your work and close any open apps.
Microsoft 365 Training
Get productive quickly with Microsoft 365 videos and tutorials. Explore Microsoft 365 training guides and tips to collaborate with anyone, anywhere.
Connect Surface to a TV, monitor, or projector - Microsoft Support
If your screen only has a Mini DisplayPort, you can set up the following connections—connect a USB-C to HDMI adapter to an HDMI cable then to an HDMI to Mini DisplayPort and then to your external screen. Keep in mind that the more adapters used, the more degraded the signal may get.
Get started with OneDrive (work or school) - Microsoft Support
Try it! OneDrive gives you one place to store, share, and sync your work or school files. As part of your organization's Microsoft 365 subscription, or SharePoint Server, you can save your files in OneDrive and then work with them from almost any device.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, OneDrive (work or school), OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
How to use the Out of Office or Automatic Reply in Outlook on Windows ...
Before you set up an out of office or automatic reply in Outlook, you'll need to know your Outlook account type. The steps you'll follow will depend on whether you have a Microsoft Exchange Outlook email account (if you have email through an organization, such as the place where you work) or an IMAP or POP3 account (if you have an individual email account such as Yahoo or Gmail).