Create a named range from selected cells in an Excel worksheet
You can quickly create a named range using the currently selected range in your Excel worksheet.
Define and use names in formulas - Microsoft Support
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 …
Create a histogram - Microsoft Support
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 …
Use the Name Manager in Excel - Microsoft Support
The Name Manager dialog box is a central place to manage named ranges in your Excel spreadsheet.
Select data for a chart - Microsoft Support
Learn best ways to select a range of data to create a chart, and how that data needs to be arranged for specific charts.
Filter data in a range or table in Excel - Microsoft Support
How to use AutoFilter in Excel to find and work with a subset of data in a range of cells or table.
Create and format tables - Microsoft Support
Learn about the many ways to create a table in an Excel worksheet, and how to clear data, formatting, or table functionality from a table in Excel. Discover more in this video.
Dynamic array formulas and spilled array behavior - Microsoft …
Spilled array formulas are not supported in Excel tables themselves, so you should place them in the grid outside of the Table. Tables are best suited to holding rows and columns of …
Create a list of sequential dates - Microsoft Support
You can quickly create a list of dates, in sequential order, by using the Fill Handle or the Fill command.
Create a PivotTable to analyze worksheet data - Microsoft Support
How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.