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)

Offline access in the new Outlook for Windows You can use the new Outlook for Windows even when you’re not connected to the internet by enabling offline access.

Notes: To get to desktop icon settings in Windows 8.1, swipe in from the right edge of the screen, then select Search.Type desktop icons in the search box, and then select Show or hide common icons on the desktop.

Microsoft account help and support. Get help with signing in, locked or compromised accounts, linked accounts, closing, reopening, and updating your security info and account profile.

Tip: If you don’t like the name of the template (usually Book 1), click the name in the Excel for the web title bar at the top of the page and type a different name.

Send in your Surface. If none of the previous solutions have resolved your issue, you can send in your Surface. If you decide to send it in, go to Device service and repair and sign in with your Microsoft account. If your device is already registered, select it and follow the instructions.

Prerequisites The PC must have 250 MB of free space in the recovery partition to apply this update successfully. Restart information You do not need to restart your device after applying this update.

Data sources. Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. Excel spreadsheets and Outlook contact lists are the most common data sources, but if you don't yet have a data source, you can type it up in Word, as part of the mail merge process.

To change appearance, select Appearance and make the changes you want to your default theme, zoom, toolbar, and fonts.

To learn more, check out the Join a Teams meeting video. Join by link. All you need to join a Teams meeting is a link. Select Join the meeting now in your meeting invite to be taken to a page where you can choose to either join on the web or download the desktop app.. If you already have the Teams app, the meeting will open there automatically.