Using Figure E as a guide, add the additional controls listed in Table A and name them. The labels aren’t necessary on this simple example, but when creating a UserForm for your own data, you ...

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Open an Excel sheet with relevant data. Select Analyze Data at the top and Excel automatically selects the table on your sheet. You can check suggested pivot tables and charts from the side menu.