ou’d like to see the quarterly sales plus totals by sales person, uncheck City and check Sales Person. The report drops in.
4. Next, click Sales Person, click the down arrow, then uncheck Select All in the Sort-Filter Options dialog box. Click four names on the list, click OK, and the filtered report drops in.
The Pivot Tables/database options are endless. There are numerous ways to analyze the data, create and manage sets, group fields, insert slicers and timelines, drill up and down, and import and export data, as well as design reports with custom layouts and styles, create hundreds of colorful charts, then print it all out for distribution.
Charts and styles
To spice up your table before you print it, try adding a chart and/or some colors and style to the table.
To add a chart, highlight the table, select Pivot Table Tools > Analyze > Tools > Pivot Chart, then select a chart from the gallery of charts, and click OK.
To add colors and style, select Pivot Table Tools > Design > Pivot Table Styles and choose a table design from the gallery of styles. Click Banded Rows under the Pivot Table Style Options group to alternate colors and/or shading on the odd and even rows for easier viewing. And that’s all there is to it.
With this new relational database/table feature, this process is so easy that once it's set up in Excel, you can extract specific data and create dozens of reports in minutes.