SUMIFS function - Microsoft Support
Argument name. Description. Sum_range (required). The range of cells to sum. Criteria_range1 (required). The range that is tested using Criteria1.. Criteria_range1 and Criteria1 set up a search pair whereby a range is searched for specific criteria. Once items in the range are found, their corresponding values in Sum_range are added.. Criteria1 (required)
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
View, manage, and install add-ins for Excel, PowerPoint, and Word ...
When you enable an add-in, it adds custom commands and new features to Microsoft 365 programs that help increase your productivity. Because add-ins can be used by attackers to do harm to your computer, you can use add-in security settings to help protect yourself.
Applies To: Excel for Microsoft 365, Word 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 for the web, Word for the web, PowerPoint for the web, Excel 2021, Word 2021, PowerPoint 2021, Excel 2021 for Mac, Word 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, PowerPoint 2019, Excel 2019 for Mac, Word 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, PowerPoint 2016, InfoPath 2013
Use voice typing to talk instead of type on your PC
To Insert this. Say this ' 撇 號 . 上 標 點 . 略 縮 號 -減 號 . 連 字 號 ! 感 歎 號 . 驚 嘆 號 # 井 字 號 $ 美 元 符 號 % 百 分 號
Install Office apps from Office 365 - Microsoft Support
After you've signed up for Microsoft 365, you and your employees can install your Office apps. From the admin center, select Office software.. Choose a language, and then select Install.. When prompted, select Run.. Select Yes to allow the app to make changes to your device.. The installation may take several minutes, depending on your Internet speed.
Troubleshoot problems with Microsoft Authenticator
Tips: If you're using mobile data, try switching to Wi-Fi and vice-versa. Make sure Airplane mode is off.
Repair Outlook Data Files (.pst and .ost) - Microsoft Support
Note: The scan creates a backup file during the repair process.To change the default name or location of this backup file, in the Enter name of backup file box, enter a new name, or choose Browse to select the file you want to use. You may need to run the tool several times in order to repair your Outlook Data File.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Automatically fix Windows security issues - Microsoft Support
Follow these steps to automatically diagnose and repair Windows security problems by turning on UAC, DEP protection, Windows Firewall, and other Windows security options and features.
Your CD or DVD drive is not recognized by Windows or other programs
Windows cannot start this hardware device because its configuration information (in the registry) is incomplete or damaged. (Code 19)
Find and lock a lost Windows device - Microsoft Support
Turn on Find my device. When you set up a new device, you can decide whether to turn on or turn off the Find my device setting. If you turned it off during setup and now want to turn it on, make sure your Windows device is connected to the internet, has enough battery power so it can send its location, and that you're signed in to the device using your Microsoft account.
Applies To: Microsoft account dashboard
Install Quick Assist - Microsoft Support
To pin Quick Assist to your taskbar so you can quickly get back to it, after Quick Assist is open, right-click (or press and hold) the icon on your taskbar > Pin to taskbar. If the old app icon still appears on your device, make sure you select the new app icon.