Grupo | search
Click here to view Grupo news from 60+ newspapers.
Bookmark or Share- Create a named range from selected cells in a worksheetYou can quickly create a named range by using a selection of cells in the worksheet. Note: Named ranges that are created from selecting cells have a workbook-level scope. Select the range you want to name, including the row or column labels. Click Formulas > Create from Selection.
- Using IF with AND, OR, and NOT functions in ExcelIn Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.
- Group or ungroup data in a PivotTable - Microsoft SupportGroup or ungroup data in a PivotTable. Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list date and time fields in the PivotTable into quarters and months. Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities.
- Group rows of data (Power Query) - Microsoft SupportIn the Query Editor, you can group the values in various rows into a single value by grouping the rows according to the values in one or more columns. Power Query has two types of Group By operations: aggregate a column with an aggregate function, or perform a row operation.
- Share your Microsoft 365 Family subscription - Microsoft SupportMicrosoft 365 Family subscribers can share subscription benefits with up to five other people in their family group by sending an email or copying & sharing a link. Sharing is only possible if the invitee joins the subscription owners' family group.
More
