This article describes the formula syntax and usage of the AVERAGEIFS function, which returns the average (arithmetic mean) of all cells that meet multiple criteria.

Click Save, and then under Save workbooks, enter the path to the personal templates location in the Default personal templates location box.. This path is typically: C:\Users\[UserName]\Documents\Custom Office Templates.

Get answers to all of your Microsoft Word questions. Find Word help, how-to articles, training videos, tutorials, and more.

Training: Watch and learn how to create a PowerPoint presentation, add/format text, and add pictures, shapes, and/or charts.

Because OneDrive files stored in different places in Microsoft 365 for home and Microsoft 365 for business subscriptions, you’ll probably want to migrate some, or all of your files stored in OneDrive to the Microsoft 365 for business subscription that you choose.All Microsoft 365 for business plans include OneDrive for business, which provides 1 terabyte of online file storage for each user.

Tip: If you're a Microsoft 365 Family or Personal subscriber you get Microsoft Defender, our advanced security software for Windows, Mac, iOS, and Android, as part of your subscription.Learn more at Getting started with Microsoft Defender.

You can use the Advanced Filter dialog box to extract the unique values from a column of data and paste them to a new location. Then you can use the ROWS function to count the number of items in the new range.. Select the range of cells, or make sure the active cell is in a table. Make sure the range of cells has a column heading.

Argument. Description. start_date . Required. A date that represents the first, or starting date of a given period. Dates may be entered as text strings within quotation marks (for example, "2001/1/30"), as serial numbers (for example, 36921, which represents January 30, 2001, if you're using the 1900 date system), or as the results of other formulas or functions (for example, DATEVALUE("2001 ...

Features with audio and video functionality.. Many features that come as part of Windows can be used to view or play video or audio content, such as the OneNote app which allows users to record or play audio, the Microsoft Edge web browser which can play internet-based media content, the Photos app, the OneDrive app, and others.

Alternate method to find, edit, and delete custom templates using the Pages library. Page templates are copies of pages stored in a draft state in the Templates folder in the Pages library. Template pages are not published; only the pages created from the templates can be published.