Answering this question could be very time-consuming and difficult-each salesperson appears on multiple rows, and we would need to total all of their different orders individually. Using PivotTables to answer questions Suppose we wanted to answer the question: "What is the amount sold by each salesperson?" for the sales data in the example below. PivotTables can help make your worksheets more manageable by summarizing data and allowing you to manipulate it in different ways. Pivot Tables When you have a lot of data, it can sometimes be difficult to analyze all of the information in your worksheet. Prerequisite Comfortable with Windows 7, or OSX Platform Windows, OSX Software Microsoft Excel 2013, Microsoft Excel 2010 (Windows) Microsoft Excel 2011 (MAC) Instructor Anna Neagu – Application Support Consultant Topics Include Ĭreating a Pivot Table Analysing Data using Pivots Filtering and Slicers Creating a Pivot Chart Report Working with multiple Values Areas This course will give you the skills to use a Pivot Table to produce meaningful analysis and charts from a simple table of information. Introduction This tutorial covers creating and using a pivot table to extract different information from one data sample.
0 Comments
Leave a Reply. |