Pivot Tables and Pivot Charts

825 Words2 Pages

In Chapter 7, you will be able to create a PivotTable report and a PivotChart report so that you can organize and display data in valuable arrangements. There are many organizations that gather large amounts of numerical data, but as you know the data is not useful until it have been organized in a fashion that it will reveals patterns or trends. You will also be able to extract information from data by organizing the data into groups from the comparisons, patterns, and trends. You will be able to subtotal and total numeric data and summarize the data by categories and subcategories. PivotTable is just another name for the Excel’s PivotTable report. The PivotTable report is an interactive, cross-tabulated the Excel report to summarizes and analyzes large quantities of data.
Did you know PivotTable report also known as a PivotTable can be used to analyze and summarize large information of data without the use of formulas? In Chapter 7, a pivot table report shows the same data in a table in more than one arrangement (Marks, 2011). PivotTables can be used in numerous ways to move; pivot, and fields of data from one place to another using drag and drop. There are several of ways you can look at the same data in a number of different ways. For example, from a list of cops in a police station, you can get a quick estimation of how many calls they received. It is useful when you want to analyze related totals, like the list of numbers to sum and compare facts about different total. There are seven types of screen elements: pivot table field list, report filter area, column labels area, row labels area, values area, layout section, and field section. Several of people may believe there are several of ways to place the data from your...

... middle of paper ...

...h visual, Trace Precedents command tells what cell is affected , the cell that is selected an error checking command provides errors and gives explanations for why there was an error. On the excel document if there is an invalid data, data validation function can be applied and it instructs excel to circle invalid data. Lastly, when using watch window to monitor, you are able to view specific cells and monitor worksheets as soon as formula or changes that are made, that affect the outcome of watch cells. With that being said, these functions are important in any field ones desires to be in such as auditing, banking, or even running your own company; it gives more organization, accuracy and easy way to update any data if there are future changes.

Works Cited

Marks, G. V. (2011). Excel 2010 Comprehensive . Upper Saddle River, New Jersey: Pearson Education Inc. .

Open Document