You can quickly create a named range using the currently selected range in your Excel worksheet.

You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names.

The Name Manager dialog box is a central place to manage named ranges in your Excel spreadsheet.

You type the advanced criteria in a separate criteria range on the worksheet and above the range of cells or table that you want to filter. Microsoft Office Excel uses the separate criteria range in the …

To create a histogram in Excel, you provide two types of data — the data that you want to analyze, and the bin numbers that represent the intervals by which you want to measure the frequency.

Learn best ways to select a range of data to create a chart, and how that data needs to be arranged for specific charts.

A print area is one or more ranges of cells that you designate to print when you don't want to print the entire worksheet. When you print a worksheet after defining a print area, only the print area is printed.

You can quickly create a list of dates, in sequential order, by using the Fill Handle or the Fill command.

How to use AutoFilter in Excel to find and work with a subset of data in a range of cells or table.

How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.