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
Share and access a view-only calendar in Outlook
Notes: If your email account uses Exchange, you will see Publish This Calendar, instead of the option to publish to a WebDAV server.This lets you publish your calendar directly to an Exchange Server. In the window that opens, select the publishing options you want, and click Start Publishing.. If you're using Microsoft 365, you can still publish your calendar to a WebDAV server, but you must ...
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin, Outlook on the web, New Outlook for Windows
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
How to use the PC Health Check app - Microsoft Support
Note: If a compatibility issue has been identified on your device that would disrupt your experience using Windows 11, we will temporarily delay your upgrade until the issue is resolved.Compatibility safeguard holds help ensure you have the best experience possible when upgrading and your productivity is not disrupted if critical apps or drivers are not yet compatible.
Add or subtract dates - Microsoft Support
Add or subtract months from a date with the EDATE function. You can use the EDATE function to quickly add or subtract months from a date.. The EDATE function requires two arguments: the start date and the number of months that you want to add or subtract. To subtract months, enter a negative number as the second argument.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Pin and unpin apps to the Start menu - Microsoft Support
Pin the apps you use most often to the Start menu. Here's how: Select Start from the taskbar, then find the app you want to pin in the list or search for it by typing the app name in the search box.
Open and run DxDiag.exe - Microsoft Support
Learn how to open and run DxDiag.exe on Windows to collect device information and troubleshoot DirectX sound and video issues.
PC TPM 2.0 - Microsoft
2021 年 8 月公開. この記事は、PC で TPM 2.0 が有効になっていない、または PC に TPM 2.0 を実行する機能はあっても、実行するように設定されていないために Windows 11 にアップグレードできないユーザーを対象としています。
Introduction to lists - Microsoft Support
The following are some ways you can work with lists to help you to manage information for your group. Track versions and detailed history Track versions of list items, so that you can see which items have changed from version to version, as well as who changed the list items.If mistakes are made in a newer version, you can restore a previous version of an item.
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013, SharePoint in Microsoft 365, Microsoft Lists
Add a poll to your Teams channel or chat - Microsoft Support
With Microsoft Forms, you can create an instant, real time poll in seconds in Microsoft Teams. Post a poll in your Teams channel or quickly gather feedback in a chat pane.
Applies To: Microsoft Forms, Microsoft Teams