Use an outline to group data and quickly display summary rows or columns, or to reveal the detail data for each group.

The GROUPBY function allows you to group, aggregate, sort, and filter data based on the fields you specify. The syntax of the GROUPBY function is: …

Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or …

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

Using functions and nested functions in Excel formulas. Define and use names in formulas. Guidelines and examples of array formulas. Delete or remove a formula. How to avoid broken …

Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links …

You can count the number of values in a range or table by using a simple formula, selecting a button, or by using a worksheet function. Excel can also display the count of the number of …

Microsoft Excel provides several controls for dialog sheets that are useful for selecting items from a list. Examples of controls are list boxes, combo boxes, spin buttons, and scroll bars.

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 …

By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of …