This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: To: John Blutarsky Date: September 10, 2009 Subject: Project 1 – Preview Assignment As assigned, my firm and I have analyzed the data that exists in the various divisions of your corporation. The process we took to analyze the data you receive from the corporate database was by the use of pivot tables. PivotTable PivotTables are beneficial for corporations and for decision making because they allow the creation of multidimensional data views. This is able to be done by dragging and dropping column headings to move data around; therefore, allowing the user to view only the data he/she wants to display at the time. PivotTables in Microsoft Excel To create a PivotTable, you first begin by placing your cursor in any cell in which the data is located. Next, you navigate to the insert tab at the top of your screen and from there you click PivotTable. Finally, you can modify the PivotTable by selecting only the information necessary for your purpose. The information is then shown in the form of rows and columns. Decision-Making PivotTables are useful in decision-making because they allow the user to perform calculations, assort data, and present the data in a clear and concise way. assort data, and present the data in a clear and concise way....
View Full Document
- Spring '08
- PivotTable, highest average score, highest average value