To create the first subgroup for Q1, select columns B to D, and click Outline > Group in the Data tab on the ribbon. Now, Excel has added an extra grouping indicator line and minus symbol above ...

To create a search field in a spreadsheet, you must first activate the Developer tools menu. To do this, go to Options > ...

To create a chart, first select the cells you want to include. In some cases, you may need to format your cells a certain way for Excel to understand them, but you can read about how to format ...

Step 1: Select the cell in the column where you want to input a drop-down list. Step 2: Go to the Data tab and select the Data validation button or choose Data validation from the drop-down menu ...

Step 2: To sort using one of the buttons, select your column or table. In this case, we're using the second table in the sample spreadsheet. Image used with permission by copyright holder ...