The GROUPBY function in Excel allows you to create a summary of your data via a formula.

To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns. To insert multiple columns: Select the same …

If you want to rotate your data frequently to view it from different angles, consider creating a PivotTable so that you can quickly pivot your data by dragging fields from the Rows area to the …

Check boxes are a versatile feature in Excel, useful for making interactive lists and forms. In this article, we'll cover how to add, remove, and toggle them. Insert check boxes Select the range …

You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.

How to use the INDEX function in Excel to return a value or reference to a value within a table or range.

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

The PIVOTBY function allows you to create a summary of your data via a formula. It supports grouping along two axis and aggregating the associated values. For instance, if you had a …

There are two ways to apply shading to alternate rows or columns —you can apply the shading by using a simple conditional formatting formula, or you can apply a predefined Excel table style …

If you format the range of names as an Excel table, then the formula will automatically update when you add or remove names. If you want to sort the list of names, you can add the SORT …