Accessing and Analyzing Data with Microsoft Excel (Bpg-Other)

In this chapter, you learned:

• PivotTable reports and PivotChart reports are helpful in analyzing data that consists of thousands of data records or more. These reports can quickly summarize your data for faster business decision making.

• The PivotTable And PivotChart Report Wizard step you through the process of creating PivotTable reports and PivotChart reports. Once the reports are created, you can use the PivotTable field list, the PivotTable toolbar, and the PivotTable shortcut menu to graphically modify the reports.

• You can also filter PivotTable report fields, as well as create calculated fields and calculated items in a PivotTable report for more advanced data analysis.

In the next chapter, “Analyzing Data with Microsoft Access,” you will learn

• The differences between relational and nonrelational data.

• How to import and link Access databases to external data sources.

• How to filter, sort, and query data in Access.

• How to create Access reports.

• How to analyze data by using Access PivotTable and PivotChart views.