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 useful arrangements. Many organizations gather large amounts of digital data, but as you know, data is only useful if it has been organized in a way that reveals patterns or trends. You will also be able to extract insights from data by organizing data into groups based on comparisons, patterns, and trends. You will be able to subtotal and total numerical data and summarize data by categories and subcategories. PivotTable is just another name for Excel's PivotTable report. The PivotTable Report is an interactive, crosstab Excel report for summarizing and analyzing large amounts of data. Did you know that PivotTable Report, also known as PivotTable, can be used to analyze and summarize large data insights without using formulas? In Chapter 7, a PivotTable report displays the same data in one table in multiple layouts (Marks, 2011). Pivot tables can be used in many ways to move around; rotate and data fields from one place to another by drag and drop. There are several ways to look at the same data in different ways. For example, from a list of police officers at a police station, you can get a quick estimate of the number of calls they have received. This is useful when you want to analyze related totals, such as listing numbers to add and comparing facts about different totals. There are seven types of screen elements: PivotTable Field List, Report Filter Area, Column Label Area, Row Label Area, Value Area, Layout Section, and Section of fields. Many people may believe that there are several ways to place the data in your ...... middle of paper ...... h visual, the Trace Precedents command indicates which cell is affected, the selected cell an error The check command provides errors and explains why an error occurred. On the Excel document, if there is any invalid data, the data validation function can be applied and it instructs Excel to circle the invalid data. Finally, when you use the Watch Window to monitor, you can view specific cells and monitor worksheets whenever the formula or changes you make affect the result of the watch cells. That being said, these functions are important in any field one wishes to work in, such as auditing, banking or even running your own business; it provides more organization, accuracy, and an easy way to update data in case of future changes.Works CitedMarks, GV (2011). Excel 2010 complete. Upper Saddle River, New Jersey: Pearson Education Inc. .