Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

Launch Excel and open a blank sheet. Name the table as shown in the image and enter the values corresponding to the names. Next, to define a name for a cell select it.

What is a pivot table, and why should you create one? Before we dive into pivot tables in Excel, letâ s have a quick word about it. A pivot table is a powerful tool in Excel to summarize and ...